[sqlite] DB Browser for SQLite 3.6.0 released

Quick FYI. We've just released DB Browser for SQLite, version 3.6.0. Win32/64 and OSX binaries are available right away. Ubuntu PPA and FreeBSD port should be available within a day or two. :) https://github.com/sqlitebrowser/sqlitebrowser/releases/tag/v3.6.0 Regards and best wishes,

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

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

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

As of SQL:2003, arrays are standard SQL types. Examples of standard syntax: BIGINT ARRAY BIGINT ARRAY[100] BIGINT ARRAY[100] ARRAY[200] It's fully implemented e.g. in PostgreSQL... -S. 2015-04-27 18:48 GMT+02:00 Drago, William @ CSG - NARDA-MITEQ : > All, > > I've been enjoying this

[sqlite] Regarding testing

On Mon, 27 Apr 2015 17:51:43 +0100, Drago, William @ CSG - NARDA-MITEQ wrote: > > Never saw this before. LMAO. Will put it too good use... +1 Ossum!

[sqlite] Regarding testing

Yeah I read that link previously but how do i get all those test cases? On Mon, Apr 27, 2015 at 5:27 PM, Simon Slavin wrote: > > On 27 Apr 2015, at 12:54pm, Sairam Gaddam wrote: > > > How SQLite is tested and can I get those test cases? > > < >

[sqlite] Regarding testing

How SQLite is tested and can I get those test cases?

[sqlite] Regarding testing

Never saw this before. LMAO. Will put it too good use... -- Bill Drago Senior Engineer L3 Narda-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- >

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

All, I've been enjoying this discussion and have learned a thing or two from all the suggestions. My particular problem is indeed solved. Adding a simple blob to my original table is the best solution in this case. If you think about the trace data as simply a screenshot of the analyzer

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

Arrays of data are used are used in almost every modeling application; a much smaller subset of those applications use complex numbers. As Peter Baumann has argued: "Science and engineering data often come as sensor, image, simulation, and statistics data digitized/sampled from some natural

[sqlite] Regarding testing

On Mon, 27 Apr 2015 18:06:31 +0530 Sairam Gaddam wrote: > Yeah I read that link previously but how do i get all those test > cases? You can buy the professional tests at http://www.hwaci.com/sw/sqlite/prosupport.html , Mr. Hipps company behind Sqlite. Or you can trust them or create the

[sqlite] Index causes slow queries: any thoughts?

Hi all, Sorry for the repeat of this post; I?ve not heard back from anyone, and was hoping someone might have some idea. To recap: The tables we have are: Appointment(Appointment_UUID, Appointment_TxnUUID, Appointment_StartDate, and other columns) Txn(Txn_UUID, Txn_Created, Txn_Reference

[sqlite] Regarding testing

On 27 Apr 2015, at 1:36pm, Sairam Gaddam wrote: > Yeah I read that link previously but how do i get all those test cases? Following the links from that page, some of the tests are included in the full download of the SQLite source code, which can be found near the end of the Download page

[sqlite] Regarding testing

You didn?t read the link properly. I?ll highlight the relevant sections The TCL Tests are the oldest set of tests for SQLite. They are contained in the same source tree as the SQLite core and like the SQLite core are in the public domain. The TCL tests are the primary tests used during

[sqlite] building SQLite DLL with Visual C++

I'm afraid I can't help you with that, Jay. I don't use data bindings and all that other built-in visual studio db stuff because performance is slow and it's hard to maintain. I just read from the db into a data table. From there you can do whatever you want with the data. Search on line for

[sqlite] Changing WAL mode for a transaction

On 04/27/2015 12:55 PM, Navaneeth K N wrote: > Hi Dan, > > >> On 27-Apr-2015, at 10:52 am, Dan Kennedy wrote: >> >> On 04/26/2015 07:01 PM, Navaneeth K N wrote: >>> Hello, >>> >>> My application runs the following right after opening the connection to the >>> database. >>> >>>pragma

[sqlite] Regarding testing

On 27 April 2015 at 12:54, Sairam Gaddam wrote: > How SQLite is tested and can I get those test cases? 4th entry under "Overview Documents" on http://www.sqlite.org/docs.html

[sqlite] Regarding testing

On 27 Apr 2015, at 12:54pm, Sairam Gaddam wrote: > How SQLite is tested and can I get those test cases? Simon.

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

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

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] Changing WAL mode for a transaction

On 04/26/2015 07:01 PM, Navaneeth K N wrote: > Hello, > > My application runs the following right after opening the connection to the > database. > >pragma journal_mode=wal; >pragma page_size=4096 Did executing the "PRAGMA journal_mode=wal" statement succeed? Or did it return

[sqlite] Changing WAL mode for a transaction

Hi Dan, > On 27-Apr-2015, at 10:52 am, Dan Kennedy wrote: > > On 04/26/2015 07:01 PM, Navaneeth K N wrote: >> Hello, >> >> My application runs the following right after opening the connection to the >> database. >> >> pragma journal_mode=wal; >> pragma page_size=4096 > > Did

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

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] Thoughts on storing arrays of complex numbers (Solved)

Serialization should be trivial in whatever language you happen to be using. Something along the lines of golang's encoding/gob is ideal for this. In c# there is, no doubt, very robust serialization built in and it really amounts to little more than Serialize(object) <--> Deserialize(object).

[sqlite] Index causes slow queries: any thoughts?

On 4/27/15, Hamish Symington wrote: > > In the middle of all that, after the line > CREATE INDEX idx_Appointment_SaleItemUUID ON Appointment > (Appointment_SaleItemUUID); > is some slightly odd output - that's just as it appears in the command line > output in Terminal on my Mac. What does

[sqlite] building SQLite DLL with Visual C++

Jay, I don't do VB.Net development but it should be very similar to C#.Net in Visual Studio. Try to follow these steps: 1. Add a Dataset Item to your project. I think you have done this already. Once the Dataset is created you will get a blank dataset designer, create a connection to your