Pandas DataFrame to Excel
How do you export a Pandas DataFrame to an Excel file? It’s very easy to do. This exercise […]
Mike
SQL Script into SQLite
Do you have a SQL script that you want to run against a SQLite database file? Perhaps you […]
Import CSV to SQLite
With DB Browser we can import a comma separated values (CSV) file into a SQLite database file. Using […]
From SQLite to SQL Script
Do you have a table of data in SQLite and you want to generate a SQL script that […]
Excel into Python (pandas)
Do you have some data in Excel that you would like to import into Python? You can do […]
SQL Server to CSV
It’s not hard to export data from a SQL Server table in SSMS to a CSV (comma separated […]
Generate a SQL Script
Do you need to generate a SQL script (a text file of SQL commands in an sql file) […]
From CSV to Excel
How do you convert a comma separated values (text file) into a Microsoft Excel file? If you have […]
Import and Export Tables
Do you need to convert data tables between different formats such as Excel or comma separated values? Are […]
From Excel to CSV File
How would you convert an Excel sheet to a CSV (comma separated values) file? You could open the […]
AES-256 Encryption
This is just a very quick introduction to AES-256 Encryption. The Advanced Encryption Standard (AES), originally adopted by […]
SQLCipher
What is SQLCipher? SQLCipher has been adopted as a secure database solution in thousands of commercial and open […]