Re: [sqlite] Mailing list shutting down...

Do you have control over postfix server? If so maybe adding a policy to the account used for subscription confirmation may work. I dont have a PC available at the moment but in the case i may check. On Wed, Jun 13, 2018, 9:16 PM Chris Brody wrote: > On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp

Re: [sqlite] Mailing list shutting down...

/18, Alessandro Marzocchi wrote: > > Do you have control over postfix server? If so maybe adding a policy to > the > > account used for subscription confirmation may work. I dont have a PC > > available at the moment but in the case i may check. > > I don't see ho

[sqlite] Simple Math Question

Scott actually all base2 fractions are rapresentable as base10 fractions... 10 is divisable by 2. As for Richard try to think about this... computer does 2 base calculations as we usually do calculation in base 10. But the same would happend to us when talking about different bases.. Let's

[sqlite] Simple Math Question

in base-2, ALSO base-2 fractional numbers cannot always be represented precisely in base-10". Sorry for my error. Il 23/ott/2015 19:18, "Scott Robison" ha scritto: On Fri, Oct 23, 2015 at 10:45 AM, Alessandro Marzocchi < alessandro.marzocchi at gmail.com> wrote: > Scott...

[sqlite] Simple Math Question

Read that as "sorry i replied to wrong Scott... mine was meant to be a reply to Scott Hess". Long working days and small and keyboardless mobile devices are not helping me. Sorry again Il 23/ott/2015 19:40, "Alessandro Marzocchi" ha scritto: > Sorry, i replied to wrong

[sqlite] out of the void: xDlSym

Even in today's world there are sysems (the ones i know for sure are atmel's avr and microchip's pic, both microcontrollers with Harvard architecture) for which the equality of dara and code pointers does not stand. By the way some PICs have a 12-14 or 24 bit wide program bus to complicate the issu

Re: [sqlite] How to determine player's leaderboard rank efficiently?

1) Create data (now I use a script in python to create 10 millions rows with random data) test.py: import random import sqlite3 db=sqlite3.connect('players.db') c=db.cursor() c.execute("BEGIN") c.execute("CREATE TABLE player(name PRIMARY KEY, score REAL, rank INTEGER)") for i in range(1000):

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

You could use QString::constData which returns a pointer to internal data to the string encoded in utf16 and then change the call to sqlite3_prepare16_v2... Il 05/set/2014 06:08 "Bob Moran" ha scritto: > Erik, > Are you implying that I must copy the text returned by qPrintable(sql) to a > safe lo

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

Another solution would be moving the call to qprintable inside the prepare_v2 call: sqlite3_prepare_v2( db, qPrintable(qstr) , qstr.length()+1, &stmt, NULL) I don't know if this is your case but please note that I think this way would not handle well some Unicode strings (the ones for which utf8 a

Re: [sqlite] Create join and add unique column

Try having a look at post "How to determine player's leaderboard rank efficiently?" (24th August) this could give you idea on how to solve this problem through temporary tables. Regards Il 16/set/2014 14:14 "Paul Sanderson" ha scritto: > _rowid_ is probably the answer with a temporary table > > O

Re: [sqlite] Division accuracy

Hello, Why don't you try the same approach with 64 bit integers? You could insert consecutive items at 0x10 intervals, in this way you would be allowed about 4G items to me inserted in any order you like. You could also change the interval to change the maximum consecutive items inserte

Re: [sqlite] Division accuracy

Which language are you using? Andres ideas could give some nice solutions using blob, even without a specific arbitrary precision library. eg: Splitting data with an encoding like (In-order id) (Out-of-order id) In-order insert are encoded with an encoding that guarantees lexicografical ordering (

Re: [sqlite] Division accuracy

s might just be the best solution, ugly or not. :) > > Thanks! > Ryan > > On 2014/09/24 21:33, Alessandro Marzocchi wrote: > >> Which language are you using? Andres ideas could give some nice solutions >> using blob, even without a specific arbitrary precision library. eg

Re: [sqlite] Wanted - simple DATA editor for sqlite tables

Sqlite browser? Il giorno 24/mar/2013 20:57, ha scritto: > I'm looking for a straightforward way to edit the *data* in sqlite > tables, or at least a simple GUI for creating forms to edit sqlite > tables. > > I don't need *any* database management and I don't want it in this > application either

Re: [sqlite] Is there a way to select a precision?

If what you want is a way to store floating point numbers with a precision other than double (8 bytes) to decrease space usage or to get more precisione the answer is no. The only native data types for sqlite are integer (which can simulate bools), string, double and blob. Plus of course NULL... Se

Re: [sqlite] SELECT Count

Maybe select count(*) where ...? Alessandro Il giorno 19/ago/2013 11:38, "techi eth" ha scritto: > Hi, > > What is the way to get number of possible count matching with criteria for > SELECT? > > SELECT Colum from Table WHERE Criteria > > I tried with sqlite3_count_changes() & sqlite3_data_co

