VirtualTam's bookmarks

1. lnav - Logfile navigator 2025-01-30

   tags: command-line, database/sqlite, observability/logging, programming/c++, programming/json

   [ permalink ]

   • The Logfile Navigator
   • Command Line Interface
   • Log Formats
   • SQLite Interface
2. The SQLite JSONB Format 2025-01-21

   tags: database/sqlite, programming/json

   [ permalink ]

   • JSON Functions And Operators
   • SQLite 3.45.0
   • SQLite 3.45: Interactive release notes
3. Limbo - A work-in-progress, in-process OLTP database management system, compatible with SQLite. 2024-12-17

   tags: asynchronous, database/sqlite, linux/kernel, programming/rust

   [ permalink ]

   • Serverless Runtime / Database Co-Design With Asynchronous I/O (PDF)
   • In search of a faster SQLite
4. Self-hosted online collaborative drawing platform Excalidraw 2024-11-25

   tags: database/mongodb, database/sqlite, diagram, image/png, image/svg, network/websocket, programming/json, programming/node.js, programming/typescript, schema, self-hosting, software-engineering/uml

   [ permalink ]

   • Self-hosted online collaborative drawing platform Excalidraw (alternate version on Medium)
     • alswl/excalidraw-collaboration - Excalidraw with collaboration feature, self-hosting, and only one-click deploy
     • alswl/excalidraw-storage-backend - Storage for scenes, images and collaboration rooms
     • alswl/excalidraw.alswl.com - Custom static version featuring a Chinese font with handwriting style
     • Someone0nEarth/excalidraw-self-hosted - A docker-compose configuration for a fully self-hosted excalidraw stack, a collaborative whiteboard solution
   • r/selfhosted - Excalidraw
     • excalidraw/excalidraw-room - Example collaboration server
     • Comment on excalidraw/excalidraw/issues/4993 - Building your own Docker images
     • excalidraw/excalidraw/issues/6506 - Tutorial for Træfik
   • PatWie/excalidraw-complete - Self-host Excalidraw with a single Go binary - Supports multiple storage options and real-time collaboration
5. sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code 2024-11-24

   tags: database/mysql, database/postgresql, database/sqlite, programming/python, programming/sql, static-analysis/lint

   [ permalink ]

   • Configuration
   • Rules Reference
6. 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
7. 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
8. Litestream - Streaming SQLite Replication 2024-06-20

   tags: backup, database/sqlite

   [ permalink ]

   • benbjohnson/litestream
9. 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
10. Exploring EXIF 2023-09-08

    tags: database/sqlite, image/exif

    [ permalink ]

    • mattiasw/ExifReader
    • ExifTool
11. 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
12. 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
13. How To Corrupt An SQLite Database File 2022-05-02

    tags: database/sqlite, posix

    [ permalink ]
14. 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
15. 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, programming/php, programming/php/doctrine

    [ permalink ]

    • https://github.com/doctrine/dbal/commit/7282289fee625a24c26c1fccc0474e8ca583470f
16. 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/
17. 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
18. 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 ]
19. 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
20. 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>);