[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-30 Thread Dominique Devienne
On Thu, Apr 30, 2015 at 2:52 AM, James K. Lowden wrote: > On Tue, 28 Apr 2015 09:24:56 +0200 Dominique Devienne > wrote: > > On Tue, Apr 28, 2015 at 4:16 AM, James K. Lowden < > jklowden at schemamania.org> wrote: > > > A major hurdle is the memory model: because array-programming > > >

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-29 Thread James K. Lowden
On Tue, 28 Apr 2015 09:24:56 +0200 Dominique Devienne wrote: > On Tue, Apr 28, 2015 at 4:16 AM, James K. Lowden > wrote: > > > A major hurdle is the memory model: because array-programming > > libraries normally mandate the data be in contiguous memory, > > there's a cost to converting to/from

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-28 Thread Dominique Devienne
On Tue, Apr 28, 2015 at 4:16 AM, James K. Lowden wrote: > A major hurdle is the > memory model: because array-programming libraries normally mandate the > data be in contiguous memory, there's a cost to converting to/from the > DBMS's B+ tree. The more array-like the physical storage of the

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread James K. Lowden
On Mon, 27 Apr 2015 16:35:11 -0400 Jim Callahan wrote: > So, the application of arrays and complex numbers go far beyond the > one question posed to this list with arrays of integers and reals > being far more common than arrays of complex numbers. > > Complex numbers are included as types in

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Simon Slavin
On 27 Apr 2015, at 9:35pm, Jim Callahan wrote: > But, even so, I would expect that users of complex numbers would be an > extremely small subset of data base users (less than 5%? or even less than > 1%?). Right. There's no way to know this for sure, but I suspect that of the literally

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Stefan Keller
On Behalf Of Jim Callahan >> Sent: Sunday, April 26, 2015 9:56 PM >> To: General Discussion of SQLite Database >> Subject: [sqlite] SQLite and Scientific Computing: Arrays and Complex >> Numbers >> >> The original thread asking about an array of complex numbers

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Drago, William @ CSG - NARDA-MITEQ
riginal Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > users-bounces at mailinglists.sqlite.org] On Behalf Of Jim Callahan > Sent: Sunday, April 26, 2015 9:56 PM > To: General Discussion of SQLite Database > Subject: [sqlite] SQLite and Scient

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Jim Callahan
arda-MITEQ > 435 Moreland Road > Hauppauge, NY 11788 > 631-272-5947 / William.Drago at L-3COM.com > > > > > -Original Message- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jim Callahan > &

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Jim Callahan
Oops, left out two links, the Rasdaman 10.0 quote is from the Rasdaman roadmap. http://rasdaman.org/roadmap and the quote about the ISO designation is from the Array SQL Rasdaman page: http://rasdaman.com/ArraySQL/ But, the conclusion remains the same: So, Multi-dimensional arrays may be coming

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Jim Callahan
Two more thoughts (and I have to get back to work!): 1. Rasdaman 2. ISO SQL/MDA (multi-dimensional arrays) In June 2014, British tech website "The Register" reported, "the ISO SQL working group agreed to start work on SQL/MDA (multi-dimensional array) specs. ...A separate effort, called

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-27 Thread Jim Callahan
Two more thoughts (and you'll stay with SQLite): 1. SciQL -> MonetDB -> sockets -> embedding R in MonetDB (ala PostgresQL) http://en.wikipedia.org/wiki/MonetDB "there was one issue that we could not solve: Processing data from the database with R required transferring the relevant data over the

[sqlite] SQLite and Scientific Computing: Arrays and Complex Numbers

2015-04-26 Thread Jim Callahan
The original thread asking about an array of complex numbers has been marked as "solved." The requester has decided to serialize the complex numbers and store them in a blob. Earlier, Keith had suggested storing complex numbers as a pair of real numbers and a separate box table. I extended Keith's