On 09/06/2012 04:09 PM, John Clements wrote:
On Sep 6, 2012, at 1:06 PM, Michael Wilber wrote:
CSV files? Do you mean importing a CSV file into a table?
Take a look at http://dev.mysql.com/doc/refman/5.1/en/load-data.html,
the "LOAD DATA INFILE" command, which (iirc) takes a CSV file and
imports it into a table, one shot.
Well, that's half of what I want; really, I'd like a way to use the csv as the
backing store for the table, so that I can always paw through the CSV if need
be.
You might be able to find an ODBC driver that provides a database
front-end for CSV files. (I believe Windows comes with one, but I don't
know about other platforms.) Google "ODBC CSV" and see if any of the
hits are useful.
Ryan
John Clements <[email protected]> writes:
On Sep 6, 2012, at 11:08 AM, Jay McCarthy wrote:
On Thu, Sep 6, 2012 at 11:42 AM, John Clements
<[email protected]> wrote:
I was looking today for a way to make relational algebra queries on lists, and your
"fra" package was close enough to try out. I have a number of questions, though:
1) Is this package superseded by any of your more recent stuff? It looks like
m8b and grade-samurai use something file-system based instead?
I don't use it for anything. The idea was to write a functional
database so that I could use it from FrTime and get "live" updating
queries where when the database time-varying value changes the answers
to old queries are automatically updated to. It was mainly just a demo
to get that demo working. I never used it anything real.
…aaaand, bam! I ran into the limits. It looks like joins on relations with
thousands of tuples don't take advantage of the possible orderings of keys, so
I appear to be getting n^2 explosion when doing joins.
Ryan, is there some way to use your db engine with files that are CSVs or
s-expressions? I took a quick look at the db docs, and it looks like what I'm
really asking is whether MySQL or PostgresQL have good support for using CSV
files. Any advice from database people?
John
____________________
Racket Users list:
http://lists.racket-lang.org/users
____________________
Racket Users list:
http://lists.racket-lang.org/users
