Farshid's Weblog

Posts tagged “sqlite”

  1. Geopoly in SQLite (2025-09-27)
  2. SQLite BLOB literals (2025-09-21)
  3. Subqueries in select expressions in SQLite - also window functions (2025-09-14)
  4. Creating a minimal SpatiaLite database with Python (2025-08-31)
  5. Identifying column combination patterns in a SQLite table (2025-08-16)
  6. Finding the SQLite version used by Web SQL in Chrome (2025-07-26)
  7. Compiling and running sqlite3-rsync (2025-07-12)
  8. --- (2025-05-04)
  9. Replicating SQLite with rqlite (2025-05-03)
  10. Embedding paragraphs from my blog with E5-large-v2 (2025-04-06)
  11. Trying out SQLite extensions on macOS (2025-02-23)
  12. SQLite pragma_function_list() (2025-01-18)
  13. How to run MediaWiki with SQLite on a macOS laptop (2025-01-12)
  14. Combining CTEs and VALUES in SQLite (2024-12-29)
  15. Calculating the size of a SQLite database file using SQL (2024-12-28)
  16. Exporting Amplitude events to SQLite (2024-12-15)
  17. SQLite triggers (2024-12-08)
  18. GUnion to combine geometries in SpatiaLite (2024-11-09)
  19. Combining substr and instr to extract text (2024-10-27)
  20. Importing CSV data into SQLite with .import (2024-10-12)
  21. Lag window function in SQLite (2024-10-06)
  22. One-liner for running queries against CSV files with SQLite (2024-10-06)
  23. Saving an in-memory SQLite database to a file in Python (2024-09-15)
  24. How to read Hacker News threads with most recent comments first (2024-09-07)
  25. Comparing database rows before and after with SQLite JSON functions (2024-08-25)
  26. The simplest recursive CTE (2024-08-17)
  27. SQLite VACUUM: database or disk is full (2024-07-20)
  28. Enabling WAL mode for SQLite database files (2024-05-18)
  29. Sort by number of JSON intersections (2024-05-05)
  30. SQLite aggregate filter clauses (2024-04-14)
  31. SQLite can use more than one index for a query (2024-03-10)
  32. SQLite timestamps with floating point seconds (2024-03-03)
  33. Querying for items stored in UTC that were created on a Thursday in PST (2024-02-04)
  34. Export a Mastodon timeline to SQLite (2024-01-21)
  35. Figuring out if a text value in SQLite is a valid integer or float (2024-01-21)
  36. The SQLite now argument is stable within the same query (2024-01-06)
  37. Compile a new sqlite3 binary on Ubuntu (2023-12-17)
  38. Splitting on commas in SQLite (2023-12-10)
  39. Atuin for zsh shell history in SQLite (2023-11-26)
  40. Track timestamped changes to a SQLite table using triggers (2023-10-28)
  41. Compile and run a new SQLite version with the existing sqlite3 Python library on macOS (2023-10-22)
  42. Compiling the SQLite spellfix.c module on macOS (2023-10-01)
  43. List all columns in a SQLite database (2023-09-17)
  44. Null case comparisons in SQLite (2023-09-17)
  45. Copy tables between SQLite databases (2023-09-16)
  46. Returning related rows in a single SQL query using JSON (2023-08-20)
  47. Counting SQLite virtual machine operations (2023-08-13)
  48. Fixing broken text encodings with sqlite-transform and ftfy (2023-07-29)
  49. Trying out cr-sqlite on macOS (2023-07-15)
  50. Using LD_PRELOAD to run any version of SQLite with Python (2023-07-01)
  51. Deno KV (2023-06-17)
  52. Loading SQLite extensions in Python on macOS (2023-06-17)
  53. Consecutive groups in SQL using window functions (2023-05-28)
  54. Finding the largest SQLite files on a Mac (2023-05-28)
  55. Using pysqlite3 on macOS (2023-05-06)
  56. Tracking SQLite table history using a JSON audit log (2023-02-25)
  57. Ordered group_concat() in SQLite (2023-02-18)
  58. Building a specific version of SQLite with pysqlite on macOS/Linux (2023-02-11)
  59. Comparing two training datasets using sqlite-utils (2023-01-28)
  60. Browse files (including SQLite databases) on your iPhone with ifuse (2023-01-15)
  61. Unix timestamp in milliseconds in SQLite (2023-01-08)