VirtualTam's bookmarks

1. Supercharge the One Person Framework with SQLite: Rails World 2024 2024-10-18

   tags: database/sqlite, framework/ruby-on-rails, programming/ruby, programming/sql

   [ permalink ]

   • How (and why) to run SQLite in production: RubyConf Taiwan 2023
   • Litestream - Streaming SQLite Replication
2. Webamp - Winamp 2 in your browser 2024-07-29

   tags: audio, database/sqlite, programming/javascript

   [ permalink ]

   • captbaritone/webamp
   • Winamp Skins Museum
   • The Winamp Skin Museum is powered by an sqlite3 database
3. Litestream - Streaming SQLite Replication 2024-06-20

   tags: backup, database/sqlite

   [ permalink ]

   • benbjohnson/litestream
4. Fly.io - JIT Wireguard 2024-03-31

   tags: database/sqlite, network/http, network/udp, network/vpn/wireguard, programming/go

   [ permalink ]

   What if, instead of pushing [user] configs to gateways, we had the gateways pull them from our API on demand?

   • Linux Kernel - Introduction to Netlink
   • tqbf/wg_init.go - Wireguard initiator-responder identity example
5. Exploring EXIF 2023-09-08

   tags: database/sqlite, image/exif

   [ permalink ]

   • mattiasw/ExifReader
   • ExifTool
6. Create an advanced search engine with PostgreSQL 2023-07-14

   tags: database/postgresql, programming/sql, search-engine, text

   [ permalink ]

   • Postgres Full Text Search vs the rest (MeiliSearch, OpenSearch/Elasticsearch, SQlite FTS, Typesense)
   • Optimizing Full Text Search with Postgres tsvector Columns and Triggers
   • Word separators for Postgres full text search with Rails
   • Using PostgreSQL Full Text Search With Golang
   • PostgreSQL: Full Text Search
   • PostgreSQL: Preferred Index Types for Text Search
7. Grafana SQLite Migration to PostgreSQL 2023-06-25

   tags: database/migration, database/postgresql, database/sqlite, observability/grafana

   [ permalink ]

   • Migrating Grafana’s database from sqlite to postgres
   • pgloader
   • Configure Grafana - Database
8. How To Corrupt An SQLite Database File 2022-05-02

   tags: database/sqlite, posix

   [ permalink ]
9. pgloader - load data from various sources into PostgreSQL 2022-04-17

   tags: command-line, database/mysql, database/postgresql, database/sqlite, linux, programming/csv, programming/lisp

   [ permalink ]

   • dimitri/pgloader
   • MySQL to PostgreSQL
   • pgloader#645 - How to import into public schema
10. Doctrine ORM tries to recreate partial indexes with the same definition every time. · Issue #6218 · doctrine/orm · GitHub 2019-02-26

    tags: database, database/sqlite, doctrine, programming/php

    [ permalink ]

    • https://github.com/doctrine/dbal/commit/7282289fee625a24c26c1fccc0474e8ca583470f
11. DBCLI - Commandline Database Clients with Autocompletion and Syntax Highlighting 2018-12-05

    tags: command-line, database, database/mariadb, database/mysql, database/postgresql, database/sqlite, programming/python, terminal

    [ permalink ]

    • https://github.com/dbcli/litecli
    • https://www.mycli.net/
    • https://www.pgcli.com/
    • https://web-techno.net/mysql-command-line-tool-mycli/
12. python-sqlparse - a non-validating SQL parser module for Python 2018-10-21

    tags: database, database/mariadb, database/mysql, database/postgresql, database/sqlite, parser, programming/python, programming/sql

    [ permalink ]

    • https://github.com/andialbrecht/sqlparse
13. A Lesson In Low-Defect Software - A Journey From A Quick Hack To A High-Reliability Database Engine 2018-04-27

    tags: code, database, database/sqlite, programming/sql, programming/testing

    [ permalink ]
14. Room Persistence Library | Android Developers 2018-04-22

    tags: database, database/sqlite, mobile/android, model, programming/object-oriented-programming

    [ permalink ]

    • https://developer.android.com/training/data-storage/room/index.html
    • https://developer.android.com/reference/android/arch/persistence/room/Database.html
    • https://developer.android.com/training/data-storage/room/defining-data.html
    • https://developer.android.com/training/data-storage/room/accessing-data.html
    • https://developer.android.com/topic/libraries/architecture/adding-components.html
    • https://codelabs.developers.google.com/codelabs/android-room-with-a-view/#0
    • https://codelabs.developers.google.com/codelabs/android-persistence/#0
    • https://github.com/googlesamples/android-architecture-components/tree/master/PersistenceContentProviderSample
    • https://github.com/googlesamples/android-architecture-components/tree/master/PersistenceMigrationsSample
15. Pragma statements supported by SQLite 2016-08-20

    tags: database, database/sqlite, meta

    [ permalink ]

    1# List databases
    2PRAGMA database_list;
    3
    4# Describe table
    5PRAGMA table_info(<table_name>);
    

16. SQLite Memo 2015-03-14

    tags: data, database, database/sqlite, programming/sql

    [ permalink ]

    Common ops & clauses:

    • CREATE TABLE - https://www.sqlite.org/lang_createtable.html
    • ALTER TABLE - https://www.sqlite.org/lang_altertable.html
    • UPDATE - https://www.sqlite.org/lang_update.html