Re: [sqlite] Why are two select statements 2000 times faster than one?

What does EXPLAIN QUERY PLAN says? Il giorno 13 aprile 2012 21:04, Marc L. Allen ha scritto: > Maybe the query analyzer isn't smart enough to do two seeks in this case, > so it does a scan? > > > -Original Message- > > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > > boun.

Re: [sqlite] convert CString for statement

I have no way to test but i think a call like rc = sqlite3_bind_text(stmt, 1, (LPCTSTR)likeexp, -1, SQLITE_TRANSIENT ); would work 2012/6/26 deltagam...@gmx.net > Hello I have as input parameter > > CString likeexp > > but I think in the following state

[sqlite] Big difference in performance between Python and gcc

Hello, I made some preliminary tests for an application storing big chunks of data in a sqlite database. I did firsts tests with python and they gave me quite impressive results. I then tried to make the same test using C. I expected to get execution times to be the same of those of python. How

[sqlite] Big difference in performance between Python and gcc

Hi Roger, thank for your answer. I tried to modify programs to match your suggestion, performances improved but are still far from pyhon's ones. (Sorry if this message starts a different thread but i had forwards of single messages disabled so i could not reply to the original post) C modif

Re: [sqlite] Big difference in performance between Python and gcc

On the weekend I had way to test the same code on a linux box... performance there are as expected (with C performing slightly better than python with a ~20% difference in execution times between the two). I'll try disabling thread, as they could give a big performance hit on win system. 2011/6/3

Re: [sqlite] Big difference in performance between Python and gcc

2011/6/1 Dominique Pellé : > Alessandro Marzocchi wrote: > >> Hello, >>    I made some preliminary tests for an application storing big >> chunks of data in a sqlite database. I did firsts tests with python >> and they gave me quite impressive results. I then tried to

Re: [sqlite] Fwd: Possible small memory leak

> Now, I'm not sure if getpwuid actually allocates memory. Some > documentation does not mention anything about it; some mention it is not > possible; some mention that getpwuid can result in an ENOMEM > (allocation failed) error, > which clearly indicates that getpwuid tries to allocate some memor

Re: [sqlite] Ensure that query acts on PRE-SORTED tables

2011/7/1 Mohit Sindhwani > On 1/7/2011 5:37 PM, Martin.Engelschalk wrote: > > Hi, > > > > i apologize beforehand if my post does not answer your question > > directly. It seems to me that you may be missing a basic concept. > > > > Data in an SQL table is never sorted in itself. So, you can not s

Re: [sqlite] Ensure that query acts on PRE-SORTED tables

2011/7/1 Simon Slavin > > On 1 Jul 2011, at 11:20am, Alessandro Marzocchi wrote: > > > Isn't it possible to use a view for that? > > You can use a VIEW if you want, but VIEWs don't sort the table either. A > VIEW is just a way of saving a SELECT query.

Re: [sqlite] Inmemory database in sqlite

Today, random-access memory takes the form of integrated circuits . RAM is normally associated with volatile types of memory (such as DRAM memory modules

Re: [sqlite] Inmemory database in sqlite

erview.htm#TTCIN129 > > Does sqlite's in memory db have this feature ? > > Thanks > Prakash > > On Fri, Oct 17, 2014 at 11:54 AM, Prakash Premkumar < > prakash.p...@gmail.com> > wrote: > > > Is features like WAL (https://www.sqlite.org/wal.html) not avai

Re: [sqlite] Performing a SELECT on an enormous database...

Do you have an index on that column? Il 25/ott/2014 14:03 "Ross Altman" ha scritto: > Hi guys, > > I'm currently working with a pretty gigantic database (116 Gb at the > moment, and growing). Performing a simple SELECT routine with one filter > takes between 7 and 15 minutes, which is starting to

Re: [sqlite] Index without backing table

I think what he wants is a way to create an index on a virtual table. I faced a similar problem recently and seeing that there was no apparent way to do that I steered to a completely different way. Lets say I have a immutable binary file which contains n rows of struct containing 10 (let's name th

[sqlite] Virtual table implementation details

Good day, I'm implementing a serialization&undo/redo engine based on sqlite. My implementation (particulars omitted) will work by adding a layer of virtual tables over real sqlite data tables plus a physical table to store the list of modifications made to them (to implement undo functionality

Re: [sqlite] Virtual table implementation details

e database, and will be managed as such. Unless you’re storing data outside the SQLite database, there is nothing for your function to do… the SQLite engine will rollback all the tables and put them into their prior state all on its own. -j On Nov 20, 2014, at 3:26 AM, Alessandro Marzocchi <

[sqlite] Mozilla wiki 'avoid SQLite'

ASFAIK also gcc uses some kind of intermediate rapresentation during compilation process... gimple (gcc -fdump-tree-all) and rtl (-dump-rtl-all) Il 16/giu/2015 22:40, "Simon Slavin" ha scritto: > Since this thread has ... become what it is ... I may as well add a couple > of details. > > The wide