Vet clinic database: database performance audit

"Vet clinic database: database performance audit" is a database where we optimized some slow queries.

Queries that we optimized:

• SELECT COUNT(*) FROM visits where animal_id = 4;

before after

• SELECT * FROM visits where vet_id = 2;

before after

• SELECT * FROM owners where email = 'owner_18327@mail.com';

before after

Getting Started

To get a local copy up and run the app, follow these simple example steps.

Prerequisites

• Postgres

Setup

Clone the repository with:

git clone git@github.com:safafa/vet_db.git

or download ZIP file

Run the commands from schema.sql and data.sql to create the database locally.

Authors

👤 Aleksandar Ivezic

• GitHub: @Aleksandar Ivezic
• Twitter: @AIvezic
• LinkedIn: Aleksandar Ivezic

👤 Safa Aballagh

• GitHub: @Safafa
• Twitter: @safa aballagh
• LinkedIn: Aballagh Safa

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Feel free to check the issues page.

Show your support

Give a ⭐️ if you like this project!

Acknowledgments

• This project was inspired by Microverse