Building/Querying a Sample Database

Jun 17, 2007 at 11:13pm

Building/Querying a Sample Database

Hello,

Is it possible to query data from an XML file or MySQL database? I would like to randomly select samples by category to load them into buffer~ objects without using the opendialog. If I could export DB info from Kontakt 2 as an XML file or save it somehow that would be ideal, as Kontakt 2 has a DB of my sample heirarchy. Any ideas…

Thanks,

Jason

#32503
Jun 20, 2007 at 9:48am

On 18 Jun 2007, at 00:13, Jason wrote:

> Is it possible to query data from an XML file or MySQL database?

I’ve written some DB access stuff in MXJ – it supports MySQL. More
info at:

http://www.loadbang.net/space/Software/net.loadbang-SQL

Nick Rothwell / Cassiel.com Limited
http://www.cassiel.com
http://www.myspace.com/cassieldotcom
http://www.loadbang.net

#107052
Jun 20, 2007 at 10:05am

check out my [detox] external for simple and straightforward xml
parsing.

http://www.jasch.ch/dl

hth

/*j

> Is it possible to query data from an XML file or MySQL database? I
> would like to randomly select samples by category to load them into
> buffer~ objects without using the opendialog. If I could export DB
> info from Kontakt 2 as an XML file or save it somehow that would be
> ideal, as Kontakt 2 has a DB of my sample heirarchy. Any ideas…

#107053
Jun 28, 2007 at 9:56pm

Just curious, how does HSQLDB perform compared to SQLite?

I used to use [mysql], but I haven’t been able to find a UB version
since I switched to Intel. I’d far prefer to use something standard
like SQLite or MySQL (so it’s a good thing you support MySQL :-) )

Cheers

Nik

On Jun 20, 2007, at 11:48 AM, Nick Rothwell wrote:

>
> On 18 Jun 2007, at 00:13, Jason wrote:
>
>> Is it possible to query data from an XML file or MySQL database?
>
> I’ve written some DB access stuff in MXJ – it supports MySQL. More
> info at:
>
> http://www.loadbang.net/space/Software/net.loadbang-SQL
>
>
> Nick Rothwell / Cassiel.com Limited
> http://www.cassiel.com
> http://www.myspace.com/cassieldotcom
> http://www.loadbang.net
>
>
>

#107054
Jun 30, 2007 at 11:07am

On 28 Jun 2007, at 22:56, Niklas Saers wrote:

> I used to use [mysql], but I haven’t been able to find a UB version
> since I switched to Intel. I’d far prefer to use something standard
> like SQLite or MySQL (so it’s a good thing you support MySQL :-) )

SQlite looks interesting, but I’d need a compelling reason to get in
front of a Windows box for the native version. (I find Xcode on the
Mac objectionable enough… although I might have a bash at SQlite
for the Mac at some stage.)

– N.

Nick Rothwell / Cassiel.com Limited
http://www.cassiel.com
http://www.myspace.com/cassieldotcom
http://www.loadbang.net

#107055
Jul 1, 2007 at 7:50pm

Hi,

>> I used to use [mysql], but I haven’t been able to find a UB
>> version since I switched to Intel. I’d far prefer to use something
>> standard like SQLite or MySQL (so it’s a good thing you support
>> MySQL :-) )
> SQlite looks interesting, but I’d need a compelling reason to get
> in front of a Windows box for the native version. (I find Xcode on
> the Mac objectionable enough… although I might have a bash at
> SQlite for the Mac at some stage.)

In that case I don’t think we’re speaking the same language. :-)
SQLite is open source, and I’ve never used it on a windows box since
I haven’t had a windows box since development on it was started. ;-)
It’s right there in the Fink repository:

i sqlite3-dev 3.2.8-1001 Embedded SQL database (include
files and linkable libraries)

A quick google and I found http://www.ch-werner.de/javasqlite/ which
is a Java wrapper with a BSD style license. So for making something
that can be distributed I’d probably choose it, for my own stuff I’m
probably just sticking to MySQL out of habit ;-)

Cheers

Nik

#107056

You must be logged in to reply to this topic.