Stories — page 6

PostgreSQL list databases: \l, SQL and GUI

PostgreSQL List Databases: \l, SQL and GUI

To list databases in PostgreSQL, connect with psql and type \l. That prints every database on the server with its owner, encoding and access privileges. If you would rather use SQL, SELECT datname

Fri Oct 09 2026 · 7 min read · 1 views

Software

Storing images in PostgreSQL: bytea, large objects or a path

Can You Store Images in PostgreSQL? Tested

Yes, PostgreSQL can store images. You have three ways to do it: a bytea column, large objects, or a path or URL pointing at a file kept elsewhere. For most apps, storing small images in bytea is fine

Fri Oct 09 2026 · 7 min read · 9 views

Software

SQLite CREATE TABLE IF NOT EXISTS explained

SQLite CREATE TABLE IF NOT EXISTS: What It Skips

CREATE TABLE IF NOT EXISTS in SQLite creates the table only when no table of that name exists, and does nothing, with no error, when one does. That makes it safe to run on every app start. It also

Fri Oct 09 2026 · 7 min read · 1 views

Software