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.
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
