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. John > > 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
smime.p7s
Description: S/MIME cryptographic signature
____________________ Racket Users list: http://lists.racket-lang.org/users
