292 results for Postgres · 2.383s

News for “Postgres”
20 results • 2376 ms server time
Show HN: Xenoeye – analyze network without AI using netflow, PostgreSQL, GrafanaIMAGE
github.com• Jun 29, 2026• 1 min read
Show HN: Xenoeye – analyze network without AI using netflow, PostgreSQL, GrafanaSorry for the slightly truncated title. It should have been "Network traffic analysis and monitoring without AI, using netflow-family protocols, PostgreSQL or ClickHouse, Grafana, and some scripts".In 2026, it might seem a bit presumptuous to announce AI-free software on HN. But building a netflow analyzer manually is no less presumptuous!There are quite a few xFlow analyzers out there these days, and I'm constantly reminded of this. But I think there's always room for an alternative approach. After all, that's how software evolves, isn't it?So, how does xenoeye differ from popular (at least from popular open source) analyzers?- The analyzer has a feature called "monitoring objects". For some reason, open-source analyzers rarely use this feature, while commercial ones do. The monitoring object can be a subnet, autonomous system, geo-object (data on geo and AS are taken from external databases), application traffic (protocol, TCP/UDP ports, etc.), VLAN, etc. Almost everything in flow re
Show HN: PgDog – Scale Postgres without changing the appIMAGE
github.com• Feb 23, 2026• 1 min read
Show HN: PgDog – Scale Postgres without changing the appHey HN! Lev and Justin here, authors of PgDog (https://pgdog.dev/), a connection pooler, load balancer and database sharder for PostgreSQL. If you build apps with a lot of traffic, you know the first thing to break is the database. We are solving this with a network proxy that works without requiring application code changes or database migrations.Our post from last year: https://news.ycombinator.com/item?id=44099187The most important update: we are in production. Sharding is used a lot, with direct-to-shard queries (one shard per query) working pretty much all the time. Cross-shard (or multi-database) queries are still a work in progress, but we are making headway.Aggregate functions like count(), min(), max(), avg(), stddev() and variance() are working, without refactoring the app. PgDog calculates the aggregate in-transit, while transparently rewriting queries to fetch any missing info. For example, multi-database average calculation requires a total count of rows to calculate the o
Show HN: Mochia, a virtual pet browser game, built with Rust, SolidJS, PostgresIMAGE
mochia.net• Jul 3, 2025• 1 min read
Show HN: Mochia, a virtual pet browser game, built with Rust, SolidJS, PostgresAround three years ago, I was reminiscing about how much I loved playing Neopets as a kid. Meanwhile, I was also looking for a project to better learn Rust and SolidJS. So.. I figured making my own virtual pet browser game would be a fun way to practice! Since then, I’ve been working on it nearly every day, and.. it’s grown quite a bit! Here are some bulleted lists for your convenience:Technical Details: * Backend monolithic Rust server runs on a single $5/month VPS * Lean frontend with just 3 dependencies (SolidJS, Solid Router, and Mutative) * Around 130,000 combined lines of code (frontend + backend) * Rust server uses axum, sqlx, tokio, rand, strum, tungstenite (websockets) * No server crashes or data loss in 3 years (thank you Rust + Postgres!) * Almost all graphics (500+ assets) are SVGs for perfect detail at every zoom level * Fully mobile responsive and playable on all modern browsers and devices * Actor model for player actions enables trivial parallel, multi-core scaling * Si
Moozonian News
bing.com• 3d ago• 1 min read
How to use order by, limit, and offset in PostgreSQLPostgreSQL ORDER BY, LIMIT, and OFFSET make it easier to organize and control query results, with ORDER BY being especially useful for everyday data analysis. This lesson demonstrates how to sort ...
Advertisement
Advertisement
Advertisement
Moozonian News
github.com• Aug 11, 2026• 1 min read
Show HN: Dbctx – Compile a PostgreSQL database into compact, queryable contextHi HN, I've been finding increasing need for helping our users chat with the underlying application data in postgresql directly using LLMs, visualize results and so on.A major obstacle to this is -- traditional sql schema doesn't contain enough information for an LLM to easily query things in one shot.For example, traditional schema doesn't say what is the expected/allowed value set in a state field, or what are the paths available embedded in a jsonb field.Also -- given a user query -- only a small fraction of the whole schema is relevant for an LLM to construct SQL queries. So filtering parts of schema relevant to construct a prompt is important.dbctx solves all these by inspecting a postgresql database and turning the results into an sqlite backed ".dtx" file. You can pass your natural language query to dtx, and get relevant tables in a compressed schema format along with field/json intelligence embedded in it. This leads to much better responses from the LLM from the getgo.I have a