sqlite_scanner
budibase
Our great sponsors
sqlite_scanner | budibase | |
---|---|---|
4 | 332 | |
184 | 20,552 | |
2.2% | 2.8% | |
8.3 | 10.0 | |
7 days ago | 6 days ago | |
C | TypeScript | |
MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlite_scanner
-
DuckDB 0.7.0
It's not a dumb question at all. I'm pretty knowledgeable with DBs and still find it very difficult to understand how many of these front-end/pass-through engines work.
Checkout Postgres Foreign Data Wrappers. That might be the most well known approach for accessing one database through another. The Supabase team wrote an interesting piece about this recently.
https://supabase.com/blog/postgres-foreign-data-wrappers-rus...
You might also want to try out duckdb's approach to reading other DBs (or DB files). They talk about how they can "import" a sqlite DB in the above 0.7.0 announcement, but also have some other examples in their duckdblabs github project. Check out their "...-scanner" repos:
-
Notes on the SQLite DuckDB Paper
DuckDB can actually read SQLite or Postgres directly! In the SQLite case, something like Litestream plus DuckDB could work really well!
Also, with Pyarrow's help, DuckDB can already do this with Delta tables!
-
Friendlier SQL with DuckDB
Excellent question! I'll jump in - I am a part of the DuckDB team though, so if other users have thoughts it would be great to get other perspectives as well.
First things first - we really like quite a lot about the SQLite approach. DuckDB is similarly easy to install and is built without dependencies, just like SQLite. It also runs in the same process as your application just like SQLite does. SQLite is excellent as a transactional database - lots of very specific inserts, updates, and deletes (called OLTP workloads). DuckDB can also read directly out of SQLite files as well, so you can mix and match them! (https://github.com/duckdblabs/sqlitescanner)
DuckDB is much faster than SQLite when doing analytical queries (OLAP) like when calculating summaries or trends over time, or joining large tables together. It can use all of your CPU cores for sometimes ~100x speedup over SQLite.
DuckDB also has some enhancements with respect to data transfer in and out of it. It can natively read Pandas, R, and Julia dataframes, and can read parquet files directly also (meaning without inserting first!).
Does that help? Happy to add more details!
budibase
- Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable
-
Ask HN: What is the easiest way to create a CRUD web app in 2024?
Budibase is great at generating CRUD apps based on a model.
-
Airplane acquired by Airtable and is shutting down
Congratulations to the Airplane team.
Is this Airtable moving in the direction of low-code rather than no code? Puts them up against tools like Budibase [https://github.com/Budibase/budibase] and Retool [Https://retool.com]
- Why I'm skeptical of low-code
-
Pipe Dreams: The life and times of Yahoo Pipes
I skipped to chapter 9 in the article ("Clogged"), and it looked like Pipes failed because it didn't have a large enough team or a well-defined mission. As a result they couldn't offer a super robust product that would lure in enterprise users. "You could not purchase some number of guaranteed-to-work Pipes calls per month" is the quote from the article.
The reason I think that interesting is because that's the model these days for everything from AI tokens to Monday.com seats. It makes me feel like Pipes was before its time.
That said I've been collecting different "business glue" products that are similar to Pipes. To me, like you say, they aren't as interesting, exciting and intuitive as Pipes was, but maybe it just takes a little more digging. I tried to focus on open source tools but some aren't.
- n8n io: https://n8n.io/integrations/mondaycom/
- Node-RED: https://nodered.org/ (just read about this one in this thread)
- trigger dev: trigger.dev
- automatisch.io: https://automatisch.io/docs/
- Activepieces: https://www.activepieces.com/docs/getting-started/introducti...
- Huginn: https://github.com/huginn/huginn
- budibase: https://budibase.com/
- windmill: https://www.windmill.dev/
- tooljet: https://www.tooljet.com/workflows
- Bracket: https://www.usebracket.com/pricing (just SalesForce <-> PostgreSQL)
- Zapier: zapier.com/
Anyway I hope some of these are fun!
-
Automate complicated manual business processes
Budibase is open-source, including the workflow platform which has helped accelerate thousands of workflows already:
- Launch HN: Refine (YC S23) – Open-Source Retool for Enterprise
-
Exploring Top 9 Retool Alternatives for Enterprise Applications in 2023
(4) Budibase | Build internal tools in minutes, the easy way. https://budibase.com/.
-
Launch HN: Twenty.com (YC S23) – open-source CRM
Also missing these app builders, both of which are open source but offer managed hosting:
* Budibase https://budibase.com
-
Small app using a DB?
Buildbase
What are some alternatives?
appsmith - Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
ToolJet - Low-code platform for building business applications. Connect to databases, cloud storages, GraphQL, API endpoints, Airtable, Google sheets, OpenAI, etc and build apps using drag and drop application builder. Built using JavaScript/TypeScript. 🚀
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
Directus - The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
n8n - Free and source-available fair-code licensed workflow automation tool. Easily automate tasks across different services.
saltcorn - Free and open source no-code application builder
Javinizer - (NSFW) Organize your local Japanese Adult Video (JAV) library
DockSTARTer - DockSTARTer helps you get started with running apps in Docker.
authentik - The authentication glue you need.
Node RED - Low-code programming for event-driven applications
Kanboard - Kanban project management software
lowdefy - The config web stack for business apps - build internal tools, client portals, web apps, admin panels, dashboards, web sites, and CRUD apps with YAML or JSON.