Release a Python application using MySQL Connector for database without the user having to install MySQL?

Question

I have created a CLI app in Python, a sort of library management system that uses a MySQL database to store records. If I wanted to release this as an installable app, could I do it without the end-user having to install MySQL on their own device, and going through the trouble of importing the database schema?

Note that the database is stored/hosted on the user's local machine and there is no web server interaction.

The only thing you need is the database driver, not the database itself. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Jan 18, 2024 at 14:44
@gargantuan You need to have MySQL installed on the local machine, or on the network it's connected to. If you didn't already know that you are short of sufficient understanding of your environment and shouldn't consider releasing your app at this point. — Tangentially Perpendicular
– Tangentially Perpendicular, Commented Jan 18, 2024 at 14:50
@TangentiallyPerpendicular I understood that, I was wondering if there is any way or alternative solution to deploy something like this. I'm a highschool student only learning MySQL/Python now, not really planning on releasing a production-ready app yet :) — Gargantuan5k
– Gargantuan5k, Commented Jan 18, 2024 at 15:07

Olivier Neve · Accepted Answer · 2024-01-18 16:23:49Z

1

This isn't possible using a DBMS like Mysql, Postgres, Mariadb. That is what SQLite is for. All you need for a SQLite database is to install the connector, form there the rest is handled.

Check out this example of database creation and querying.

import sqlite3

connection = sqlite3.connect("test")

cursor = connection.cursor()
cursor.execute("CREATE TABLE example (name TEXT, type TEXT, count INTEGER)")
cursor.execute("INSERT INTO example VALUES ('Sammy', 'shark', 1)")
rows = cursor.execute("SELECT * FROM example").fetchall()
print(rows)

You do not need to install the sqlite3 package with pip. As mentioned by a commenter, the package comes pre-installed with python.

Hope this helps!

edited Jan 18, 2024 at 16:23

answered Jan 18, 2024 at 14:52

Olivier Neve

3661 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ivvija Over a year ago

sqlite3 is an included package, no need for pip.

Olivier Neve Over a year ago

ah good call, hadn't realized ;)

Collectives™ on Stack Overflow

Release a Python application using MySQL Connector for database without the user having to install MySQL?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related