lawnchair.js
sql.js
Our great sponsors
lawnchair.js | sql.js | |
---|---|---|
0 | 43 | |
2,134 | 12,142 | |
- | 1.4% | |
0.0 | 7.1 | |
almost 4 years ago | about 2 months ago | |
JavaScript | JavaScript | |
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.
lawnchair.js
We haven't tracked posts mentioning lawnchair.js yet.
Tracking mentions began in Dec 2020.
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?
-
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/
Including custom aggregate functions in javascript, partly by me!
Link: https://sql.js.org
- Learn Postgres at the Playground
-
Extending SQLite with Rust
The reason I originally looked into this was to see if there's a way to use sqlite in wasm with indexeddb as the storage backend, getting a full SQL engine in the browser (like WebSQL, but actually using web standard API). Here is sqlite compiled to wasm, but only with the in-memory database, which is only of limited use. My conclusion was that it might be possible, but needs a ton of work in C interfacing with web APIs through emscripten, which is not fun at all.
- Front End Needs a Database
-
Awesome SQLite
sql.js - A javascript library to run SQLite on the web
What are some alternatives?
localForage - 💾 Offline storage, improved. Wraps IndexedDB, WebSQL, or localStorage using a simple but powerful API.
LokiJS - javascript embeddable / in-memory database
PouchDB - :koala: - PouchDB is a pocket-sized database.
WatermelonDB - 🍉 Reactive & asynchronous database for powerful React and React Native apps ⚡️
store.js - Cross-browser storage for all use cases, used across the web.
DB.js - db.js is a wrapper for IndexedDB to make it easier to work against
Cookies - JavaScript Client-Side Cookie Manipulation Library
basket.js - A script and resource loader for caching & loading files with localStorage
litestream - Streaming replication for SQLite.