Search: [sql]

SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog

sqlite · json · indexing · programming · sql

December 24, 2025 at 2:53:46 PM GMT+1 · permalink

·

https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing

Trino | Distributed SQL query engine for big data

trino · sql · engine · big · data · analytics · s3

October 28, 2025 at 5:09:37 PM GMT+1 · permalink

·

https://trino.io/

SQLBolt - Learn SQL - Introduction to SQL

sql · learning · online

March 18, 2025 at 3:20:10 PM GMT+1 · permalink

·

https://sqlbolt.com/

Simple Anomaly Detection Using Plain SQL | Haki Benita

anomaly · detection · sql · sysadmin · monitoring

March 10, 2025 at 2:37:05 PM GMT+1 · permalink

·

https://hakibenita.com/sql-anomaly-detection

Free SQL Editor » QStudio

qstudio · sql · editor · database

March 6, 2025 at 3:56:15 PM GMT+1 * · permalink

·

https://www.timestored.com/qstudio/

Choosing a backend database: SQL vs Document vs Columnar

database · sql · document · columnar · mongodb · postgres · mysql · cassandra · dynamodb

March 31, 2024 at 9:32:00 PM GMT+2 · permalink

·

https://www.thomashansen.me/choosing-backend-database/

JSON in PostgreSQL: Revolutionizing Data Flexibility in Your Database - Highgo Software Inc.

postgresql · json · jsonb · programming · sql

January 16, 2024 at 3:10:07 PM GMT+1 · permalink

·

https://www.highgo.ca/2024/01/15/json-in-postgresql-revolutionizing-data-flexibility-in-your-database/

GitHub - jobinau/pg_gather: Scan PostgreSQL Instance for potential problems. pg_gather is a SQL-only script leveraging the built-in features of psql.

pg_gather · script · sql · postgresql · postgres · security · sysadmin

January 12, 2024 at 10:56:04 AM GMT+1 · permalink

·

https://github.com/jobinau/pg_gather

GitHub - wesql/wescale: WeScale is a database proxy that cares about your application, the development experience, and supports OnlineDDL.

wescale · proxy · sql · read · write · split · load · balancing · failover

December 19, 2023 at 11:28:32 AM GMT+1 · permalink

·

https://github.com/wesql/wescale

Joins 13 Ways

sql · join · inner · outer · left · right · database

July 11, 2023 at 2:46:01 PM GMT+2 · permalink

·

https://justinjaffray.com/joins-13-ways/

SQL Join Flavors

sql · join · programming · databases

June 21, 2023 at 5:18:38 PM GMT+2 · permalink

·

https://antonz.org/sql-join/

GitHub - r0oth3x49/ghauri: An advanced cross-platform tool that automates the process of detecting and exploiting SQL injection security flaws

ghauri · XSS · python · sql · injection · security

May 30, 2023 at 3:06:43 PM GMT+2 · permalink

·

https://github.com/r0oth3x49/ghauri

SQL Cheat Sheet

sql · cheatsheet · programming · database

May 15, 2023 at 2:25:54 PM GMT+2 · permalink

·

https://antonz.org/sql-cheatsheet/

GitHub - sachaarbonel/reefdb: ReefDB is a minimalistic, in-memory and on-disk database management system written in Rust, implementing basic SQL query capabilities and full-text search.

reefdb · database · rust · sql

May 7, 2023 at 11:42:16 AM GMT+2 · permalink

·

https://github.com/sachaarbonel/reefdb

Transaction ID wraparound: a walk on the wild side

postgres · sql · transaction · wraparound

February 9, 2023 at 5:21:15 PM GMT+1 · permalink

·

https://www.cybertec-postgresql.com/en/transaction-id-wraparound-a-walk-on-the-wild-side/

Updating JSON Data in PostgreSQL

postgres · json · jsonb · sql · update

January 9, 2023 at 3:14:03 PM GMT+1 · permalink

·

https://aaronbos.dev/posts/update-json-postgresql

7 SQL Concepts You Should Know For Data Science - KDnuggets

postgres · postgresql · data · science · sql · commands · programming

December 7, 2022 at 7:04:40 PM GMT+1 · permalink

·

https://www.kdnuggets.com/2022/11/7-sql-concepts-needed-data-science.html

Postgres Tips | Crunchy Data

postgres · postgresql · tips · commands · sql

December 7, 2022 at 3:14:33 PM GMT+1 · permalink

·

https://www.crunchydata.com/postgres-tips

YDB — an open-source Distributed SQL Database

ydb · yandex · database · cluster · distributed · sql · table · scalable · consistency

April 19, 2022 at 3:44:54 PM GMT+2 · permalink

·

https://ydb.tech/

cossacklabs/acra: Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side ("transparent") encryption. SQL, NoSQL.

acra · proxy · database · security · sql · injection · detection · honeypot

January 10, 2022 at 4:10:32 PM GMT+1 · permalink

·

https://github.com/cossacklabs/acra