/explore
|
You are here 
|
di.nmfay.com | ||
| | | | |
curatedsql.com
[AI summary] A collection of SQL-related blog posts from January 4, 2024, discussing topics like data manipulation, database management, and SQL Server features. |
|
| | | | | ||
| | | | |
andreabergia.com
Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without. |
|
| | | | | ||
| | | | |
e7e6.github.io
With Michael of pgMustard fame current host of #PGSQLPhriday, I could not resist revisiting this rather abondoned place of the interweb. As a short prelude, PGSQL Phriday is a blog event to talk of all things PostgreSQL and this week topic is about pg_stat_statements. pg_stat_statement is a module available since 2009 in Postgres 8.4. It tracks execution statistics on all SQL statements that have been executed. Since version 13, it also tracks planning statistics. |
|
| | | | | ||
| | | | |
www.suspek.org
[AI summary] The article details how MySQL's handling of overlong input can cause buffer overflow issues and SQL column truncation vulnerabilities that lead to security exploits. |
|
| | | |||
