 |
|
|
|
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Does anybody here know anything about ODBC?
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Invisible wrote:
> Does anybody here know anything about ODBC?
>
run away run away
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
"Invisible" <voi### [at] dev null> wrote in message
news:47612e2b$1@news.povray.org...
> Does anybody here know anything about ODBC?
>
Open Database Connectivity.
A standard API for connecting to various forms of data sources. Generally
slower than OleDB, but easier to find drivers for more esoteric systems.
Was there anything specific you wanted to know?
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Gail Shaw wrote:
> Open Database Connectivity.
>
> A standard API for connecting to various forms of data sources. Generally
> slower than OleDB, but easier to find drivers for more esoteric systems.
>
> Was there anything specific you wanted to know?
There appear to be ODBC drivers for accessing CSV files and so forth.
So does that mean I can perform arbitrary SQL queries on a CSV file?
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Tom Austin wrote:
> run away run away
So-noted.
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Invisible <voi### [at] devnull> wrote:
> Does anybody here know anything about ODBC?
>
I know a bit. There are probably others here who know more. A more specific
context would probably be helpful. Are you looking to learn more about the
subject in general? Is there a specific problem you need to solve?
A reasonably short and to the point intro can be found here:
http://www.unixodbc.org/doc/ProgrammerManual/Tutorial/
Best Regards,
Mike C.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
"Invisible" <voi### [at] devnull> wrote in message
news:476132a3$1@news.povray.org...
> There appear to be ODBC drivers for accessing CSV files and so forth.
Yup. Excel spreadsheets, xml files, assorted databases, active directory,
etc...
> So does that mean I can perform arbitrary SQL queries on a CSV file?
Probably. How complex a statement depends on the capabilities of the driver
in question. If it has a manula/help file, read it.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Gail Shaw wrote:
> "Invisible" <voi### [at] devnull> wrote in message
> news:476132a3$1@news.povray.org...
>
>> There appear to be ODBC drivers for accessing CSV files and so forth.
>
> Yup. Excel spreadsheets, xml files, assorted databases, active directory,
> etc...
>
>> So does that mean I can perform arbitrary SQL queries on a CSV file?
>
> Probably. How complex a statement depends on the capabilities of the driver
> in question. If it has a manula/help file, read it.
...right. So you're saying the type of queries I can do can vary by ODBC
driver?
I guess I was assuming that an ODBC driver is like a graphics driver -
either you have graphics or you don't. (Oh, and some of the more exotic
features might not be available, like 3D acceleration or hardware overlays.)
Basically I want to develop a program that talks to a database. I was
going to use ODBC to do this. But I don't have a database set up right
now, so I was wondering if I could test it with a simple text file until
I get round to setting up a real database. [Obviously a CSV file isn't
going to even approach the speed of a half decent database engine. But I
can test whether data goes in and data comes out.]
Alternatively, does anybody know how to configure PostgreSQL? Because I
can't get the damn thing to work properly...
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
47614210$1@news.povray.org...
> Basically I want to develop a program that talks to a database. I was
> going to use ODBC to do this. But I don't have a database set up right
> now, so I was wondering if I could test it with a simple text file until I
> get round to setting up a real database. [Obviously a CSV file isn't going
> to even approach the speed of a half decent database engine. But I can
> test whether data goes in and data comes out.]
You can do some limited database work with text files (or Excel files etc.),
but that will mostly be limited to actions that can be done without
requiring indexes, i.e. SELECT and INSERT statements rather than UPDATE and
DELETE for instance. For testing a database, you'll need a database. MS
Access will do, and MySQL takes a couple of minutes to install on a PC.
G.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
Gilles Tran wrote:
> You can do some limited database work with text files (or Excel files etc.),
> but that will mostly be limited to actions that can be done without
> requiring indexes, i.e. SELECT and INSERT statements rather than UPDATE and
> DELETE for instance. For testing a database, you'll need a database. MS
> Access will do, and MySQL takes a couple of minutes to install on a PC.
PostreSQL also takes a couple of minutes to set up. Unforuntately, I
can't make it do anything once it's installed.
MySQL isn't transactional = I'm not really interested.
Maybe I'll just use M$ Access. [Obviously that means I can only use
computers which have M$ Access.]
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
