1 private link
Les raisons pour lesquelles faire un SÉLECT * est une TRÈS mauvaise idée. #sql
Today, at Postgres Conference 2024, we introduced a #PostgreSQL extension we are developing, which enables #MySQL applications to run on PostgreSQL without any code changes by supporting the MySQL wire protocol, #SQL syntax, and procedural language.
DuckDB is an in-process SQL OLAP database management system. Simple, feature-rich, fast & open source. Vu chez Sebasauvage ; en plus de sa compliance avec #sql, DuckDB a aussi l’air de pouvoir être hébergée sur un bucket S3
Logically, there are two cursors performing a typical update operation. One to read and other to write. A read cursor identifies the row which is to be updated and another cursor that performs the write operation to update the rows. In terms of execution, this process is thus divided into two separate parts. To be more specific, first, the write cursor of an updated plan does not affect the second read cursor.
This means that if the data is updated first by the “write” cursor before the data was read by the “read” cursor, then it could be possible to change the position of the row just by updating it. Consequently, read it a second time and it might be different. The means of a key being updated using such an operation in SQL Server, is called the Halloween effect. Let me explain in detail for more clarification. #sql
Où comment se passer de CTE (que j’aime cette idée) #sql
Petit bug à la con dans django-mssql-backend qui empêche d'utiliser sql_server.pyodbc comme backend avec django-environ.
SELECT count() FROM enrondata1 WHERE content MATCH 'linux'; / 0.03 seconds /
SELECT count() FROM enrondata2 WHERE content LIKE '%linux%'; / 22.5 seconds /
Sur un total de 517430 documents.
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.
Vu sur diaspora* :
Company: "We'd like to use SQL Server Enterprise"
MS: "That'll be a quarter million dollars + $20K/month"
Company: "Ok!"
...
Company: "We'd like to use Babel"
Babel: "Ok! npm i babel --save"
Company: "Cool"
Babel: "Would you like to help contribute financially?"
Company: "lol no"
Source : https://diaspote.org/posts/932521