5 ms·
During my first week at American Express I did not have the credentials to install any applications. My manager wanted me to build a prototype and I couldn't in
by songzme 9y ago
During my first week at American Express I did not have the credentials to install any applications. My manager wanted me to build a prototype and I couldn't install a database. Firebase and other third party was impossible because I had to work on an internal server. I thought SQLite would save my day, but I remembered it being really hard to install and set up. So I had to write my own DB that I called 'stupid-db'. It literally just reads/writes data into a file: https://github.com/songz/stupid-db https://github.com/songz/stupid-db
The demo went well.
- jitl 9y ago??? SQLite is a library, not a database server. There's no install step - it's a single .C file (and a header, if you're into that). Most of the major scripting languages have rock-solid bindings that don't require any additional system libraries or software installs. Python (in the stdlib!): https://docs.python.org/2/library/sqlite3.html https://docs.python.org/2/library/sqlite3.html Nodejs (prebuilt): https://www.npmjs.com/search?q=sqlite https://www.npmjs.com/search?q=sqlite Ruby (needs libs, which are preinstalled on macOS): https://rubygems.org/search?utf8=&query=sqlite3 https://rubygems.org/search?utf8=&query=sqlite3
- songzme 9y agoyou are right. this was also many years ago so my memory might fail me. Perhaps my internal server didn't have access to npmjs.
- Quarrelsome 9y ago> I remembered it being really hard to install and set up. eh? Sqlite was the quickest thing I ever setup in my life. Just add a .dll and use some form of adapter written in your language and off you go.