#PgDog is a #network #proxy and it can see every byte sent between #Postgres and the clients. It understands #SQL and can infer where queries should go, without requiring changes to application code. In this article, we discuss how we handle the Postgres wire protocol and manipulate it to serve queries to multiple databases at the same time. https://pgdog.dev/blog/hacking-postgres-wire-protocol
#SQL best practices – don’t compare count(*) with 0 #postgresql – select * from depesz; https://www.depesz.com/2024/12/01/sql-best-practices-dont-compare-count-with-0/
SpacetimeDB is an interesting new type of relational database that I haven't quite wrapped my head around yet.
It is designed for real time massive multiplayer games and uses some sort event sourcing (CRDTs?) but has many more potential use cases than just games.
It works particularly well with .NET and C#. So I have cleaned up and simplified the C# quickstart sample.
Brex is hiring Senior Data Scientist, Finance
#python #sql #seniorengineer
New York City, New York
Full-time
Brex
Job details https://jobsfordevelopers.com/jobs/senior-data-scientist-finance-at-brex-com-mar-4-2025-55acd3?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Folks who prefer GROUP BY 1 instead of ORDER BY my_first_col why?
Ordering should be done last and you make me read one more abstraction (oh wait what is the first column).
For sure this is interesting. https://vanna.ai/ #VannaAI help you to #wirte #sql queries. it's is #openSource https://github.com/vanna-ai/vanna sounds other #ai interesting thing to test
Digital Toolbox: SQL
A domain-specific language used to manage data, especially in a relational database management system (RDBMS).
https://wadebach.blackcatwhitehatsecurity.com
#Digital #Toolbox #SQL
It's official - we are now a community-recognized NPO by the PostgreSQL Global Development Group!
What does this mean? 
We support the open source #PostgreSQL RDBMS as our primary mission, and manage our organization in accordance with the official PGDG Nonprofit Organizations policy. Learn more here:
New blog post:
In which I demo a query that lists object dependencies in SQL Server for either a specific object or for the entire database.
#sqlserver #sqldba #microsoftsqlserver #mssqlserver #mssql #mssqldba #sql
https://vladdba.com/2025/04/15/query-object-dependencies-sql-server/
DBeaver
DBeaver is a free and open-source database management tool that supports a wide range of databases, including MySQL, PostgreSQL, SQLite, Oracle, and many others.(...)
On June 12, join our CEO @c2main at 11:30 AM CEST for a FREE livestream @ @posetteconf regarding Pressure Stall Information within the world of #PostgreSQL.
Use this link to add the livestream to your calendar & optionally register, or follow us to get the recording after the conference when it becomes available!
posetteconf.com/2025/talks/resource-control-admission-i-have-a-date-with-my-psi/
Git Cheatsheet #coding #github #shortsvideo #viralvideo #shorts #programmer #coder #programming
developers #programming #coding #shortsvideo #java #programmer #reels #sql #coder #codewithmani #clanguage #python ... source
Do you need to learn SQL if you can do everything in Python? #Python #dataanalysis #SQL
Do you need to learn SQL if you can do everything in Python? #python #dataanalysis #SQL. SUBSCRIBE! Do you want to ... source
Today is rest day, in all dimensions.
So why not computing the administrative areas around the world I've visited while running and cycling with @duckdb #SQL and a bit of #Java
https://github.com/michael-simons/biking3/blob/main/bin/collect_administrative_areas.java#L210
Doing all the #spatial stuff directly from within the db, working on temp tables.
Eventually getting a deeply nested #JSON structure out of it:
Thanks @lukaseder for inspiration, @hannes for that piece of tech :)
