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. 3 explorations bluffantes avec DuckDB 2025-01-27

   tags: database/duckdb, geography, programming/apache-parquet, programming/json, programming/python

   [ permalink ]

   1. Interroger des fichiers distants
   2. Butiner des API JSON
   3. Croiser les requêtes spatiales
3. 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
4. PostgreSQL - What is a valid use case for using TIMESTAMP WITHOUT TIME ZONE? 2025-01-14

   tags: database/postgresql, time/timezone

   [ permalink ]

   • Date/Time Types
   • Should I store UTC timestamps or localtime for shifts
5. Rust needs a web framework for lazy developers 2024-12-30

   tags: database, framework, network/http, programming/html, programming/rust, web

   [ permalink ]

   The benefits are there: you get wonderful type system, wonderful performance, and build times that give you back those coffee breaks you used to get while your code compiled.

   • ~ntietz/newt - Nicole's Web Toolkit
   • Are we web yet?
6. pgrx - Build Postgres Extensions with Rust! 2024-12-25

   tags: database/postgresql, programming/rust

   [ permalink ]

   • dalibo/postgresql_anonymizer
   • daamien/pgrx-tuto
7. 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
8. CloudNativePG - A Kubernetes operator that covers the full lifecycle of a highly available PostgreSQL database cluster 2024-12-03

   tags: database/postgresql, linux/container/kubernetes, programming/go, programming/python

   [ permalink ]

   • cloudnative-pg/cloudnative-pg
   • CloudNativePG Tutorial: Manage Multiple Cloud-Native Databases
   • Barman, Backup and Recovery Manager for PostgreSQL
9. EphemeraSearch - Your ancestors had mail 2024-12-03

   tags: database/postgresql, genealogy, history, image/optical-character-recognition, linux/container/kubernetes, mail/postcard, programming/go, search-engine

   [ permalink ]

   • About EphemeraSearch
   • EphemeraSearch on Github
   • Enix Live Show - Comment CNPG et Kubernetes ont sauvé ma startup !
   • PoZoK - PostgreSQL on ZFS on Kubernetes
10. 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
11. 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
12. pg_duckdb - A Postgres extension that embeds DuckDB's columnar-vectorized analytics engine and features 2024-11-20

    tags: database/duckdb, database/postgresql, programming/apache-parquet, programming/c++, programming/json, programming/python, programming/sql

    [ permalink ]

    • DuckDB - PostgreSQL Extension
    • Querying Postgres Tables Directly from DuckDB
13. psqlrc - PostgreSQL command-line client configuration 2024-11-19

    tags: command-line/pager, database/postgresql

    [ permalink ]

    • How To Customize the PostgreSQL Prompt with psqlrc on Ubuntu 14.04
    • datachomp//dotfiles - psqlrc
    • okbob/pspg - Pager specialized for tabular data
14. What I Wish Someone Told Me About Postgres 2024-11-19

    tags: command-line, database/postgresql, programming/csv, programming/json, programming/sql

    [ permalink ]
15. The Ultimate Guide to Django Performance: Best Practices for Scaling and Optimization - LoadForge Guides 2024-11-18

    tags: database, framework/django, network/http, performance, programming/python, storage/cache

    [ permalink ]

    • Django - Performance and optimization
    • Django - Database access optimization
    • Better living through optimized Django
16. Is pg_dump a Backup Tool? 2024-11-03

    tags: backup, database/postgresql, programming/sql

    [ permalink ]

    • Why pg_dump Is Amazing
    • EnterpriseDB/barman - Backup and Recovery Manager for PostgreSQL
    • pgbackrest/pgbackrest - Reliable PostgreSQL Backup & Restore
17. 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
18. Ibis - The portable Python dataframe library 2024-08-29

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

    [ permalink ]

    • ibis-project
19. 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
20. Litestream - Streaming SQLite Replication 2024-06-20

    tags: backup, database/sqlite

    [ permalink ]

    • benbjohnson/litestream