Skip to main content

Posts

Showing posts with the label javascript

electron-db 0.16: A Tiny JSON Database for Electron, Now with Promises and Speed

electron-db 0.16 is out: the small JSON-file database for Electron now has async/await, answers lookups by id in a hundredth of a millisecond, and saves a thousand inserts in 22 ms instead of 55 seconds. If you build a desktop app with Electron, you hit the same question early: where do I keep the app's data? A full database means native modules, rebuilds for every Electron version and a schema. Often you just need a few tables of records that survive a restart. That is what electron-db is for. Each table is one readable JSON file in your app's data folder. There are no dependencies and no native code, so npm install is the whole setup, and the API reads like a tiny SQL: create a table, insert rows, then get, update and delete them with a where clause. Getting started Install it in your Electron app: npm install electron-db Then use it from the main process: const db = require('electron-db'); db.createTable('customers', (succ, msg) => { console.lo...

How I used Google Sheets and Apps Script

Google Sheet is one of the most powerful spreadsheet application that exists online, rivaling with Microsoft's Excel. One of the main strengths is its strong support for collaboration with other users, much easier and popular than collaboration tools with Microsoft Office. Aside from plain spreadsheet, it also supports extensions such as macro. If you are familiar with macros on other office tools, they work almost the same. However, the most extension I use and tinker with is the Apps Scipt . Apps Script Extension One of the challenges I faced recently is how do I track or monitor reports in our department if they are submitted on time or worst, forgotten due to lack of better monitoring tools. So I thought if there can be simple applications that can be deployed or use by a more general user to allow reminding periodically what reports are approaching due dates or those that are past dues. Then I looked for a way, instead of creating a full blown app from scratc...