Download the latest version of SQLite for Mac - SQL database connection development library. Read 3 user reviews of SQLite on MacUpdate. Download SQLiteStudio for Windows to manage your SQLite database with export, import, and store history option. For example, Mac OS X comes pre-isntalled with SQLite and can be executed using the sqlite3 command. However, you may need to install SQLite in some cases and on other OSes. How to Install SQLite On Mac. SQLite comes preinstalled on Mac, so you can simply open the terminal application and type sqlite3 to launch the server.
I am currently re-writing the portion of the code that involves reading the files that have been downloaded and deciding what are the next set of files to download. This involves reading file names in a directory and sorting them in descending order so that I can find out what was the most recent date. I quickly ran into the problem during the sort because dates like “2013_12_2” were placed right beside “2013_12_20” and the only way I can sort it properly is if I put them into “date” objects. Hence I decided to move away from using fopen() on files and store everything into a database instead. This will also help in optimise performance when I am reading and writing values using database.
So I spent the last 2 weeks researching between PyTables and SQLite and finally settled on SQLite. At first I was learning towards PyTables because :
Sqlitestudio 3.2.1
- It had natural built in support for Python syntax in object form.
- It is free.
- Came pre-installed with Anaconda
- Natural support for DateTime objects
- Uses ViTables to view the tables.
Sqlitestudio Download
SQLite has the following advantages :
- Uses SQL-like query syntax which is something of an industry standard
- Free
- Comes pre-installed with Anaconda
- With v3, it supports Date and DateTime (Timestamp) columns
- Quite a couple of software that can be used to view the tables. I decided to use SQLiteStudio.
![Sqlitestudio Download For Mac Sqlitestudio Download For Mac](/uploads/1/2/6/5/126505946/944898350.jpg)
Sqlitestudio Windows 10
So in the end I decided to go for SQLite because it allows me the chance to familiarise the SQL Syntax, plus the datatype support is sufficient for me to move forward and SQLiteStudio software on Mac OS X works good! Supposedly ViTables should work fine on any platform but there was no straightforward way of installing the software on Mac OS X. I guess the disadvantage of not using PyTables is that I will miss out on using NumPy or Pandas.