Looking for advice

Chris Angelico rosuav at gmail.com
Fri Apr 20 15:06:56 EDT 2018


On Sat, Apr 21, 2018 at 3:28 AM, 20/20 Lab <lab at 2020fresno.com> wrote:
> Going to write my first python program that uses a database. Going to store
> 50-100 rows with 5-10 columns.  Which database / module would you advise me
> to use?  It's basically going to be processing order status emails for the
> sales staff.  Producing a webpage (2-3 times daily, as updates arrive) that
> has the sales staff orders and status on it.   I'm thinking just a simple
> sqlite, but dont want to waste time going down the wrong path.
>

Use SQLite, but spend an hour or so reading about PostgreSQL, so you
have some idea of what it can do. As your requirements grow, you'll
eventually outgrow SQLite, and the most obvious next step is Postgres;
you'll do well to at least have a nodding familiarity with it, so you
can decide when to move up.

Also, since you're asking for advice: I advise you to write good
subject lines on your posts. It'll make your questions easier to find.
:) Something like: "Selecting database for small Python app - looking
for recommendations".

ChrisA


More information about the Python-list mailing list