OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
I don't really want a wholly different language - I'm happy with SQL most of the time. (I've even written a tool for ubiquitus data access with sql - OctoSQL - so there's that.)
TestContainers is a NodeJS library that supports tests, providing lightweight, throwaway instances of common databases, Selenium web browsers, or anything else that can run in a Docker container.
The Test Containers project is pretty great for this, and I've personally had success with the stock postgres image and the testcontainers-node library.
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
The Fastest Way to Build the Fastest Data Products. Build data-intensive applications and services in SQL — without pipelines or caches — using materialized views that are always up-to-date. (by MaterializeInc)
Alternatively, you can install Materialize, configure change data capture to stream the relevant data to it and then write this query as a live view that gets instantly and incrementally updated instead of performing it periodically.
Postgres Explain Visualizer 2
Interesting blog, thanks! I never knew https://explain.dalibo.com/ before but it looks really usefull
Sqlc – generate fully type-safe idiomatic code from SQL
1 project | news.ycombinator.com | 9 May 2022
Golang backend with lots of raw SQL queries
5 projects | reddit.com/r/golang | 2 May 2022
Taming SQL and ORMs with sqlc — go get it #001
1 project | reddit.com/r/golang | 28 Apr 2022
Taming SQL and ORMs with sqlc – go get it #001
1 project | news.ycombinator.com | 28 Apr 2022
Introducing StarfishQL - visualizing the dependency network on crates.io
4 projects | reddit.com/r/rust | 4 Apr 2022