About Sarah
Articles with the tag: SQLAlchemy
Script to put your music in a database
Fri, 28 Aug 2009 12:24PM
I made this script a while back now to populate a database with all the music on my computer (so excuse any poor Python!). It assumes you are on Windows and have all your music in one folder, arranged by artist with sub folder albums with songs in them. It also assumes you'll use PostgreSQL, but it's trivial to change this to mySQL or even SQLite which comes with Python2.5 or higher. You can tell it to ignore certain folders by adding to the ignorables set. It will automatically grab any album art it finds and try and get the genre, track number and composer etc from MP3 meta data (I couldn't find a way of doing any other kind of music type).
PostgreSQL full text search and SQLAlchemy
Sun, 16 Aug 2009 02:37PM
You may have noticed I have added a search bar at the top of the website. Here is how to make use of PostgreSQL's full text search facility with SQLAlchemy, a Python SQL Toolkit and Object Relational Mapper.
Previous blog entries
Blog categories
- Forensics & science (7)
- Homemade arts & crafts (11)
- Rabbits (8)
- Programming (6)
- Miscellaneous (25)
- Recipes (5)
- Reviews (14)
- Digital Forensics & Malware (42)
- Trips & Visits (16)
- Cyber Security & Threat Management (12)
- IT & Computers (7)
- HCI & Design (6)
Blog tags
data privacy Michelin restaurant papier mache Mini forensics challenge crime scene answers RIPA case management Internet Explorer Sainsbury's unicode steganography Demand Five Malware data flow DNA Windows Vista favourites Mesh computers Megalosaurus Moo Deterrence Theory web history Gullane sophisticated cyber attack Shellbags quantitative file headers guidelines crime self deletion Routine Activities Theory cyber threat models CV facts heatmap favicon ISACA magic Woodilee Cyber Academy foodies New Scientist rock confirmation bias naughty bunny Google Chrome birthday moving flat UK Cyber Security Strategy risotto QR codes risk malware text hacking Nybble File tunnelling coasters
