“It works on my database” 😅

Radim Marek shows why that’s not enough. Learn how RegreSQL brings PostgreSQL-style regression testing to application SQL—catching correctness bugs and performance regressions before prod. https://p2d2.cz/en/talks/it_works_on_my_database_regression_testing_of_sql_queries/

#PostgreSQL #P2D2 #PPDD #SQL #Testing #RegressionTesting #DatabaseDev

With adoption skyrocketing, every dev needs this in their toolkit: Backend pros, master table design; frontend folks, nail those SQL queries via APIs.

Who's your go-to DB, and why? Drop thoughts below—let's chat data hacks!

#PostgreSQL #OpenSource #DatabaseDev #CodingLife

Presenting T-SQL Analyzer - live best practices analysis of your SQL scripts in Visual Studio
#SQL #DatabaseDev #VisualStudio

https://isaacl.dev/gqz

🚀 Implement semantic search in #Postgres in just 15 minutes. Pure SQL, no ML expertise needed.

🐘 Use pgml and pgvector extensions
🔢 Convert text to embeddings
⚖️ Measure vector similarity
📈 Optimize with HNSW indexes

👇

https://postgresml.org/blog/semantic-search-in-postgres-in-15-minutes?utm_medium=mastodon

#AIsearch #databasedev

Implementing Semantic Search in Postgres in 15 Minutes – PostgresML

How to implement semantic search in Postgres with nothing but SQL.

PostgresML