Tag: databases

All the articles with the tag "databases".

• Understanding PostgreSQL Connection URIs

  8 Mar, 2024

  Decode the postgresql:// connection string — host, port, database, SSL mode, and the gotchas that cause connection refused at deploy time.

• NocoDB DB Management System

  30 Mar, 2023

  NocoDB wraps any SQL database in a spreadsheet UI — self-host an Airtable alternative on top of MySQL, PostgreSQL, or SQLite with Docker.

• Repair & Optimize all Mysql Databases one liner

  17 Jul, 2013

  Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.

• Mysql CLI basics

  27 May, 2013

  Connect to MySQL from the command line, run queries, manage databases and users, import/export dumps — the basics you keep Googling.