mildbyte

5 ms·

1.
by mildbyte 1y ago
Funnily enough, I did a Sudoku one too (albeit with Poetry) a few years ago: https://github.com/mildbyte/poetry-sudoku-solver
2.
Solving Wordle with uv's dependency resolver(mildbyte.xyz)
208 points by mildbyte 1y ago|18 comments
3.
by mildbyte 2y ago
Have you seen duckdb_fdw ( https://github.com/alitrack/duckdb_fdw )? IIRC it's built based on sqlite_fdw, but points the outbound queries to DuckDB instead of SQLite, and it does handle running aggregations inside o
4.
by mildbyte 2y ago
Another difference is that this solution uses parquet_fdw, which handles fast scans through Parquet files and filter pushdown via row group pruning, but doesn't vectorize the groupby / join operations above the table scan in the q
5.
by mildbyte 3y ago
Damn, literally a day after I wrote up my experiments[0] with LLaVA 1.5 and computing image embeddings. Interesting to see the performance with the fine-tuned Mistral-7B variant being pretty close to the one with Vicuna-13B - using Mistral
6.
Generating image embeddings on a GPU with LLaVA and llama-cpp-Python(mildbyte.xyz)
3 points by mildbyte 3y ago|0 comments
7.
EDB Acquires Splitgraph(splitgraph.com)
4 points by mildbyte 3y ago|0 comments
8.
Rudderstack Switches to Elastic License(github.com)
1 points by mildbyte 3y ago|0 comments
9.
The Most Mysterious Song on the Internet(en.wikipedia.org)
129 points by mildbyte 3y ago|42 comments
10.
by mildbyte 4y ago
You can indeed run LiteFS by yourself, without Consul, as a sidecar / wrapper around your application. We do it in our project and have a Docker Compose example at [0]. In this case, you specify a specific known leader node. We haven&#
11.
by mildbyte 4y ago
Thanks for the catch! Fixed.
12.
by mildbyte 4y ago
I mentioned it recently[0], but this looks like a very good topic to plug our new database, Seafowl, that we released last year [1]. It also uses Apache DataFusion (like IOx) and separates storage and compute (like Neon, Snowflake etc) but
13.
by mildbyte 4y ago
> why not just accept SQL and cut out all the unnecessary mapping? You might be interested in what we're building: Seafowl, a database designed for running analytical SQL queries straight from the user's browser, with HTTP CDN-
14.
by mildbyte 4y ago
It's possible! Currently this is running GROUP BY queries using Socrata's query API on the original government data portal. We're adding the ability to import data from these sources into a columnar format in the future, eith
15.
Show HN: Socrata Roulette – run random SQL on a random government dataset(splitgraph.github.io)
5 points by mildbyte 4y ago|2 comments
16.
by mildbyte 4y ago
It could be the NDJSON parser (DF source: [0]) or could be a variety of other factors. Looking at the ROAPI release archive [1], it doesn't ship with the definitive `columnq` binary from your comment (EDIT: it does, I was looking in th
17.
by mildbyte 4y ago
And if you're looking for a similar experience (very fast analytical SQL queries) but over HTTP, for example, to power a public dashboard or a visualization, you can try ROAPI [0] or Seafowl [1], also built on top of DataFusion (discla
18.
by mildbyte 4y ago
Great question! With Seafowl, the idea is different from what the modern data stack addresses. It's trying to simplify public-facing Web-based visualizations: apps that need to run analytical queries on large datasets and can be access
19.
by mildbyte 4y ago
Just wanted to also give a shout out to Apache DataFusion[0] that IOx relies on a lot (and contributes to as well!). It's a framework for writing query engines in Rust that takes care of a lot of heavy lifting around parsing SQL, type
20.
by mildbyte 4y ago
Just to follow up on this, I got it working, thanks for the help! (for anyone else interested in all the details of getting LiteFS to run with Docker Compose + a Rust SQLite client: https://github.com/splitgraph/seafowl
21.
by mildbyte 4y ago
We managed to get it working for analytical SQL queries [1] for our database. It's kind of questionable whether this is an intended use of Cloudflare, but it feels like it, since we use it for query results, which are essentially a sta
22.
by mildbyte 4y ago
Hey HN, A new project from us at Splitgraph: Seafowl, a database that's optimized for Web applications running analytical SQL queries straight from the user's browser. Used to power interactive visualizations and dashboards. Featu
23.
Show HN: Seafowl – CDN-friendly analytical database(seafowl.io)
3 points by mildbyte 4y ago|1 comments
24.
by mildbyte 4y ago
Ah, sweet (and thanks for building Litestream/LiteFS)! This should work great for us, will definitely try to get a PoC going with this.
25.
by mildbyte 4y ago
The live replication (as it used to work in Litestream before the LiteFS move, without Consul) would have been perfect for our use case with Seafowl (I played around with Litestream before that but had to settle on PostgreSQL for the sample
26.
(Ab)using CDNs for SQL queries(splitgraph.com)
1 points by mildbyte 4y ago|0 comments
27.
by mildbyte 4y ago
Kind of off-topic, but this person's e-mail address is "dot at dotat dot at", which is very unique (see https://dotat.at/email.html ).
28.
by mildbyte 4y ago
Hey, I co-built Seafowl, thanks for the plug! To clarify, Seafowl itself can't be hosted statically (it's a Rust server-side application), but it works well for statically hosted pages. It's basically designed to run analytic
29.
Solving Sudoku with Poetry's dependency resolver(splitgraph.com)
3 points by mildbyte 4y ago|0 comments
30.
by mildbyte 4y ago
The "running WASM on the server" use case is pretty fun and applies to whenever you want to execute untrusted user code and limit its capabilities / resources, e.g. for plugins. For example, we use it in Seafowl [1] for user-

More ›