Knowing which database management system to use for a project is difficult to know in advance. Luckily, there are tools that can help the developer apply the same database design on multiple different database management systems without having to change the code. In this thesis, we investigate the strengths of SQLAlchemy, which is an SQL toolkit for Python. We compared SQLite, PostgreSQL and MySQL using SQLAlchemy as well as compared a pure MySQL implementation against the results from SQLAlchemy. We conclude that, for our database design, PostgreSQL was the best database management system and that for the average SQL-user, SQLAlchemy is an excellent substitution to writing regular SQL.
| Identifer | oai:union.ndltd.org:UPSALLA1/oai:DiVA.org:liu-155648 |
| Date | January 2019 |
| Creators | Fredstam, Marcus, Johansson, Gabriel |
| Publisher | Linköpings universitet, Interaktiva och kognitiva system, Linköpings universitet, Tekniska fakulteten, Linköpings universitet, Interaktiva och kognitiva system, Linköpings universitet, Tekniska fakulteten |
| Source Sets | DiVA Archive at Upsalla University |
| Language | English |
| Detected Language | English |
| Type | Student thesis, info:eu-repo/semantics/bachelorThesis, text |
| Format | application/pdf |
| Rights | info:eu-repo/semantics/openAccess |
Page generated in 0.0016 seconds