This list is constantly growing. Not seeing a database or file type you need? Open an issue .
Visit datastation.multiprocess.io → On Hacker News Jan 2022 – Jun 2022
Software Engineering 3Systems & Performance 2Databases & Data 2Tools & Productivity 1Open Source 1Life, Learning & Writing 1
I quit my job as an engineering manager at Oracle in early June 2021. I had a bit of savings and a few contract opportunities so I decided to see how far I could get building an app I've wanted for years as a manager. I have never built my own app before and I've never built a desktop app before.
dsq is a commandline tool for running SQL queries against all the data file types that DataStation supports (JSON, CSV, Parquet, Excel, etc.). Here is a simple example:
Most people use the mattn/go-sqlite3 package to interact with SQLite in Go. This package uses cgo and bundles the SQLite C amalgamation files with the Go source.
I was looking into some of octosql 's benchmarks the other day and noticed a large chunk of time in DataStation / dsq is spent in encoding JSON objects. JSON is an intermediate format in DataStation and it's pretty inefficient. But the reason it's used is because almost every scripting language supported by…
A wire protocol is the format for interactions between a database server and its clients. It encompasses authentication, sending queries, receiving responses, and so on. It is a description of the exact bytes sent and received by servers and clients. It does NOT encompass the actual query language itself, let alone…