#Postgres extended #SQL with infix operators for #JSON
on 02026-05-27#Postgres’s #SQL dialect has something called “lateral joins”, used here to slightly ease the creation of a Haskell embedded DSL. #toread
on 02026-04-29#Datasette Lite runs #Python in I guess probably #WASM so you can run #SQL queries on #CSV files
on 02026-01-12#Postgres has a skip locked #SQL clause for things like work #queues
#Clickhouse has an open-source "clickhouse-local" utility “ch” that offers #SQL queries on the command line which is supposedly super fast. “While clickhouse-local is a great tool for development and testing purposes, and for processing files, it is not suitable for serving end users or applications. In these scenarios, it is recommended to use the open-source ClickHouse. ClickHouse is a powerful OLAP database that is designed to handle large-scale analytical workloads. It provides fast and efficient processing of complex queries on large datasets, making it ideal for use in production environments where high-performance is critical.”
on 02025-10-27"Dolt" is “Git for Data! (...) a #SQL database that you can fork, clone, branch, merge, push and pull just like a Git repository.” #databases #version-control
on 02025-09-07#Postgres supports as embedded procedural languages C#, F# (and other #dotnet languages), Haskell, Java, JS, Julia, LOLCODE, Lua, Perl, PHP, PL/pgSQL, Python, R, Ruby, Rust, Scheme (unmaintained), shell, Tcl, and XSLT. #SQL
on 02025-09-01#Jamie-Brandon criticizes #SQL. #toread
on 02025-07-22#Jamie-Brandon has written his own text editor and (with a team) his own #SQL engine. “My ability now isn’t due to any intrinsic talent or grand insight but instead hundreds of tiny changes in habits, processes and values. When I compare these changes to online writing and discussions about how to get better at programming, I see very little overlap. The changes that lead to me being more effective are either not talked about at all or are in direct opposition to popular advice.” #toread
on 02025-07-22Chamberlin and Boyce’s 01974 #paper #PDF about #SQL, then SEQUEL, including their previous query language SQUARE, which seems to be based on binary relations (“mappings”). #history of #databases
on 02025-02-10Chris Date oral #history interview with the #CHM, focusing on relational #databases, 51 pages, talks about how he founded a company with Codd and about the “Required Technology” “Transrelational” model. “While I’m pleased that these #SQL systems are now ubiquitous, I wish they were relational systems.”
on 02024-05-03#Firebird #SQL supports #embedded-SQL in C, C++, Ada, Fortran, Cobol, and Pascal.
on 02023-06-24#Microsoft #SQL Server 2022 supports #embedded-SQL in not just C and COBOL but #MUMPS
on 02023-06-24#DB2 #embedded-SQL in #asm. #SQL
on 02023-06-24111 questions about "embedded SQL" like, with EXEC SQL statements in the middle of your C or COBOL code containing #SQL. DB2 and Datacom/DB support embedded SQL in (IBM) assembly, but mostly it's C, C++, COBOL, Ada, Fortran, RPG, etc. Surprisingly GNU #COBOL supports it with #PostgreSQL.
on 02023-06-24#ChatGPT is being used by StarRocks to improve the testing of their #SQL database. #AGI #databases
on 02023-03-09MIT-licensed #SQL client desktop/terminal with MySQL, PostgreSQL, Linux, MacOS, and Microsoft Windows support.
on 02017-11-25#PDF on #Tandem SQL databases; apparently their old one is called “SQL/MP” and their new one is called “SQL/MX” and supports SQL:1999, moving-window aggregations, statistical sampling, pub-sub, batched results, Java stored procedures, right outer joins, and using a #SQL value expression in a SELECT list or a scalar subquery as the update value in an UPDATE SET clause. MXCI is their SQL REPL for it: “conversational interface”. Interesting note: “Non-audited tables [the Transaction Management Facility, TMF, is a part of their OS that does update logging, called ‘auditing’] are not protected by transactions and follow a different logging and error handling model than audited tables. In NonStop SQL/MX, certain situations such as DML error occurrences or utility operations with DML operations can lead to inconsistent data within a non-audited table or between a non-audited table and its indices.”
How #Postgres implements updatable non-materialized views #SQL
on 02015-08-05how #Postgres implements (non-materialized) views in #SQL
on 02015-08-05Impala is a #database built on #Spark and #Hadoop (and Hive) that gets truly impressive #SQL speeds; here’s how to install it
on 02015-08-05