Show HN: SQL Dry Runs with SQL Simulator

• cowblock

  1 16 0.0 Rust

  Block-level copy-on-write tool

I had this exact use cases a few months back: a big SQLite DB I didn't want to duplicate (and use twice the storage) before testing a change, on a filesystem without copy-on-write.

I wrote a fuse tool to provide copy-on-write for the file instead: https://github.com/remram44/cowblock

• pgtestdb

  2 99 6.8 Go

  quickly run tests in their own temporary, isolated, postgres databases

Hi Weston, congratulations on launching. You've done a great job of explaining what the project is and how it works. I'm not in the ecosystem you've built this for so I can't comment too much on the project itself, but nice work communicating it.

If anyone is interested in testing code/sql against postgres, I recently released https://github.com/peterldowns/pgtestdb. It uses template databases and advisory locks to give each test its own unique database with a near-zero marginal cost for each additional test. Combined with a ram/tmpfs-backed postgres server that is tuned for performance, it goes extremely fast.

Currently just for golang but I'm planning on releasing equivalent-capability libraries for Python and Typescript over the next month. If anyone has any thoughts/comments/feedback/suggestions I'd be extremely thankful.

• 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.

  

Suggest a related project