What is SQLite?
Who uses SQLite?
Here are some stack decisions, common use cases and reviews by companies and developers who chose SQLite in their tech stack.
We hope to develop to Big PWA Hybrid application for our company (Which should include a good performance). For that, What is the best database out of IndexedDB and SQLite? What would be the best one to choose from?
Hi all. I want to rewrite my system. I was a complete newbie 4 years ago and have developed a comprehensive business / finance web application that has been running successfully for 3 years (I am a business person and not a developer primarily although it seems I have become a developer). Front-end is written in native PHP (no framework) and jQuery with backend and where many processes run in MySQL. Hosted on Linux and also sends emails with attachments etc. The system logic is great and the business has grown and the system is creaking and needs to be modernised. I feel I would stick with MySql as DB and update / use Django / Spring or Laravel (because its php which I understand). To me, PHP feels old fashioned. I don't mind learning new things and also I want to set the system up that it can be easily migrated to Android/iOS app with SQLite. I would probably employ an experienced developer while also doing some myself. Please provide advice -- from my research it seems Spring/Java is the way to go ... not sure. Thanks
How to secure my offline (most of the time) Desktop Application with an annual subscription (online)? Do I block decompiling jar, hack DateTime local system date, or encrypt SQLite database? Give advice on the best possible way to achieve this.
In windows, how do I handle patching attacks modifying the registry? Is it secure to use windows registry to store secrets like the 'date of expiring' of the subscription? So that I can check the same and pop up the user to recharge themself and activate for next 1 year.
I need to add a DBMS to my stack, but I don't know which. I'm tempted to learn SQLite since it would be useful to me with its focus on local access without concurrency. However, doing so feels like I would be defeating the purpose of trying to expand my skill set since it seems like most enterprise applications have the opposite requirements.
To be able to apply what I learn to more projects, what should I try to learn? MySQL? PostgreSQL? Something else? Is there a comfortable middle ground between high applicability and ease of use?