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.

Denna kandidatrapport är skriven av åtta studenter i kursen Kandidatprojekt i mjukvaruutveckling, TDDD96, vid Linköpings universitet under våren 2020. Kandidatrapporten inkluderar en sammanfattning av det arbete som utförts i projektet. Till projektet tillhörde ett uppdrag på beställning av Digitala resursenheten vid Linköpings universitet. Uppdraget var att skapa en webbapplikation där examinatorer och handledare för kurser vid Linköpings universitet på ett enkelt och intuitivt sätt kan beställa mjukvara till sina respektive kurser. Projektgruppen jobbade agilt och byggde projektet i Python samt JavaScript. Applikationen nådde alla mål satta tillsammans mellan kunden och projektgruppen och resulterade i en fungerande produkt som kunde utökas och modifieras enligt kundens behov. Till kandidatrapporten inkluderas även individuella bidrag skrivna av vardera gruppmedlem som djupdykt inom ett specifikt ämne eller område.

The objective of this thesis was to design and implement a scalable and load efficient back-end system for web game services. This is of interest since web applications may overnight gain a significant increase in user base, because of viral sharing. Therefore designing the web application to service an increasing amount of users can make or break the application, in regard to keep the user base. Because of this, testing how well the system performs during heavy load can be used as a foundation when making a decision of when and where to scale up the application. The system was to be generically accessible through an Application Programming Interface (API) by the different game services. This was done using a RESTful architecture where emphasise was put on building the system scalable and load efficient. This thesis focuses on designing and implementing such a system, and how load testing can be used to evaluate this systems performance for an increasing amount of simultaneous clients using the web application. The results from load testing the implemented system was above the expectations, considering the hardware used when running the tests and hosting the system. The conclusion of this thesis is that by following REST when designing a web service, scalability becomes a natural part of how one would design the system.

This thesis deals with the task of three-dimensional scene reconstruction using image data obtained from multiple views. It is assumed that intrinsic parameters of the utilized cameras are known. The theoretical chapters describe the basic priciples of individual reconstruction steps. Variuous possible implementaions of data model suitable for this task are also described. The practical part also includes a comparison of false keypoint correspondence filtering, implementation of polar stereo rectification and comparison of disparity map calculation methods that are bundled with the OpenCV library. In the final portion of the thesis, examples of reconstructed 3D models are presented and discussed.