Would Python be a good langue to write this program in?

[MikeLG]

Hi all,

I'm new to Python, but I do have mild experience coding in other languages. (Mainly Java.) I'm looking to build the following program:

A database collection of audio files (sound effects.) I want to be able to tag my files. For example: Explosion, Fire, War -- might be the tags on one file. The point of the application is to make it easy to search through a large amount of files. Beyond that, the only other thing the application would need to do is play audio files in a simple media player.

My concern is search time - I have over 200,000+ files. If I code in Python, would this be an issue?

Thanks for your patience in dealing with a beginner. Look forward to any advice you can give!

Mike

[gruntfutuk]

Python will be absolutely fine for such a small database, and probably quicker and easier to develop in than Java.

---

Here's one of many lists of a number of well known sites that ran for years on Python (and mostly still do):

https://www.shuup.com/en/blog/25-of-the-...-websites/

[nilamo]

200k+ rows in a database, plus a few tags, is a very small database.  Python would do perfectly well for a graphical interface to such a database, and if you use sqlite, you won't even need any external packages (sqlite and tkinter are bundled with every python distribution).  Playing audio might require a little more work, but you mentioned using an external program for that, and python plays nice when it comes to communicating with other processes.

[MikeLG]

Thanks guys, good to know!

I overestimated how bad search times would be with the amount of files I have, :)

Curious, at what size would a database be too large for Python to handle?

[nilamo]

Well, the database is unrelated to python, so as long as you aren't actually displaying all of it at once (which wouldn't be a good idea in any language), there isn't a max size.  Sqlite is written in C, if that matters, though.