Migrating from SQLite to PostgreSQL

• Sequel

  37 4,903 8.9 Ruby

  Sequel: The Database Toolkit for Ruby

• bytebase

  36 10,107 10.0 Go

  The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.

  

Note that they aren't SaaS but are providing a locally-installable software it seems [1]. Then SQLite seems to be a reasonable option and PG can be overkill (but switched to PG anyway because of the listed motivations.)

[1] https://github.com/bytebase/bytebase#installation

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• Mapless

  6 35 9.1 Smalltalk

  Schema-less persistence for Smalltalk with support for multiple backends.

Sounds like it was a smooth migration. Good to hear that because in this precise moment I'm adding SQLite support to *Mapless* [1] (PostgreSQL had support already [2]) so people can do these kind of smooth transitions in their Smalltalk apps.

[1] https://github.com/sebastianconcept/Mapless

[2] https://blog.sebastiansastre.co/article/mapless-is-online-ag...

• logpaste

  8 310 7.7 Go

  A simple web service for storing text log files

FWIW, I've used Litestream on Google Cloud Run and never run into issues, but I haven't pushed it much:

https://github.com/mtlynch/logpaste/blob/master/docs/deploym...

• cod-stats

  2 18 0.0 Shell

  All-inclusive ETL pipeline to pull Modern Warfare statistics and generate statistical reporting for a playgroup

• pgloader

  31 5,078 3.0 Common Lisp

  Migrate to PostgreSQL in a single command!

awesome! https://pgloader.io/ can do it in the other direction.

Suggest a related project