SQLite is good for small to medium databases. It sort of replaces MS-Access databases. I used to earn a lot of money in MS-Access with AccessBasic/VBA programming and forms and reports. Now you can use any language with SQL hooks to use SQLite.
I remember my time as a federal contractor for the Military and they had Oracle DATABASES in SunOS and I had to export to a fixed field text file and ftp download it and import it into MS-Access or SQL Server. A lot of small databases were still in DOS using Clipper or Lotus 123 and I had to convert them to MS-Access and SQL Server. Today I suppose they can import them into SQLite databases?
I remember my time as a federal contractor for the Military and they had Oracle DATABASES in SunOS and I had to export to a fixed field text file and ftp download it and import it into MS-Access or SQL Server. A lot of small databases were still in DOS using Clipper or Lotus 123 and I had to convert them to MS-Access and SQL Server. Today I suppose they can import them into SQLite databases?