[racket] "fra" status?

From: Michael Wilber (mwilber at uccs.edu)
Date: Thu Sep 6 16:20:13 EDT 2012

Something like this?
http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html

That seems somewhat unsupported though...

John Clements <clements at brinckerhoff.org> 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 <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.