Python How can I build a database in Python?

Click For Summary
Building a database in Python is feasible and can be approached using various frameworks and libraries. Sqlalchemy is a widely recommended tool for database integration, as it is compatible with many Python web frameworks. For web applications, Django is the most popular choice due to its comprehensive documentation and extensive resources, although it may be excessive for simpler projects. Flask is suggested as a more lightweight alternative. For desktop applications, Camelot and Dabo are viable options. The discussion emphasizes the importance of selecting the right framework based on whether the application is web-based or desktop-oriented, and highlights the need for a good interface for data entry.
PotentialE
Messages
57
Reaction score
0
Does anyone have a good tutorial or start-up advice for building a database in Python? The only database software I've ever used is Microsoft Access, but I've heard it's possible to build databases in Python.

I was thinking I'd start off with a simple database: a few tables that can draw information from one another. Basically, what I'm unsure of is creating an optimal interface to enter data. Any hints / guidance or pertinent links would be helpful.

Thanks!
 
Technology news on Phys.org
Sqlalchemy is very popular for integrating with databases. Many Python web frameworks use it.

Did you want something that works on the web or on the desktop?

For the web, Django has become the most popular choice. Though it's somewhat overkill for small applications, the documentation is excellent, and there are tons of books and tutorials available. For something more lightweight, try Flask.

For desktop apps, take a look at Camelot and Dabo.
 
Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...

Similar threads

  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 15 ·
Replies
15
Views
3K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 6 ·
Replies
6
Views
5K
Replies
7
Views
2K
Replies
2
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 10 ·
Replies
10
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K