CODEWITHSUNDEEP
pythondatabasepython-3.xsqliteportability
Pandian Muninathan
Pandian Muninathan

Reputation: 55

Alternate solution for portable database other than sqlite for python program

I'm comfortable with sqlite but when I use two different python program to access the same database. It throws an error like table is locked.

What are the different portable database to use with python?

Upvotes: 1

Views: 5568

Answers (1)

Andrew E
Andrew E

Reputation: 8327

SQLite is great but is designed as a small, fast, single user database. it isn't designed for the use you describe.

You can just pretty much any database with Python. The Python database API provides a straightforward way to interface with most relational databases, including SQLite.

However, to interact with a database in a more natural Python style, I've enjoyed using SQLAlchemy. It took a bit to work through the tutorial but it's great.

My personal preferred database is Postgres, but there are many other choices.

Upvotes: 1

Related Questions