Re: [sqlite] probably recursive?

On 2018/05/04 1:54 AM, Cezary H. Noweta wrote: Hello, At the beginning I would like to agree with that the problem is iterative rather then recursive one. However LOL, that might be the hackiest query I ever seen, but kudos mate, that's bloody marvellous! I corrected the table to not

Re: [sqlite] probably recursive?

Hello, At the beginning I would like to agree with that the problem is iterative rather then recursive one. However, On 2018-05-01 14:15, R Smith wrote: That depends on what you mean by "Could this be achieved in SQLite?". There is no query (in any SQL engine) that can depend on a sub-query

Re: [sqlite] not build with SQLITE_OMIT_VIRTUALTABLE

On 3 May 2018 at 14:07, Michele Dionisio wrote: > Hi all, > > last sqlite 3230100 does not build with -DSQLITE_OMIT_VIRTUALTABLE and the > error is: > > | sqlite3-sqlite3.o: In function `sqlite3RunParser': > | sqlite3.c:(.text+0x6e644): undefined reference to

[sqlite] not build with SQLITE_OMIT_VIRTUALTABLE

Hi all, last sqlite 3230100 does not build with -DSQLITE_OMIT_VIRTUALTABLE and the error is: | sqlite3-sqlite3.o: In function `sqlite3RunParser': | sqlite3.c:(.text+0x6e644): undefined reference to `sqlite3VtabFinishParse' | sqlite3.c:(.text+0x6e654): undefined reference to

Re: [sqlite] How to Handle BigInt

> Also note that if you store your numbers as strings, indexes on those > values will order them as strings. In other words, searching and sorting > will work incorrectly. > It should be possible to get your numbers from a Java numeric variable to > a database numeric value without passing them

Re: [sqlite] How to Handle BigInt

As quick insight I gleaned from this list sometime ago: if you only need to be able to search and sort, the blobs can be used. If you can live with a fixed size (f.i. 256bits), then just use the fixed-size big-endian representation as blob content. For variable-length big integers, encode them

Re: [sqlite] How to Handle BigInt

On 2 May 2018, at 6:08pm, Thomas Kurz wrote: > Are there any plans for supporting a true BigInt/HugeInt data type (i.e. > without any length restriction) in the near future? The largest integer storable as an integer is current 2^63-1, which is the value

Re: [sqlite] EF 6 provider rejecting composite primary keys

I first posted this in ErikEJ's Github repo and he referred me to system.data.sqlite.org. After I migrated a working SQL server database using SqlCeToolbox to Sqlite as per toolbox instructions I tried to add an edmx model of the new Sqlite db file to my VS project and I found that all my foreign

Re: [sqlite] How to Handle BigInt

Are there any plans for supporting a true BigInt/HugeInt data type (i.e. without any length restriction) in the near future? - Original Message - From: Simon Slavin To: SQLite mailing list Sent: Wednesday, May 2, 2018,

Re: [sqlite] Configuring csv extension to use '; ' as column delimiter instead of ',' ?

On 1 May 2018, at 15:20, Simon Slavin wrote: > Seems like the best way to solve this would be to write a converter for > Windows which converts SCSV to CSV. Then it could be used by all Excel users > instead of just SQLite users. As the heavy lifting of implementing Python on Windows has been

[sqlite] When trying to compile with gcc is giving kind of infinit loop

Hello ! I'm experiencing a kind of compiler infinte loop when trying to compile sha1 extension (it seems like the macros problem for shathree). The compiler seems to enter an infinite loop. If I avoid using "asm" it compiles fine. #if __GNUC__ && (defined(__i386__) || defined(__x86_64__))