Re: [Mixxx-devel] Proper way to query DB (re: duplicate detection)
Hello. I understand you want to access it programmatically. I've never done that, but I know you can use SQLite Database Browser (http://sqlitebrowser.org/) to do so interactively and it's just a matter of pointing it to the DB file. So I imagine you could just follow standard examples from the SQLite docs to create an application to access it. (Mixxx just uses Qt's DB abstraction layers so we have the option of changing the DB back-end in the future if it's ever warranted. Otherwise there's nothing special.) Sincerely, Sean M. Pappalardo "D.J. Pegasus" Mixxx Developer - Controller Specialist smime.p7s Description: S/MIME Cryptographic Signature -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot___ Get Mixxx, the #1 Free MP3 DJ Mixing software Today http://mixxx.org Mixxx-devel mailing list Mixxx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mixxx-devel
Re: [Mixxx-devel] Proper way to query DB (re: duplicate detection)
On 11/18/17 13:05, Conner Phillips wrote: I opened a thread on launchpad about this but I'm having trouble loading the website atm. Anyways, I want to whip up a naive prototype and I'm a little lost on the standard way to query the DB. I was hoping to find a native SQLite solution but I wasn't happy with the possibilities. However, I'm at a bit of a loss where to start connection to the database in the correct way. There are a lot of layers of abstraction that I can't sort out just sifting through the source code. What headers do I need to include at a minimum to create a simple query? I can so feel your pain, when I started on the branch I had the same feeling. In regards to duplicate detection, as a starting point I want to query title, artist, and duration of each track into a list of lists and perform some simple comparison of all unique permutations of the tracks. I have tested this in Python and it works reasonably well for a basic brute force approach. I'm already working on a branch for deduplication. But I'm not using artist/title pairs, but calculate a fingerprint and compare those. On the other hand you don't want to have tracks missing in a Compilation just because the same song exists somewhere else. Then there is also the case where different qualities exist etc. I still have not ironed out all the corner cases so I have not worked on this branch for a month but I will definitely resurrect it soonish. kind regards poelzi -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Get Mixxx, the #1 Free MP3 DJ Mixing software Today http://mixxx.org Mixxx-devel mailing list Mixxx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mixxx-devel
[Mixxx-devel] Proper way to query DB (re: duplicate detection)
Hi all, I opened a thread on launchpad about this but I'm having trouble loading the website atm. Anyways, I want to whip up a naive prototype and I'm a little lost on the standard way to query the DB. I was hoping to find a native SQLite solution but I wasn't happy with the possibilities. However, I'm at a bit of a loss where to start connection to the database in the correct way. There are a lot of layers of abstraction that I can't sort out just sifting through the source code. What headers do I need to include at a minimum to create a simple query? In regards to duplicate detection, as a starting point I want to query title, artist, and duration of each track into a list of lists and perform some simple comparison of all unique permutations of the tracks. I have tested this in Python and it works reasonably well for a basic brute force approach. Best, Conner -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Get Mixxx, the #1 Free MP3 DJ Mixing software Today http://mixxx.org Mixxx-devel mailing list Mixxx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mixxx-devel
