philbe77

6 ms·

1. 31.▲
   by philbe77 2y ago

   Hi, I'm Philip Moore - founder of GizmoData ( https://gizmodata.com ). I recently posted on Show HN about my company's product: GizmoSQL - here: https://news.ycombinator.com/item?id=43427671 Since postin
2. 32.▲
   by philbe77 2y ago

   Hi chrisjc, these are interesting thoughts. I was mainly interested in providing a server interface for DuckDB b/c of the performance I observed when running large OLAP workloads, and especially the cost savings vs cloud SaaS offering
3. 33.▲
   by philbe77 2y ago

   Hi emthrowaway123 - I tried comparing to ClickHouse by signing up for a free trial - and attempting to run the TPC-H 22-query benchmark with Scale-Factor 1TB against data stored in S3. I repeatedly ran out of memory during benchmark query e
4. 34.▲
   by philbe77 2y ago

   Thanks for the kind words! I think the main advantages this has over other RDBMS's such as Postgres and MySQL is performance - due to the columnar / vector processing capabilities of DuckDB. I've run this in AWS with a i8g.1
5. 35.▲
   by philbe77 2y ago

   Hey mousematrix, I've tested with 3 concurrent sessions all writing to the same table - and with "BEGIN TRANSACTION" for each. I opened a TPC-H SF1GB database with GizmoSQL, started 3 concurrent client sessions, and had each
6. 36.▲
   Show HN: GizmoSQL – Run DuckDB as a Server with Arrow Flight SQL(github.com)

   17 points by philbe77 2y ago|8 comments