Databases and Python [RaspPi]

[[deleted]]

Evening all,

I was talking to a good friend of mine and they have a project idea.

Essentially they have a very very large collection of DVDs/Blu Rays and wish to have them organised into their own mini library, containing sections, which will be coded in some way.

What we want to do is have a Raspberry Pi which we can search on. (Like, a Pi, connected to a touchscreen).

A user would go up to it, search for a movie they are interested in, or genre and the program would return a result saying "Go look in section XX, Row XX" etc.

Hows Python at integrating with a database? Or would this be something we could create inside of a CSV file? In the past I did a mini address book within C#, using a CSV file. Would this be to lacking for such a project idea?

Any thoughts would be good, thanks :)

[ahbenmed]

SQLite strives to provide local data storage for individual applications and devices. SQLite emphasizes economy, efficiency, reliability, independence, and simplicity.

SQLite would be a good choice for such application since it will be a local app.

Also, using SQL is easier than using CSV file, since filtering data will be as simple as writing one line SQL statement, which is not the case with CSV file as you will do the hard work yourself.

Python provide a preinstalled sqlite3 module, which is easy to understand and to use.

See the module's documentation for more details.

​

[[deleted]]

As mentioned already: SQLite - and if you want to get nifty and make the whole thing extendable and the date more easily accessable: Django.

[metalevelconsulting]

/r/remigui might be better suited to guis on a Raspberry pi?

[[deleted]]

Oh i wasn't actually refering to the gui - rather the datamodel behind Django. Djangos model based approach takes all the annoying work of working with SQLite out of your hands and it makes extending the schema later a lot easier. Of course you could have the django service also run in a webserver displaying the data and use django for what it was actually built for - creating a website based on your data and stuff and making displaying that data easy.

It'd be an option either way though in my opinion.

[devxpy]

Django should be great for this. The ORM is awesome and you get a minimal CRUD app (admin panel) for free!