Re: [sqlite] [patch] for test/backup2.test

Hi All, On 07/06/2017 10:51 PM, Pavel Volkov wrote: Hello. Please, make test 'test/backup2.test' more compatible with FreeBSD. This is patch for it: --- test/backup2.test.orig 2017-07-07 04:59:34 UTC +++ test/backup2.test @@ -143,7 +143,7 @@ do_test backup2-9 { # if

Re: [sqlite] Example/recipe for truncating fp numbers

Though I would use: trunc(value * pow(10, places)) / pow(10, places) so that all the operations are performed using full floating point, but then I have the whole math library loaded into SQLite3 ... I just added an override for the math library trunc function that takes two arguments so

Re: [sqlite] Example/recipe for truncating fp numbers

On 7/10/17, Jean-Marie CUAZ wrote: > Hello, > > Below is a recipe on a "best effort" basis, to truncate fp numbers on > the right side of the decimal separator with SQLite. I don't understand how this is different from "round(N,3)"? What are you trying to do to the fp number N

Re: [sqlite] Example/recipe for truncating fp numbers

Why not just use: cast(value * 1000 as integer) / 1000.0 > Hello, > > Below is a recipe on a "best effort" basis, to truncate fp numbers on > the right side of the decimal separator with SQLite. > > It is not intended to correct any fp numbers processing, but only to > discard, without any

Re: [sqlite] Example/recipe for truncating fp numbers

On 10 Jul 2017, at 6:17pm, Jean-Marie CUAZ wrote: > Improvements/comments welcome I would suggest you try an equivalent function, starting by turning the number into a string and looking for the decimal point in it. This may or may not work better, but a second way of

[sqlite] Example/recipe for truncating fp numbers

Hello, Below is a recipe on a "best effort" basis, to truncate fp numbers on the right side of the decimal separator with SQLite. It is not intended to correct any fp numbers processing, but only to discard, without any rounding, unwanted fractional digits. The following is directed to

Re: [sqlite] Documentation improvement recommendations

Here's a couple more. On this page: https://www.sqlite.org/src/doc/trunk/README.md describes the LALR(1) grammer should be: describes the LALR(1) grammar Each has a suscinct should be: Each has a succinct - On this page: https://www.sqlite.org/dbstat.html The the DBSTAT virtual

[sqlite] Documentation improvement recommendations

Hi All, Here's a list of some documentation improvements. - On this page: https://www.sqlite.org/rbu.html an RBU Vaccum is should be: an RBU Vacuum is What about this change. Preparing An RBU Update File To: Preparing an RBU Update File Too many words: it may be be more

Re: [sqlite] SQLite Port/ODBC Driver Question

Hello Vishal, As far as I know the Java version of the Werner javasqlite driver does not use a port and the odbc may not also. I have use this Java driver, but a more current active driver project for Java is at GitHub: https://github.com/xerial/sqlite-jdbc/ As indicated SQLite is local file

Re: [sqlite] VALUES clause quirk or bug?

(New changes in testing look good, so sorry if this is reopening this) If you need column names with a VALUES table, why not just kick the VALUES to the front in a CTE where you can name the fields? Then you don't need a temp table or temp view that you need to remember to drop, and since you

Re: [sqlite] Query on bug fix for ticket 7ffd1ca1d2ad4ec

On 10 Jul 2017, at 9:17am, mohan_gn wrote: > Since our product is already in field with older > version of SQLite, we want to know this bug's impact. We use simple queries > like 'select * from abc where col1=123 and col2=456'. We don't use any > JOINs, VIEWs, nested

Re: [sqlite] SQLite Port/ODBC Driver Question

On 7/10/17, Rob Willett wrote: > > A good rule of thumb is to avoid using SQLite in situations where the > same database will be accessed directly (without an intervening > application server) and simultaneously from many computers over a > network." > Another way

Re: [sqlite] SQLite Port/ODBC Driver Question

It depends on what you mean remotely. By itself SQLite doesn't have any networking library built in. It's an embedded database. You can put application wrappers around the database, I believe that wrappers exist to make SQLIte into a true client/server but thats additional code. Also there

Re: [sqlite] SQLite Port/ODBC Driver Question

Rob, On Mon, Jul 10, 2017 at 7:06 AM, Rob Willett wrote: > Vishal, > > SQLite isn't a traditional client/server relational database, therefore > there isn't a port to open up. It runs on a local machine. I believe SQLite can successfully be run remotely. Thank

Re: [sqlite] SQLite Port/ODBC Driver Question

Vishal, SQLite isn't a traditional client/server relational database, therefore there isn't a port to open up. It runs on a local machine. Now there are wrappers around SQLite to extend it, I assume this ODBC driver is one of them. I suspect people here *may* know the answer regarding any

[sqlite] SQLite Port/ODBC Driver Question

Hi, Am trying to open a firewall to the machine having sqlite database. Does the SQLite database use a specific port number ? If not, then does the ODBC connection to SQLite using ODBC driver use a port ? Any help will be greatly appreciated. SQLite ODBC Driver:

Re: [sqlite] Query on bug fix for ticket 7ffd1ca1d2ad4ec

Thank you for the reply. I know it has been fixed. Since our product is already in field with older version of SQLite, we want to know this bug's impact. We use simple queries like 'select * from abc where col1=123 and col2=456'. We don't use any JOINs, VIEWs, nested queries. The tables we use do

Re: [sqlite] Query on bug fix for ticket 7ffd1ca1d2ad4ec

On 10 Jul 2017, at 7:15am, mohan_gn wrote: > Could anyone please answer above query? Do you mean this bug ? If so, the bug was fixed in January. Please download the latest version of SQLite and see whether you can

Re: [sqlite] Query on bug fix for ticket 7ffd1ca1d2ad4ec

Hi All, Could anyone please answer above query? Thank you very much, Mohan -- View this message in context: http://sqlite.1065341.n5.nabble.com/Query-on-bug-fix-for-ticket-7ffd1ca1d2ad4ec-tp96175p96575.html Sent from the SQLite mailing list archive at Nabble.com.