dbeaver
sql.js
Our great sponsors
dbeaver | sql.js | |
---|---|---|
27 | 43 | |
37,391 | 12,211 | |
3.3% | 1.0% | |
9.9 | 6.5 | |
1 day ago | 4 days ago | |
Java | JavaScript | |
Apache License 2.0 | 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.
dbeaver
-
DBeaver – open-source Database client
Yes but not in the community version:
https://github.com/dbeaver/dbeaver/wiki/Schema-compare
-
👻Top 8 Free, Open Source SQL Clients🔥
DBeaver is a veteran SQL client. In addition to basic visualization and management capabilities, it has a SQL editor, data and schema migration capabilities, monitor database connections, and more. It supports a full range of databases (both SQL and NoSQL). DBeaver is also hooked up with GPT-3, which converts your natural language to SQL.
-
Does the world need a new SQL editor?
If you want to do something meaningful, here's the DBeaver GitHub repo https://github.com/dbeaver/dbeaver. Go contribute a ChatGPT plugin & update the UI to look nicer.
-
SQLite is not a toy database
dbeaver is an excellent option as well, plus it supports basically every kind of SQL database in existence.
-
The Firefox snap: Updates and Upgrades
Curiously enough, just yesterday a snap broke on me. People on the github thread said reverting snap didn't work either - I'm not sure whether they simply couldn't revert, or they reverted and still had issues, as I just saw this and slapped on the flatpak instead of messing with my snap. I'm also not sure whether the snap revert didn't work because of something the dbeaver team screwed up there as well, however I'll make sure to avoid automatic/unattended updates in the future. I'm running Arch on my personal machine anyway, so it's not like I mind running updates regularly, but I'd rather do it at my own discretion.
- opensource sqlyog alternatives that beautify sql code
-
Issue with copying and pasting from certain sources
Please create a ticket and describe your issue here: https://github.com/dbeaver/dbeaver/issues/new/choose
-
DBeaver controls compared to Microsoft SQL
I did find https://github.com/dbeaver/dbeaver/issues/6064 marked as closed, perhaps that will help?
- BigQuery Table with JSON Error "The specified column type is currently unsupported by the driver for column JSON."
- newly started using dbeaver
sql.js
-
Show HN: Appendable – Index JSONL data and query via CDN
Hi HN! A friend and I were inspired by projects like https://github.com/sql-js/sql.js and the idea of querying files served over CDN with HTTP range requests. We started thinking: what would a database that was specifically designed for this type of use case look like? So we started building one, and we landed on a functional prototype that we're pretty proud of!
With our prototype, Appendable, we're able to serve and query large (GB+) datasets by hosting them on a static file host like Amazon S3 or Cloudflare R2 without running a separate server and worrying about things like tail latency, replication, and connection pooling -- all that is handled for us by the file hoster.
Additionally, one tenet that we have been following is Appendable won't touch your underlying data, so your jsonl file is preserved and we point at that data instead of consuming it into an Appendable-specific file format. This keeps your data yours and makes it easy to introspect the data: just open it up with your favorite editor aka vim.
We're curious what you think, we're excited to build this out further to get the performance even better and add features like pubsub. Everything is open source at https://github.com/kevmo314/appendable.
Kevin and Matthew
- How to show CRUD projects on Github?
-
I made a website where you can use SQLite in your browser
My project is powered by sql.js, I recommend checking that out if you're interested - https://github.com/sql-js/sql.js/
-
How to build interactive way to learn SQL using Next.js and database?
Maybe you can try to use some SQL database compiled as Web Assembly Modules? Like this one for example: https://github.com/sql-js/sql.js
-
Recommendations for data structure and storage
If you want to have persistence, then I would go with a database like Dexie, as it uses IndexedDB and has transactions. If you just want something that's in memory, you could look at Sql.js or something simple like lowdb.
-
I have a large JSON object (~2GB), what's the best way to make a site that lets you search through it and display the results without crashing?
not necessarily. you can host an html/js/sqlite site on github pages for free. json -> sqlite3 js -> sql
-
new release of : https://sql.js.org/
Link: https://sql.js.org
- Web-Projekt - Hilfe, weil ich nicht weiß, was ich benötige :S
- Learn Postgres at the Playground
-
Show HN: CSVFiddle – Query CSV files with DuckDB in the browser
Does it work with really large files? Like, >100mb or so. I was considering making something similar but with sqlite.js [1], but the problem with it is that it loads everything in memory, so I wasn't entirely sure how it will deal with larger workloads.
[1]: https://sql.js.org/#/
What are some alternatives?
dbgate - Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application
localForage - 💾 Offline storage, improved. Wraps IndexedDB, WebSQL, or localStorage using a simple but powerful API.
LINQ to DB - Linq to database provider.
LokiJS - javascript embeddable / in-memory database
liquibase - Main Liquibase Source
PouchDB - :koala: - PouchDB is a pocket-sized database.
Gravitational Teleport - The easiest, and most secure way to access and protect all of your infrastructure.
WatermelonDB - 🍉 Reactive & asynchronous database for powerful React and React Native apps ⚡️
LevelDB - LevelDB is a fast key-value storage library written at Google that provides an ordered mapping from string keys to string values.
DB.js - db.js is a wrapper for IndexedDB to make it easier to work against
mondrian - Mondrian is an Online Analytical Processing (OLAP) server that enables business users to analyze large quantities of data in real-time.
litestream - Streaming replication for SQLite.