This is the database for the mobile library project. The database is developed using PostgreSQL and PostGIS.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See the deployment for notes on how to deploy the project on a live system.
To get this database up and running you'll need a PostgreSQL Server, from version 10. With a compatible PostGIS installed.
To manually install the database schema, follow through the SQL scripts documented in the create.sql file. This could be done directly on the local database using a tool such as PGAdmin 4. Alternatively, move on to the deployment section to deploy directly to a server.
On a live system it is more likely you will need to remotely run the create.sql script, which is set up to be able to be run remotely using psql. In a Windows environment a sample of doing this is included in the create.bat file.
psql --set=sslmode=require -f create.sql -h host -p 5432 -U username postgresReplace the username and host with the appropriate values for your server.
- Dave Rowe - Initial work - DaveBathnes
See also the list of contributors who participated in this project.
This project is licensed under the MIT License - see the LICENSE.md file for details
- All mobile library services