Install SQL Lite

[pwdel]

• SQL Lite on Mac is known to be much faster than an alternative such as an excel database or just a regular MySQL.
• Up to 100MB of SQLLite is fine.
• We can export the file to SQL and use this in MySQL or PostGreSQL, it may be fine for this size of database, but we'll say this is an option.
• Upshot: SQLite is for performance for Mac.

[pwdel]

For Windows Machines:

• Mac uses Apache as a webserver.
• Windows7 Pro or Windows10 Pro will use IIS as a server on your computer. When you install this, you can work with PhP and SQLite.

[pwdel]

Why should we use SQLite?

SQLite has published their own guide on, "Appropriate uses for SQLite."

https://www.sqlite.org/whentouse.html

Key takeaways:

• Embedded Devices
• SQLite database requires no administration, it works well in devices that must operate without expert human support.
• SQLite is often used as the on-disk file format for desktop applications
• Improved performance, reduced cost and complexity, and improved reliability. Basically: desktop software.
• Websites
• Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite.
• Data Analysis
• Raw data can be imported from CSV files, then that data can be sliced and diced to generate a myriad of summary reports. More complex analysis can be done using simple scripts written in Python

[pwdel]

We could also look at using a Graph database structure:

https://github.com/neo4j/neo4j

Internet of Things and Graph Databases: https://neo4j.com/news/internet-things-data-powerful-connection/ https://neo4j.com/blog/graph-databases-perfect-internet-things/ https://en.wikipedia.org/wiki/Neo4j

[pwdel]

Python wrangling with SQLite: https://medium.com/@williamkoehrsen/data-wrangling-with-python-and-sqlite-900d21bc5a53