137 karma · joined November 26, 2012
Long story short, if requirements aren't strictly real time collaborative and online-enabled, I've found rolling something yourself more in the vein of a "fat client" works pretty well too for a nice performance boost. I generally prefer using IndexedDB directly— well via Dexie, which has reactive query support.
Similar; surely more expensive big picture, but far more convenient.
The API is just different compared to SQL, which is a downside for many. There's modern advancements in the space with IVM and more databases are supporting probabilistic data structures.
I don't think folks work with Redis out of fondness for the model, but because it's the least worst datastore for caching, lightweight message broker, and simple realtime things like counters.
Just replace github.com in any repo’s URL with gitrelate.com or gitrelated.com, and you can see other repositories that people who starred the original repo also liked. Works best with obscure niches with ~100 stargazers.
You may or may not be familiar with the DBT semantic layer. It's out of reach due to cost for many folks— requires expensive monthly fees.
SQLMesh includes a query rewriter if you have defined any metrics, so I simply added it to the existing buenavista query rewriter and added a sample SQLMesh project. Cheers.
Sidenote: GoogleSQL with pipe syntax is available in alpha already if you use BigQuery (https://cloud.google.com/bigquery/docs/pipe-syntax).
Protips:
- Connect a folder of .csv or .parquet files and they'll all be registered as tables
- There is very little chart configuration required and it's easy for both SQL enjoyers and non alike to explore data
- Coordinated timeseries hover makes it simple to compare metrics at the same time period
- Any DuckDB aggregation function is supported as a custom expression when adding a metric
Check out what Postico does; it just highlights the current statement under the cursor by default and that's what gets run by default. Can't resist imposing this subtle SQL UX on everyone because it's my favorite (for like 10 years now).
SQL is not only relevant to traditional databases. I never got into C#, but LINQ looks really interesting.
Is your workflow severely impaired when on a laptop alone? I.e. in a coffee shop?
You can scale the UI, but the monitor just so pleasant at 1/4 effective res. Embrace cmd + tab. And tmux.
iSSH includes the mosh protocol as a 99c in-app purchase. Use mosh on your mobile device, just where it should be!