SQLite
small RDBMS engine
command-line
sqlite3 {db}.db
- ctl-d to exit
- semicolons at end of lines
- schema is in sqlite_master table - or type
.schema
to view - to export/dump schema and all data:
sqlite3 {db}.db .dump > {db}.sql
- to regenerate db from export file:
sqlite {db}.db < {db}.sql
- de-facto NoSql approach possible?
accessing with Python
Edited: | Tweet this! | Search Twitter for discussion
BackLinks: 2003-10-18-DonParkSqlliteAndQdbm | 2009-05-07-MacBookPerformanceProblems | 2009-05-22-MacMailSteward | 2012-02-16-LocalSisterSitesHack | 2012-03-06-WattersUdellWebMakerLiteracyPerspectives | 2012-03-29-FbreaderHighlightsControl | 2014-05-31-SimmonsNeoFrontier | 2020-01-28-TenTechnologiesToKnowIn2020PostlightDigitalProductStudio | 2022-03-17-TwinPagesWidgetForOtherSites | 2022-08-17-UdellPostgresEverywhere | 2022-12-26-BorrettiUnbundlingToolsForThought | 2023-10-23-WillisonEmbeddingsWhatTheyAreAndWhyTheyMatter | 2024-08-16-McCueJustUsePostgres | 2024-10-13-WillisonZeroLatencySqliteStorageInEveryDurableObject | ConvertingDataFromN810ToNexusOne | Datasette | ExtendingWebpyBlogAppWithCookbookFeatures | FlaskForWikiEngine | GoogleGears | HighlightingAndAnnotating | MicroblogPub | MorkDb | OLPC | PersonalCloud | PersonalDataServer | RailsOnMacOsx | Replit | TracWiki | WebpyForSimplestThing | WikidPad | WikifluxForPrivatewiki
TwinPages: NikitaVoloboev | WikiWikiWeb