Something like this? http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html
That seems somewhat unsupported though... John Clements <[email protected]> writes: > 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 ____________________ Racket Users list: http://lists.racket-lang.org/users
