Seafowl Alternatives

seafowl reviews and mentions

• Gcsfuse: A user-space file system for interacting with Google Cloud Storage
  15 projects | news.ycombinator.com | 6 Sep 2023

  In case you're interested in scale-to-zero database hosting, a few months ago I paired gcsfuse with Seafowl [0][1], an early stage open source database written in Rust. Was a lot of fun balancing tradeoffs that are usually not possible with classical databases e.g. Postgres. Thank you gcsfuse contributors.

  [0] https://seafowl.io

• DuckDB 0.8.0
  5 projects | news.ycombinator.com | 17 May 2023

  > why someone would start something in a memory unsafe language these days

  You might like what we (Splitgraph) are building with Seafowl [0], a new database which is written in Rust and based on Datafusion and delta-rs [1]. It's optimized for running at the edge and responding to queries via HTTP with cache-friendly semantics.

  [0] https://seafowl.io

  [1] https://www.splitgraph.com/blog/seafowl-delta-storage-layer

• We made a newsfeed for tracking new and deleted datasets across 200+ open data portals (and they're all queryable with SQL)
  2 projects | /r/datasets | 13 Apr 2023

  For example, here's the IPInfo dataset, and here's a some commodities data from Trase which is proxying to their live Postgres database, and powering their interactive dashboard. Also, here's the repository of Socrata metadata powering the newsfeed - we scrape it nightly and then push it to Seafowl, our new open-source database optimized for running cache-friendly queries "at the edge." The code for Open Data Monitor is on GitHub, if you're curious.

• Quicker Serverless Postgres Connections
  1 project | news.ycombinator.com | 28 Mar 2023

  This is basically how we do authentication in the Splitgraph DDN [0], which is kind of like a multi-tenant serverless Postgres.

  We implement the Postgres frontend with a forked version of PgBouncer, and we changed the authentication method such that when the user authenticates, we issue them a JWT which we store as a session variable. That session variable has the same security properties as a cookie in a web browser (the user can change/manipulate it, but if it's signed by us we can trust its claims).

  That's the simple explanation that skips over the multi-tenant part. I don't want to derail from the thread - Neon is very cool, and we are actually experimenting with it right now, for storing the Seafowl [1] catalog when deploying to "scale to zero" services like Google Cloud Run or AWS Lambda, which don't have persistent storage.

  [0] https://www.splitgraph.com/connect/query

  [1] https://seafowl.io

• Show HN: Free IP to Country and ASN Downloads from Ipinfo.io
  1 project | news.ycombinator.com | 1 Mar 2023

  This is really cool! I've always found IP data to be a compelling example of a data product, especially when talking about Splitgraph, a company of which I'm a co-founder (and btw - I also met my co-founder on HN!).

  So, I exported the CSV files for country and asn data, and then uploaded them to Splitgraph. You can see some sample queries in the readme of the repository [0]. Since Splitgraph is built on Postgres, it's possible to use all the `inet` and `cidr` tools available from Postgres, so you can make range queries easily. One sample query also demonstrates a join between the two tables, resulting in the equivalent of your combined country_asn.csv.

  Another idea: We have a newer project called Seafowl [1], which is an open-source analytical database optimized for running "at the edge," with cache-friendly semantics making it ideal for querying from Web applications. We don't have a self-hosted version of this yet, but perhaps the next thing to try would be loading this data into Seafowl and querying it "at the edge" - I've been thinking about ways that we could package Seafowl along as an OpenResty module, which could allow for true "at the edge" use cases like querying IP data in your reverse proxy. (Although the .mmdb format already solves this particular problem pretty efficiently and interoperably, although I'd be curious to measure the difference).

  [0] https://www.splitgraph.com/miles/ipinfo-country-asn

  [1] https://seafowl.io/

• I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS
  4 projects | news.ycombinator.com | 5 Jan 2023

  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't tried getting it running independently with Consul to do leader election / failover.

  [0] https://github.com/splitgraph/seafowl/blob/main/examples/lit...

• Ask HN: Serverless SQLite or Closest DX to Cloudflare D1?
  2 projects | news.ycombinator.com | 2 Jan 2023

  This is the vision of what we're building at Splitgraph. [0] You might be most interested in our recent project Seafowl [1] which is an open-source analytical database optimized for running "at the edge," with cache-friendly semantics making it ideal for querying from Web applications. It's built in Rust using DataFusion and incorporates many of the lessons we've learned building the Data Delivery Network [2] for Splitgraph.

  [0] https://www.splitgraph.com

  [1] https://seafowl.io

  [2] https://www.splitgraph.com/connect

• PostgREST – Serve a RESTful API from Any Postgres Database
  22 projects | news.ycombinator.com | 29 Dec 2022

  > 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-friendly caching [0]. It's a second iteration of the Splitgraph DDN [1] which we built on top of PostgreSQL (Seafowl is much faster for this use case, since it's based on Apache DataFusion + Parquet).

  The tradeoff for allowing the client to run any SQL vs a limited API is that PostgREST-style queries have a fairly predictable and low overhead, but aren't as powerful as fully-fledged SQL with aggregations, joins, window functions and CTEs, which have their uses in interactive dashboards to reduce the amount of data that has to be processed on the client.

  There's also ROAPI [2] which is a read-only SQL API that you can deploy in front of a database / other data source (though in case of using databases as a data source, it's only for tables that fit in memory).

  [0] https://seafowl.io/

  [1] https://www.splitgraph.com/connect

  [2] https://github.com/roapi/roapi

• Show HN: Socrata Roulette – run random SQL on a random government dataset
  1 project | news.ycombinator.com | 9 Dec 2022

  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, either into Splitgraph itself or syncing the data out into Seafowl (https://seafowl.io/) which uses Parquet and is much faster.

  Technically, the ability is already there (you can add a dataset to Splitgraph and select Socrata as a source if you know the dataset ID), but it's not as turnkey as landing on a dataset page and clicking a button. More to come!

• Welcome to InfluxDB IOx: InfluxData’s New Storage Engine
  5 projects | news.ycombinator.com | 26 Oct 2022

  Just wanted to 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 casting, constructing and transforming query plans and optimizing them. It's pluggable, making it easy to write custom data sources, optimizer rules, query nodes etc.

  It's has very good single-node performance (there's even a way to compile it with SIMD support) and Ballista [1] extends that to build it into a distributed query engine.

  Plenty of other projects use it besides IOx, including VegaFusion, ROAPI, Cube.js's preaggregation store. We're heavily using it to build Seafowl [2], an analytical database that's optimized for running SQL queries directly from the user's browser (caching, CDNs, low latency, some WASM support, all that fun stuff).

  [0] https://github.com/apache/arrow-datafusion

  [1] https://github.com/apache/arrow-ballista

  [2] https://github.com/splitgraph/seafowl

• A note from our sponsor - WorkOS
  workos.com | 24 Apr 2024

  The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →