|
<< Click to Display Table of Contents >> Navigation: Telegram > 2020 > 03 > 02 > Telegram_2020-03-02T14 |
2020-03-02T14:21:38
Switching to SQLite for my database for easy deployment on VPS; did anyone try that and if so, any issue encountered?
2020-03-02T14:23:27
SQLite works fine, but as a DB it has a few quirks.. but once you learn them its quite capable...such as columns are NOT hard typed...a column can really hold any type......
2020-03-02T14:23:35
and how it threads etc....
2020-03-02T14:24:05
it basically serializes all calls because the SQLite guys are node people and say \threads are evil\.. Im not joking.. its like the first entry in their FAQ
2020-03-02T14:24:52
JS and node are like the corona virus or ebola of computer science.
2020-03-02T14:25:18
But, once you learn those quirks, sqlite actually works pretty well otherwise for low to medium demand deployments.
2020-03-02T14:28:03
Thank you! I have some limitations that would force me to spend lots of money to acquire rad entreprise edition in order to connect to a remote database. I think the embedded SQLite would be suitable
2020-03-02T14:36:48
Understood. SQLite should be fine once you learn those few quirks.