sqlite
Python
sqlite - Pure Python Backup of SQLite3 In-Memory Database to Disk - Stack Overflow
TODO
sqlite - python sqlite3 insert list - Stack Overflow dentropydaemon-wiki/Software/Programming Language/python
Save query as a CSV or JSON file
- SQLite: How do I save the result of a query as a CSV file? - Stack Overflow
- Export SQLite Database To a CSV File
Copy table from one database to another
SQLite: Easiest way to copy a table from one database to another? - Stack Overflow
Time
Get Month from datetime
select strftime('%m', dateField) as Month ...
- %S seconds
- %M Minutes
- %H hours
- %Y year
-
%d day
- SQLite strftime() function - w3resource
Get day of week
sql - Format date as day of week - Stack Overflow
Unsorted
- MySQL Count Matching Records With COUNT
- SQLite functions
- sqlite-utils command-line tool - sqlite-utils
- 2 Ways to List the Tables in an SQLite Database | Database.Guide
String Manipulation
- sql - How do I find the position of a character in a SQLite column? - Stack Overflow
- sql - How to search for a substring in SQLite? - Stack Overflow
JSON Support
- projects.aw-experiments
- SQLite JSON1 example for JSON extract\set - Stack Overflow
- sql - Sqllite : search value from json string - Stack Overflow
- SQLite and JSON
- JSON Functions And Operators
- wiki.software.list.json
Regex
select * from TABLE
where COLUMN regexp '.'
How do I use regex in a SQLite query? - Stack Overflow
Split string by delimiter
select foods.value
from json_each('["' || replace('coffee:apple:orange', ':', '","') || '"]') as foods;
- How to Split String into Array? : sqlite
- Source for example above
- android - How to split comma-separated value in SQLite? - Stack Overflow
- Did not get working looks interesting