Jason Nerida

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...

buildingquerying-a-sample-database

> 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 

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

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
www.cassiel.com
www.myspace.com/cassieldotcom
www.loadbang.net


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

> 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...

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

> 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...


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 :-) )

On Jun 20, 2007, at 11:48 AM, Nick Rothwell 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 

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 :-) )

>
> 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
> www.cassiel.com
> www.myspace.com/cassieldotcom
> www.loadbang.net
>
>
>


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 

> 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.)

>> 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 

> 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 

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. ;-) 

i sqlite3-dev 3.2.8-1001 Embedded SQL database (include 

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 ;-)

>> 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 ;-)

Building/Querying a Sample Database