Farshid's Weblog

Posts tagged “sql”

  1. Granting a PostgreSQL user read-only access to some tables (2025-04-27)
  2. Closest locations to a point (2025-03-16)
  3. Combining CTEs and VALUES in SQLite (2024-12-29)
  4. Calculating the size of a SQLite database file using SQL (2024-12-28)
  5. Cumulative total over time in SQL (2024-12-15)
  6. GUnion to combine geometries in SpatiaLite (2024-11-09)
  7. Combining substr and instr to extract text (2024-10-27)
  8. Creating a dynamic line chart with SVG (2024-10-20)
  9. Comparing database rows before and after with SQLite JSON functions (2024-08-25)
  10. Using recursive CTEs to explore hierarchical Twitter threads (2024-07-28)
  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. Consecutive groups in SQL using window functions (2023-05-28)