[racket] "fra" status?

From: Ryan Culpepper (ryan at cs.utah.edu)
Date: Thu Sep 6 16:18:37 EDT 2012

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.


>> John Clements <clements at brinckerhoff.org> writes:
>>> On Sep 6, 2012, at 11:08 AM, Jay McCarthy wrote:
>>>> On Thu, Sep 6, 2012 at 11:42 AM, John Clements
>>>> <clements at brinckerhoff.org> 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

Posted on the users mailing list.