![]() The highly nested nature of the database means Excel isn't suitable, and my brief look at SQL tells me that it would quickly become a mess of tables. ![]() Some playlists are not in any country folder e.g. For example, if I go on holiday to New Zealand and add a new friend, then they belong in the New Zealand list, not the Taiwan list, even though the date added is during my time living in Taiwan. ![]() I can use Smart Playlists to sort by the year when I added friends, but I want to manually manage some playlists as well. The KGCC and KTL playlists are inside the Taiwan folder. For example, my friend David is in the lists: Taiwan, Christians, Health & Medicine, KGCC Church, KTL Christian student group. The nested structure is really important to me. My Facebook friends database is small by comparison (under 6000), but if I want to include all their Liked Pages, the database size increases to 223,783. What size is the big-ish data that you're talking about? iTunes slows down noticeably over 30k songs. * Sync = Compare last-updated fields between backup db and current db, then using developer API to update your sync service. * Playlists = A second table that references primary keys of individual song records. * Tags = A second table, filled with tags, that you query via JOIN. Integrating it isn't an easy thing.Īs a way to explain how simple most of this is, I'll explain it in terms of SQL: AS doesn't get much love anymore, even from Apple. Sync with what? And how does that thing officially support extensions? Or what workarounds are currently used instead? Probably a weekend to get you 3/4, and then. When it's done, or rather when the process for mp123 stops, so you can stop a song playing, it changes play? back to 'n'.īut honestly, you'd do a lot better just building it as a GUI app from scratch.Įasiest would be Python, which comes with Tk for graphics, and SQLite for database. You click KickASSSongILike, and type y in the play box.Ī Python script, called by watch watching the db, sees the change and uses something like mp123 to play the file. ![]() So if you had something like watch running on a folder, you can trigger a script as soon as that happens. (Amarok runs on Linux, Windows and macOS).įor what you're using it for, I'd probably using SQLite, and a mix of DB Browser for SQLite, which is kinda like Excel for SQL.ĭB Browser can also export records to file. Well of your essential features, the only one lacking in Amarok would be AppleScript, though you can still write scripts for Amarok in QTScript, which is fairly similar to JavaScript. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |