#query — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #query, aggregated by home.social.
-
Query InfluxDB programmatically via its HTTP API. InfluxDB 1.x uses /query with GET/POST & q param; InfluxDB 2.x uses /api/v2/query with Flux & POST. Export results as JSON or CSV. Full guide: #influxdb #api #query
https://www.valtersit.com/vault/using-influxdbs-http-api-for-programmatic-query-execution-an-d0dbbe/
-
Hours before going for vacation it occurred to me, that my work on #Neo4j #VirtualGraph has been nothing but a continuation of what I am doing now for way over a decade: Enjoying myself a bit of #query languages AND #ObjectMapping
Neo4j Virtual Graph might be the last #ORM you ever need: It maps your relational data not into a somewhat boring object graph, but a property graph that can be queried in not all, but a lot of great ways that only #Cypher lets you.
-
Hours before going for vacation it occurred to me, that my work on #Neo4j #VirtualGraph has been nothing but a continuation of what I am doing now for way over a decade: Enjoying myself a bit of #query languages AND #ObjectMapping
Neo4j Virtual Graph might be the last #ORM you ever need: It maps your relational data not into a somewhat boring object graph, but a property graph that can be queried in not all, but a lot of great ways that only #Cypher lets you.
-
Evaluation order and nontermination in query languages
https://www.rntz.net/post/2026-06-11-datalog-nontermination.html
Comments: https://news.ycombinator.com/item?id=48757619
#HackerNews #evaluation #order #nontermination #query #languages #datalog #programming #languages
-
HTTP получил метод QUERY: зачем понадобился безопасный запрос с телом
В июне 2026 года опубликован RFC 10008 — «The HTTP QUERY Method». Он добавил в HTTP новый стандартизованный метод QUERY , который также появился в реестре HTTP‑методов IANA : запрос с телом к конкретному адресу, который по смыслу остаётся чтением и не должен менять данные на сервере. Метод нужен для давно знакомого случая: нужно передать сложные параметры поиска, фильтрации или отчёта, а по семантике это всё ещё безопасная операция чтения. Обычный GET для таких запросов часто неудобен: параметры быстро превращаются в длинный URI или в собственный мини‑язык фильтрации внутри строки запроса. POST удобнее для передачи структуры, но передаёт не тот сигнал промежуточной инфраструктуре. Приглашаю посмотреть, что там в RFC напридумывали, и чем нам это грозит — и чем поможет! Что же это за зверь, QUERY?
https://habr.com/ru/articles/1055310/
#HTTP #QUERY #RFC_10008 #GET #POST #REST_API #http_методы #http_семантика
-
The new HTTP QUERY method explained
https://kreya.app/blog/new-http-query-method-explained/
#HackerNews #HTTP #QUERY #method #webdevelopment #technews #programming #HTTP
-
RFC 10008: The new HTTP Query Method
https://www.rfc-editor.org/info/rfc10008/
#HackerNews #RFC10008 #HTTP #Query #Method #web #standards #tech #news
-
Finding an Agent and Publication (Much) Sooner Than Expected
Not every success story is the same, as evidenced by Becky Jenkinson's tale of finding an agent and publication (much) sooner than expected.
The post Finding an Agent and Publication (Much) Sooner Than Expected appeared first on Writer's Digest.
https://www.writersdigest.com/finding-an-agent-and-publication-much-sooner-than-expected#BusinessofWriting #GetPublished #getpublished #LiteraryAgent #query
-
databow: a Rust CLI to query any database with an ADBC driver
https://columnar.tech/blog/introducing-databow//
#HackerNews #databow #Rust #CLI #ADBC #database #query #tech
-
A synopsis is not a query, blurb, or sales pitch. It is a play-by-play summary of the book.
Start with one sentence per scene. Expand the explanations where needed. Use connecting words like Then, Later, Elsewhere, After That, ect. Condense where needed to hit the required page limit.
-
Two wonderful post about #Cypher, the #Neo4j #query language
https://systay.github.io/posts/2026-04-30-i-just-wanted-a-query-planner/ by @systay
and
https://www.thobe.org/work/cypher/ by Tobias Lindaaker
-
violin injury rosin in eye
-
🚀 In a groundbreaking discovery akin to using a spoon as a shovel, the author attempts to shoehorn #CSS into the realm of #query #languages. 🤔 One might wonder, amidst the tangled web of curly braces and selectors, why not just use #SQL, a language that doesn't require a secret handshake to understand?
https://evdc.me/blog/css-query #Innovation #Debate #WebDevelopment #HackerNews #ngated -
[Перевод] REST умер? Почему Java-разработчики уходят в GraphQL
Один экран в приложении, а на бэкенде несколько REST-вызовов , куча эндпоинтов и ответы, где 90% полей не используются. Теряем в скорости, усложняется фронтенд и приходится версионировать контракт, когда меняется формат данных. GraphQL предлагает другой подход : один API-эндпоинт и запрос, в котором клиент сам указывает, какие поля ему нужны. Это снижает overfetching , уменьшает количество сетевых затрат и упрощает договоренности между фронтом и бэком за счет схемы как явного контракта и живой документации. В новом переводе от команды Spring АйО разберем, где GraphQL реально помогает : как уйти от разрастания эндпоинтов, как держать контракт синхронизированным и что делать с типичными проблемами производительности и наблюдаемости, когда данные собираются из разных источников.
https://habr.com/ru/companies/spring_aio/articles/1026130/
#java #kotlin #spring #graphql #api #query #database #системное_программирование #backend
-
Successful Queries: Sabrina Taitz and “Harmless,” by Miranda Shulman
In this installment of Successful Queries, agent Sabrina Taitz and author Miranda Shulman discuss the query behind her debut, Harmless.
The post Successful Queries: Sabrina Taitz and “Harmless,” by Miranda Shulman appeared first on Writer's Digest.
https://www.writersdigest.com/successful-queries-sabrina-taitz-and-harmless-by-miranda-shulman#GetPublished #WriteMyQuery #query #QueryAgents #successfulqueries
-
БАЗЫ ДАННЫХ db. SQL, REDIS, СУБД
Если серьезно, то сегодня мы поговорим про БАЗЫ данных. Как-то один мой друг разработчик сказал, что программирование можно понимать как
-
tl;dr Using https://thi.ng/column-store to accelerate tag intersection queries by a factor of 880x...
Working on the static website generator/export plugin for my personal knowledge tool has been one of the main projects this past month. A key part of this setup is tagging, not just simple flat keywords/categories, but actually treating tags as sets. The system doesn't just allow browsing content by a single tag, but also supports adding (or removing) tags to narrow or widen the current topic. E.g. The combination of "3d + geometry + typescript" would select only works which have all of these three tags...
In the local version of my tool there's no limit to the number of tags (and it also supports tag negation), but for the static site generation I have to limit the set size (due to combinatoric explosion) and pre-compute all possible permutations, then create HTML documents for each these individual combinations which actually produce results.
So far I'm having ~400 unique tags in use, meaning if I want to aim for a max set size of 3, there're theoretically ~64,000,000 possibilities to check[1]! For the roughly 3500 content items used for testing, a naive JS approach to filter the result array and only retain items matching the entire current permutation is so extremely slow, that I stopped the process after 3.5 minutes just for the first 250k (aka 0.4%) of the 64 million permutations, i.e. at that rate the full process would have taken ~15 hours, pretty slow for a SSG... :)
Naive approach 🫣:
```
permutation = ["3d", "geometry", "typescript"]
results.filter(item => permutation.every(tag => item.tags.includes(tag)))
```But since I'm using https://thi.ng/column-store as my database, such queries can be optimized by a few magnitudes, since here these intersection queries are applied only to bitfields (explained in the pkg readme). This results in all 64+ million permutations being processed in just 62 seconds (1+ million per second). Quite the difference, i.e. ~880x faster than the above approach!
Also, of these 64 million initial possibilities, there're fewer unique ones (excluding duplicates and ignoring ordering), and currently only ~24,000 are actually producing a result. Still, that's 24,000 index pages to generate & host and it's, of course, far, far too much!
So I will have to also spend more effort curating and severely reducing the tag vocabulary, at least the subset used for the website. On the other hand, I think this system will really help with browsing this large body/archive of work much more meaningfully than the boring single-tag/category approach most websites are offering. And it will do so without any backend (other than file hosting)...
[1] Permutations = 400 + 400^2 + 400^3
#ThingUmbrella #Tagging #Intersection #Query #Bitfield #WebDev #JavaScript #TypeScript #Optimization
-
CVE Alert: CVE-2026-4267 - johnbillion - Query Monitor – The developer tools panel for WordPress - https://www.redpacketsecurity.com/cve-alert-cve-2026-4267-johnbillion-query-monitor-the-developer-tools-panel-for-wordpress/
#OSINT #ThreatIntel #CyberSecurity #cve-2026-4267 #johnbillion #query-monitor-the-developer-tools-panel-for-wordpress
-
How to Stop MySQL From Scanning With FIND_IN_SET
FIND_IN_SET bypasses indexes and burns CPU.
-
How to Use Temporary Tables to Replace Slow Subqueries
Materialize once. Query fast.
-
when you get a #rejection on a #query that is more than 6 months old, that you already marked as rejected (on a project you have since shelved):
-
How to Prevent Full Table Scan on Partitioned Tables
Missing partition key = scan all.
-
Query: Is 128GB with 4GB RAM enough for a phone in 2026?
My old phone presented with a manufacturing defect that no one wants to fix so I perused the LineageOS Wiki and chose a phone from that: The Moto G 5G 2024.
Thankfully, it has an SD card slot. I'm hoping once the Google garbage is wiped off I'll have a bit more internal storage.
-
How to Stop MySQL From Skipping Indexes With !=
Not-equals can disable index range scans.
-
FYI: PostgreSQL JSONB: Query & Index Your Data! #shorts: Discover how PostgreSQL's JSONB field type can simplify handling and querying JSON data within your database. Learn how it indexes these fields for efficient data retrieval. #PostgreSQL #JSONB #database #query #indexing https://www.youtube.com/shorts/8giZMSjISo0
