Farshid's Weblog

Posts tagged “database”

  1. Geopoly in SQLite (2025-09-27)
  2. Creating a minimal SpatiaLite database with Python (2025-08-31)
  3. Compiling and running sqlite3-rsync (2025-07-12)
  4. Granting a PostgreSQL user read-only access to some tables (2025-04-27)
  5. Combining CTEs and VALUES in SQLite (2024-12-29)
  6. Calculating the size of a SQLite database file using SQL (2024-12-28)
  7. Cumulative total over time in SQL (2024-12-15)
  8. Combining substr and instr to extract text (2024-10-27)
  9. Comparing database rows before and after with SQLite JSON functions (2024-08-25)
  10. Enabling WAL mode for SQLite database files (2024-05-18)
  11. Finding duplicate records by matching name and nearby distance (2024-01-28)
  12. Figuring out if a text value in SQLite is a valid integer or float (2024-01-21)
  13. Constructing GeoJSON in PostgreSQL (2023-12-24)
  14. Compile a new sqlite3 binary on Ubuntu (2023-12-17)
  15. Enabling a gin index for faster LIKE queries (2023-10-01)
  16. Copy tables between SQLite databases (2023-09-16)
  17. Counting SQLite virtual machine operations (2023-08-13)
  18. Deno KV (2023-06-17)
  19. Consecutive groups in SQL using window functions (2023-05-28)
  20. Allowing a container in Docker Desktop for Mac to talk to a PostgreSQL server on the host machine (2023-02-25)