Latest #sql Threads 

Learn about text-to-SQL techniques like context building and table retrieval, LLM-as-a-judge, and LLM prompting and post-processing.
New

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: PostgreSQL: SQLPage v0.33: Build Custom UIs, and no...
New

How about trailing commas in SQL?.
Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.
New

SQL or Death? Seminar Series - Spring 2025 - Carnegie Mellon Database Group.
Suppose somebody has been rubbing gasoline on their body si...
New

Composable SQL.
Better SQL through typed, composable query fragments.
New

A new PostgreSQL blog post/announcement has been posted!
New

Runtime-Extensible SQL Parsers Using PEG.
Despite their central role in processing queries, parsers have not received any noticeable att...
New

SQL, Homomorphisms and Constraint Satisfaction Problems.
Database queries are a pretty surprisingly powerful tool that can solve seeming...
New

SQL Injection Isn’t Dead: Smuggling Queries at the Protocol Level.
PDF slides from a presentation by Paul Gerste at DEF CON 32. It turns...
New

GitHub - lovasoa/SQLpage: SQL-only webapp builder, empowering data analysts to build websites and applications quickly.
SQL-only webapp ...
New
This Week's Trending
This Month's Trending

Learn about text-to-SQL techniques like context building and table retrieval, LLM-as-a-judge, and LLM prompting and post-processing.
New
This Year's Trending

SQL Injection Isn’t Dead: Smuggling Queries at the Protocol Level.
PDF slides from a presentation by Paul Gerste at DEF CON 32. It turns...
New

Codd almighty! Has it been 50 years of SQL already?.
The Reg talks to Donald Chamberlin, Michael Stonebraker and more about the legendar...
New

SQL or Death? Seminar Series - Spring 2025 - Carnegie Mellon Database Group.
Suppose somebody has been rubbing gasoline on their body si...
New

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: PostgreSQL: SQLPage v0.33: Build Custom UIs, and no...
New

GitHub - lovasoa/SQLpage: SQL-only webapp builder, empowering data analysts to build websites and applications quickly.
SQL-only webapp ...
New

Composable SQL.
Better SQL through typed, composable query fragments.
New

A new PostgreSQL blog post/announcement has been posted!
New

How about trailing commas in SQL?.
Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.
New

Runtime-Extensible SQL Parsers Using PEG.
Despite their central role in processing queries, parsers have not received any noticeable att...
New

Hybrid Search Explained.
Learn how to enhance search relevancy with Hybrid Search in CrateDB, combining BM25 and Vector Search for bette...
New

SQL, Homomorphisms and Constraint Satisfaction Problems.
Database queries are a pretty surprisingly powerful tool that can solve seeming...
New
Last Three Year's Trending

sqlglot/python_sql_engine.md at main · tobymao/sqlglot.
Python SQL Parser and Transpiler. Contribute to tobymao/sqlglot development by c...
New

Use SQL to get the data you need in no time at all! Learn to read and write basic queries, troubleshoot common problems, and control your...
New

Can anyone help me how to convert a long data to wide data in SQL without using hard coding?
Regards
Manish
New

I want to declare max of length in case condition i.e 7 but getting a syntax error near select in this code.
DECLARE @SQ Int(MAX)
SELEC...
New

Writing composable SQL using JavaScript by Gajus Kuizinas.
A walkthrough of common patterns of writing SQL queries in JavaScript with th...
New

How can I apply a modified date and time to a variable? This is what I get when I execute the following query in SQL Server Mgmt Studio: ...
New

I’m working on a SQL query for a database containing records of customer transactions. Each transaction has a transaction_id, customer_id...
New

Replacing a SQL analyst with 26 recursive GPT prompts | Patterns.
When I was at Square and the team was smaller we had a dreaded “analyt...
New

The case against SQL formatting.
I went looking for the gospel, and lost my religion.
New

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: https://www.postgresql.org/about/news/sql-server-to...
New

Ever wondered how secure your Elixir-based applications are against SQL Injection attacks? :space_invader:
From explaining SQL injection...
New

