Method for accessing SQL databases
- From: Magnus Bergman <magnus bergman observer net>
- To: gnome-vfs-list <gnome-vfs-list gnome org>
- Subject: Method for accessing SQL databases
- Date: Wed, 26 Jan 2005 17:00:31 +0100
I'm about to write a Gnome-VFS module for accessing SQL databases
(primary MySQL and Oracle). And I was wondering if there is some kind of
standard related to mapping a URL to an SQL query. And if I'm forced to
hack something myself I would appreciate opinions from others.
I imagine it could look something like this:
scheme://[[user[:password] ]host[:port]]/[database]?query
Or perhaps instead of query:
[table[,table...][:field[,field...][:primary_key=value]]]
There didn't seem to be anything suitable here:
http://www.iana.org/assignments/uri-schemes
But I found the following related URI schemes:
HTDB Couldn't find enough information to determine whether this is
suitable. It looks promising.
JDBC This is apparently widely used but from what I can see it only
addresses the database, and can not be used to access any
specific data.
mysql I would be stupid to use this for accessing a non-MySQL server,
even if it perhaps would work fine.
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]