Below is what I do for clearing and compressing my SQLite database files in Qt. Usually when you delete some entries from a SQLite database, it does not get deleted physically but instead it just gets marked as deleted and is not retrieved in queries. The good thing about this is that it works fast. But the obvious downside is the fact that the free space is not released. To release the space occupied by deleted files you need to do the following:
Continue reading “How to Reduce Your SQLite Database File Size Using Qt”MSSQL Browser Lite is Available for Download on Softpedia
Now you can also download MSSQL Browser Lite from Softpedia. It’s marked 100% clean and it’s also 100% free. Enjoy!
Here is the download link:
http://www.softpedia.com/get/Internet/Servers/Database-Utils/MSSQL-Browser-Lite.shtml
Continue reading “MSSQL Browser Lite is Available for Download on Softpedia”
How to use ODBC in Qt
ODBC (Open Database Connectivity) drivers allow connection to many databases out of the box. In Windows and Qt you can use ODBC Plugin (for Qt) to connect to those databases.
Continue reading “How to use ODBC in Qt”