Originally I and my colleague Tonya Smyrnova shared this material to Syndicode blog.
In my regular JS digests, there is always a room for some new interesting tools and solutions I found. For example, for AlaSQL open source SQL database for JS that allows you to export, store, and import data from localStorage, IndexedDB, or Excel.
This library is designed for:
- Fast in-memory SQL data processing for BI and ERP applications on fat clients
- Easy ETL and options for persistence by data import/manipulation/export of several formats
- All major browsers, Node.js, and mobile applications
Taking the advantage of the dynamic nature of JS allows us to focus on the speed of building queries. Real-world solutions demand flexibility regarding where data comes from and where it is to be stored. AlaSQL helps you focus on flexibility by making sure you can import/export and query directly on data stored in Excel (both
.xlsx), CSV, JSON, TAB, IndexedDB, LocalStorage, and SQLite files.
Check AlaSQL repository here. Try it!
Also, explore my latest JS digest with the most popular and interesting open source repositories! The new one will be issued by the end of this week!