Episode 166 of Thinking Elixir. Most of us have created our own filtering, sorting and pagination code before in one project after the ot...
New

Payload CMS.
Transitioning a headless CMS from NoSQL to SQL database has really spotlighted the concrete, real-world differences.
New

SQL should be your default choice for data engineering pipelines.
SQL should be the first option considered for new data engineering wor...
New

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: PostgreSQL: Apache Arrow Flight SQL adapter for Pos...
New
Trending Over Three Years

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: PostgreSQL: SQLreduce: Reduce verbose SQL queries t...
New

GitHub - max-sixty/prql: PRQL is a modern language for transforming data — a simpler and more powerful SQL.
PRQL is a modern language fo...
New

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: PostgreSQL: High-Performance SQL Cluster Engine PGS...
New

This article covers some best practices for writing SQL queries for data analysts and data scientists. Most of our discussion will concer...
New

The SQL langauge is old, strange, and important. We’ll take those in reverse order:
SQL is important. Unlike many other types of databas...
New

[PADL’22] Functional Programming on Top of SQL Engines.
Title:[PADL’22] Functional Programming on Top of SQL EnginesAuthors:Tobias Burgh...
New

Raw SQL in Rust with SQLx.
This article shows you how you can use SQL in Rust with SQLx - you will find a rundown of all the advantages ...
New

A Different Type of SQL Recursion with PostgreSQL · vb-consulting/blog · Discussion #1.
A Different Type of SQL Recursion with PostgreSQ...
New

SQL:2023 is finished: Here is what’s new.
SQL:2023 has been wrapped. The final text has been submitted by the working group to ISO Centr...
New

A Beginner’s Guide to Sequence Analytics in SQL.
A gentle, practical guide on how to analyze sequence data in SQL.
New

GitHub - AmrDeveloper/ClangQL: ClangQL is a tool that allow you to run SQL-like query on C/C++ Code instead of database files using the G...
New

Building a faster hash table for high performance SQL joins | QuestDB.
Why is a fast hash table important for optimal SQL performance? W...
New

Upsert in SQL.
Inserting and updating data with a single query.
New

A new PostgreSQL blog post/announcement has been posted!
Get the full details here: https://www.postgresql.org/about/news/high-performa...
New

The Case of a Curious SQL Query.
Languages that suffer success often have to do so by selling out and adding features that go against so...
New
Get money off!

The Pragmatic Bookshelf
35% off any eBook

Manning Publications
45% off any item

The Pragmatic Studio
20% off any course
Simply use coupon code "devtalk.com" at checkout. Where applicable this coupon can be used for an many items and as many times as you like!
Filter by Type:
Popular Tags
- #apple
- #code
- #programming
- #linux
- #web
- #suse
- #podcasts
- #blog-post
- #news
- #video
- #otp
- #community
- #chatgpt
- #macos
- #new
- #microsoft
- #learning
- #openai
- #github
- #database
- #development
- #design
- #ios
- #performance
- #testing
- #project
- #internet
- #apps
- #css
- #hardware
- #android
- #quantum
- #guide
- #nvidia
- #intel
- #liveview
- #amazon
- #manning
- #browser
- #musk
- #privacy
- #social
- #languages
- #windows
- #api
- #writing
- #javascript
- #games
Popular Portals
- /elixir
- /rust
- /wasm
- /ruby
- /erlang
- /phoenix
- /keyboards
- /rails
- /js
- /python
- /security
- /go
- /swift
- /vim
- /clojure
- /java
- /haskell
- /emacs
- /svelte
- /onivim
- /typescript
- /crystal
- /c-plus-plus
- /tailwind
- /kotlin
- /gleam
- /react
- /flutter
- /elm
- /ocaml
- /ash
- /vscode
- /opensuse
- /centos
- /php
- /deepseek
- /html
- /scala
- /zig
- /debian
- /nixos
- /lisp
- /agda
- /textmate
- /sublime-text
- /react-native
- /kubuntu
- /arch-linux
- /ubuntu
- /revery