Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
mildbyte
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
17 ms
·
31.
▲
SELECT Directly from the Browser
(splitgraph.com)
1 points
by
mildbyte
4y ago
|
0 comments
32.
▲
by
mildbyte
4y ago
We might have what you're looking for with sgr [0] (I'm the co-founder) which works by running SQL commands on top of a PostgreSQL instance and uses PostgreSQL audit triggers for versioning, though note it currently only works on
33.
▲
Solving Sudoku with Poetry's dependency resolver
(splitgraph.com)
1 points
by
mildbyte
4y ago
|
0 comments
34.
▲
Solving Sudoku with Poetry's dependency resolver
(splitgraph.com)
8 points
by
mildbyte
4y ago
|
1 comments
35.
▲
Show HN: Splitgraph.yml – Terraform for your data stack
(splitgraph.com)
1 points
by
mildbyte
4y ago
|
0 comments
36.
▲
by
mildbyte
4y ago
Another similar option is cstore_fdw [0] -- it's now part of Citus but can still be used standalone as a foreign data wrapper. We use it at my startup to do OLAP on Postgres. It has some advantages on parquet_fdw: * Supports writes (ac
37.
▲
Combining multiple GraphQL back ends with schema stitching
(splitgraph.com)
1 points
by
mildbyte
4y ago
|
0 comments
38.
▲
Aggregation Pushdown in Postgres Elasticsearch FDW
(splitgraph.com)
2 points
by
mildbyte
5y ago
|
0 comments
39.
▲
Aggregation Pushdown in Postgres Elasticsearch FDW
(splitgraph.com)
5 points
by
mildbyte
5y ago
|
0 comments
40.
▲
Adding aggregation pushdown to Postgres FDW for 100x speedup querying Snowflake
(splitgraph.com)
2 points
by
mildbyte
5y ago
|
0 comments
41.
▲
Adding aggregation pushdown to Postgres FDW for 100x speedup querying Snowflake
(splitgraph.com)
3 points
by
mildbyte
5y ago
|
0 comments
42.
▲
PostgreSQL FDW aggregation support in Multicorn
(splitgraph.com)
1 points
by
mildbyte
5y ago
|
0 comments
43.
▲
Show HN: Turn CSVs into a PostgreSQL Endpoint or a REST API
(splitgraph.com)
6 points
by
mildbyte
5y ago
|
0 comments
44.
▲
Adding PostgreSQL FDW aggregation support to Multicorn
(splitgraph.com)
1 points
by
mildbyte
5y ago
|
0 comments
45.
▲
Airbyte, dbt, Splitgraph: how we built our modern data stack
(splitgraph.com)
1 points
by
mildbyte
5y ago
|
0 comments
46.
▲
Preview Environments: how we deploy temporary Splitgraph instances
(splitgraph.com)
1 points
by
mildbyte
5y ago
|
0 comments
47.
▲
by
mildbyte
5y ago
The other founder of Splitgraph here! I've been experimenting recently with this, since we want users to be able to write to Splitgraph images efficiently without having to turn them into PG tables and then re-snapshot them. My setup i
48.
▲
by
mildbyte
5y ago
Splitgraph ( https://www.splitgraph.com ) | Remote | Full-time Splitgraph is reshaping how organizations interact with data. We provide a unified interface to discover and query data. In practice, this means we're building a
49.
▲
by
mildbyte
5y ago
Splitgraph ( https://www.splitgraph.com ) | Remote | Full-time Splitgraph is reshaping how organizations interact with data. We provide a unified interface to discover and query data. In practice, this means we're building a
50.
▲
by
mildbyte
5y ago
We're building something that partially overlaps with this at Splitgraph [0] (co-founder here). Instead of bitemporal tables, we're using columnar storage (cstore_fdw) + delta compression as a storage backend and support Git-like
51.
▲
by
mildbyte
6y ago
We use it in anger at Splitgraph [0] to let people upload/download datasets and Postgres table snapshots (instead of storing them directly in S3). Pros: * Less platform-dependent. By self-managing it, we can also run deploys to GCP &#x
52.
▲
by
mildbyte
6y ago
We have something that might work for your use case with Splitgraph [0] (co-founder here)! Basically, it's a custom version of PostgreSQL that supports git + Docker-like operations (versioning, sharing, branching, delta compression, Do
53.
▲
by
mildbyte
6y ago
Couple reasons: We don't actually have a massive PostgreSQL instance with all the datasets: we store them in object storage using cstore_fdw. In addition, we can have multiple versions of the same dataset. Basically, when a REST query
54.
▲
by
mildbyte
6y ago
PostgREST is great and really reduces the boilerplate around building REST APIs. They recommend implementing access rules and extra business logic using PostgreSQL-native features (row level security, functions etc) but once you get your he
55.
▲
by
mildbyte
6y ago
We use them in production at Splitgraph [0] to power our DDN (like a CDN, but for data). We make a PostgreSQL-compatible endpoint available to the public to query any of the tens of thousands of open datasets by referencing them as virtual
56.
▲
Dogfooding Splitgraph for cross-database analytics in Metabase
(splitgraph.com)
1 points
by
mildbyte
6y ago
|
0 comments
57.
▲
Dogfooding Splitgraph for cross-database analytics in Metabase
(splitgraph.com)
4 points
by
mildbyte
6y ago
|
0 comments
58.
▲
by
mildbyte
6y ago
Hey George, thanks for the comment and for the good points! We want to initially focus on the use case with lots of diverse backend datasets and ad-hoc APIs (maybe with a no-code like solution on top of a generic FDW) where performance won&
59.
▲
by
mildbyte
6y ago
I think we fixed this now, was a bug in how we did our client introspection query rewrites (wasn't actually DBeaver-specific). Could you try again when you have the chance?
60.
▲
by
mildbyte
6y ago
Yeah, sorry, got too excited! It will return JSON by default and CSV with Accept: text/csv: $ curl -sH "Accept: text/csv" https://data.splitgraph.com/cityofchicago/covid19-daily-cases-deaths-and
More ›