[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

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

t; > On Saturday 24 January 2015 03:15 PM, Stefan Keller wrote: >> >> I think it's time for a serious simple benchmark with sqlite and say >> PostgreSQL. >> PostgeSQL also had performance problems time ago but this has been >> resolved. >> Can you describe th

Re: [sqlite] sqlite3 performance on select count very slow for 16 GB file

Hi, Relying on sequence will not work (and is a wrong hack) since the use case includes deleting rows explicitly. I think it's time for a serious simple benchmark with sqlite and say PostgreSQL. PostgeSQL also had performance problems time ago but this has been resolved. Can you describe the

Re: [sqlite] Whish List for 2015

Hi, Adding JSON to SQLite (like in PostgreSQL) ultimately needs a JavaScript parser - and that seems to be against the goal of SQLite being slim. But what about adding a data type "hash table", i.e. set of keyvalue pairs (also known as hstore, dictionary or associative array)? Would'nt this

Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

alue string syntax and converts it into rows (pivot)?? -S. 2014-03-18 19:22 GMT+01:00 Petite Abeille <petite.abei...@gmail.com>: > > On Mar 18, 2014, at 2:46 AM, Stefan Keller <sfkel...@gmail.com> wrote: > >> Any suggestions on how to query this most effi

[sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

Hi, I have a column which contains a string structure taken from the PostgreSQL HSTORE key-value-pairs type. This is an example of one column value: "operator"=>"police","name"=>"Zurich","some_key"=>"some_value" Any suggestions on how to query this most efficiently (like [select value from

Re: [sqlite] Is SQLite a DBMS?

Dear Keith > I think your definition is a little off. (...) Nice thoughts about the general term of a system - but unfortunately not state-of-the-art. If you don't trust in G* pls. read the first chapters of any university course or well-known or books about Database Systems, like the book

Re: [sqlite] Is SQLite a DBMS?

I understand now. To me (as a university teacher :->), here exists no single common definition what a (R)DBMS is! That comes close: A database management system (DBMS) is software that controls the storage, organization, and retrieval of data. A DBMS provides various functions like data

Re: [sqlite] Is SQLite a DBMS?

Hi, Wikipedia answers with yes and why (= because it's ACID and SQL compliant) within the first three sentences! http://en.wikipedia.org/wiki/SQLite Yours, S. 2013/9/1 kimtiago > Hi, > > I need to know if SQLite is a DBMS and why. > > Please its urgent. > > > > -- > View

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

Hi Régis I'd wish to give you a solution but I'm sorry to have new news about that issue. I'd be happy if there are any SQlite devs around to give you a solution in order to make this database more usable (an more SQL compatible). Yours, Stefan 2013/6/11 regish

Re: [sqlite] 'integer'

Again a disclaimer: I use SQlite often e.g. for continuous testing and in Desktop Apps. - and I like it as it is except for it's homepage declaration and (more formally) for it kind of weak typing (meaning 'weak' compared to the information schema). Weak typing in databases assigns the house

Re: [sqlite] 'integer'

all data to file. And > please explain how "data container" differs from "database". In some > sense all databases are "data containers" because they contain data. > > > Pavel > > > On Sun, Apr 17, 2011 at 8:12 AM, Stefan Keller <s

Re: [sqlite] 'integer'

Michael and Jay are right about the subtleties on how SQlite interprets what is a data type, a primary key and a database schema and it's ACID implementation in general. To me, the main reason - and remedy - of this FAQ is that SQlite should'nt be called a "SQL database" (as e.g. touted on its

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

is solution is better than just relying on > declared type of columns - more straightforward and more > understandable by somebody coming to your project in the future. > > > Pavel > > On Thu, May 6, 2010 at 7:11 PM, Stefan Keller <sfkel...@gmail.com> wrote: >> Tha

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

Thank you, Tom and Dan, for your constructive answers. To Pavel: My application reads the column types out in order to pretty print the values - as mentioned by Tom - but also to generate a dialog for entering new data (of course combined with INSTEAD OF TRIGGERs). I understand that it's

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

ement that work on statically typed databases should work the same way in SQLite."). => Time for a ticket? -S. 2010/5/3 Stefan Keller <sfkel...@gmail.com>: > Unfortunately the application which reads from this view needs that > all columns are typed - even if the values types deviat

Re: [sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

(salary + 10 AS INTEGER) "salaryplus10" FROM mytable; To me it seems like an inconsistency (or bug) when TABLES allow declaration of types and VIEWS only eventually. -S. 2010/5/3 Simon Slavin <slav...@bigfraud.org>: > > On 3 May 2010, at 6:14pm, Stefan Keller wrote: > >>

[sqlite] Computed columns in VIEWs return NULL but should be able to be typed! Any ideas?

I have a question regarding VIEWs in SQLite: It looks like if SQLite simply copies the column type from the original table into the corresponding view column. And I know SQLite implements some 'loose column typing'. That's ok so far. But in SQLite if a view column comes from a function result