[sqlite] What is the best way to select "evenly" ?

nd I'm scratching my head as to how to accomplish this. The purpose here is to distribute jobs over processing units, distributing the load as evenly as possible. Suggestions very welcome! -- Ron Aaron, CTO Aaron High-Tech, Ltd. +1 425.296.0766 +972 52.652.5543 GPG Key: 91F92EB8 <https://p

[sqlite] Getting a crash on 32-bit Linux

haps something to do with compiler flags, though I don't set the 'arch' or 'tune' to anything. So. Problem solved, and nothing really to do with sqlite per se; but I do wish compilers would do less on my behalf... -- Ron Aaron, CTO Aaron High-Tech, Ltd. +972.52.652.5543 <http://8th-dev.com>

[sqlite] Getting a crash on 32-bit Linux

On 4/14/15 21:06, Richard Hipp wrote: > On 4/14/15, Ron Aaron wrote: >> Something is very wrong, then. The file I downloaded from the >> sqlite.org site, and unzipped, has these: > Yes. My previous email had the wrong version of sqlite3.. Version > 3.8.9 states: >

[sqlite] Getting a crash on 32-bit Linux

Yes: I issued the command: unzip ~/Downloads/sqlite-amalgamation-3080900.zip file reports: Downloads/sqlite-amalgamation-3080900.zip: Zip archive data, at least v1.0 to extract md5 sum: 02e9c3a6daa8b8587cf6bef828c2e33f On 4/14/15 21:05, Nelson, Erik - 2 wrote: > Ron Aaron wr

[sqlite] Getting a crash on 32-bit Linux

376915 Apr 8 17:38 sqlite3.h -rw-r--r--@ 1 ron staff27763 Apr 8 17:38 sqlite3ext.h ~/src/sqlite-amalgamation-3080900$ md5 sqlite3.c MD5 (sqlite3.c) = a99b92d9e510a8107999c474dca017d7 On 4/14/15 20:41, Richard Hipp wrote: > On 4/14/15, Ron Aaron wrote: >> >> On 4/1

[sqlite] Getting a crash on 32-bit Linux

On 4/14/15 18:13, Dan Kennedy wrote: > On 04/14/2015 10:00 PM, Ron Aaron wrote: >> Just updated with the version from sqlite.org and have the same problem: > > The line numbers still don't match the 3.8.9 amalgamation on the > website. Are you running [make sqlite3.c] yours

[sqlite] Getting a crash on 32-bit Linux

sqlite3_open (zFilename=0x91a1610 "test.db", ppDb=0x91a2028) at sqlite3.c:127601 On 4/14/15 17:31, Ron Aaron wrote: > I'm using the one from fossil... > > > On 4/14/15 17:12, Richard Hipp wrote: >> On 4/14/15, Ron Aaron wrote: >>> I just updated to t

[sqlite] Getting a crash on 32-bit Linux

I'm using the one from fossil... On 4/14/15 17:12, Richard Hipp wrote: > On 4/14/15, Ron Aaron wrote: >> I just updated to the 3.8.9 version of SQLite for my project, and am >> compiling for 32-bit linux (on a 64-bit box). >> >> >> I'm getting a

[sqlite] Getting a crash on 32-bit Linux

EPRECATED -DSQLITE_ENABLE_LOCKING_STYLE=0 -DSQLITE_SYSTEM_MALLOC=1 -DSQLITE_OMIT_COMPILEOPTION_DIAGS -DSQLITE_OMIT_TRACE -O0 -c -o sqlite3.o sqlite3.c The crash occurs whether I work in a chroot lin 32 environment or a virtual machine running 'native'. The test application is statically linked. Any clues would be

Re: [sqlite] last modified time or version of sqlite database

On Mon, April 3, 2006 15:49, Chris Fletcher wrote: >> > > Thanks - but this seems to give the number of changes during the > lifetime of a db session. With CGI the sessions will be short lived. > On a new session I want to know when the db

Re: [sqlite] How to cross compile sqlite-3.2.7 for arm9 s3c2410?

On Tue, September 27, 2005 7:39, Frank van Vugt said: > There's some info in the wiki on it, but basically the steps are: Hello, Frank - I successfully created an ARM sqlite3 (3.2.7) and it is running on my Archos PMA400 - thanks! I have noticed that when I create a database and do a simple

Re: [sqlite] Using expressions for 'DEFAULT

On Sun, October 31, 2004 3:58, D. Richard Hipp said: >> However, this statement is not parsed by SQLite: >> >> CREATE TABLE a ( b datetime DEFAULT date('now')); > Changes to implement this capability are already in the > works and will be available within the next two months. > Stay tuned...

Re: [sqlite] Parameterized queries -- howto?

On Thu, October 21, 2004 7:51, Clay Dowling said: > Ron, > > Take a look at the example application in the Linux Journal article > http://www.linuxjournal.com/article.php?sid=7803 > > The parameterized queries provide a much better solution than sprintf. > You can grab a complete working app from

Re: [sqlite] Parameterized queries -- howto?

On Wed, October 20, 2004 18:05, Vladimir Vukicevic said: > I'm confused -- it doesn't make them useless in practice, they can be > used exactly for what they're intended for (precompiled statements). > What exactly are you trying to do? And what other database supports > this? I misspoke.

Re: [sqlite] Parameterized queries -- howto?

On Wed, October 20, 2004 15:35, Vladimir Vukicevic said: > On Wed, 20 Oct 2004 15:15:44 -0700 (PDT), Ron Aaron <[EMAIL PROTECTED]> wrote: >> Thanks. I know it can be done in the C API, that was not the question. The >> question was, can it be done *using SQL* ? > > No

Re: [sqlite] Parameterized queries -- howto?

On Wed, October 20, 2004 14:57, Kurt Welgehausen said: >> Am I missing something? > > Yes. Go to , click on , and > read the C/C++ API Reference. Thanks. I know it can be done in the C API, that was not the question. The question was, can it be done *using SQL* ? -- My GPG public key is

Re: [sqlite] Wich compiler to use in Windows

On Wed, October 20, 2004 5:41, Rubens Jr. said: > Wich compiler do you recomend to use to compile sqlite3.0.8 in Windows ? I use the mingw32 port of the gcc compiler (www.mingw.org) with great success. It has the advantage that it is the (essentially) same compiler used on Linux systems. --

Re: [sqlite] CSV mode not correctly quoting output

On Wed, October 6, 2004 10:15, b.bum said: > I'll file a bug on this. Anyone know how to file a bug such that the > formating isn't smushed into a single line? I already logged a bug (#911) along with a fix -- My GPG public key is at http://ronware.org/ fingerprint: 8130 734C 69A3 6542 0853

[sqlite] How to 'flatten' query results?

In my membership database, I have a 'people' table and a 'userviews' table. This second table consists of a (name,sql) pair. What it does is allow my users to load a particular list of people from the people table. So for example, ('LA','where city like "LA"') might be the entry for a "view"

Re: [sqlite] ON INSERT trigger

On Tue, September 21, 2004 11:26, Christian Smith said: > On Tue, 21 Sep 2004, Alex wrote: > > In which case it might be better to convert the replace insert into an > update, and use the update trigger which is guaranteed to have valid OLD > and NEW. > > But that is not my decision to make.

[sqlite] For vim users: dbext.vim supports sqlite now

>From the vim mailing list: (David Fishburn, the author, says:) I am pleased to announce an update to dbext to version 2.10. http://vim.sourceforge.net/scripts/script.php?script_id=356 This release has increased the supported databases to 10 by adding SQLite (www.sqlite.org). -- My GPG public

[sqlite] PATCH: [sqlite] sqlite output request: .mode csv

On Mon, September 13, 2004 12:14, Ron Aaron said: Responding to my own complaint: here is a patch against current CVS version, fixing the typo in the '-help' and implementing ".mode cvs" properly (at least, in my opinion) -- My GPG public key is at http://ronware.org/ fingerprint:

Re: [sqlite] sqlite output request: .mode csv

On Mon, September 13, 2004 8:28, Ron Aaron said: > I have been asked to output an 'Excel'-friendly report for someone, which > means dumping a "CSV" (Comma Separated Values) file. > > Setting ".separator ',' " gets me part of the way. Unfortunately, I need t

[sqlite] sqlite output request: .mode csv

I have been asked to output an 'Excel'-friendly report for someone, which means dumping a "CSV" (Comma Separated Values) file. Setting ".separator ',' " gets me part of the way. Unfortunately, I need to manually quote strings using something like this: SELECT '"' || name || '"', '"' || address

Re: [sqlite] An update with LIMIT ?

On Fri, June 11, 2004 12:50, Jay Macaulay said: > Hi all, > > I have a database where I'm selecting rows using LIMIT. Is there a way I > could use LIMIT in an update? For example right now I do: > > SELECT * FROM address WHERE group="a" LIMIT 5; > > Is there some way I could instantly update

[sqlite] Re: 'cating' sqlite databases

On Thursday 08 April 2004 01:49 pm, Stathy G Touloumis wrote: > Hi, > > We are working on a potential architecture by which many sqlite databases > are created. There may be a need to aggregate data between databases and I > was wondering if it's possible to quickly just 'cat' the databases

[sqlite] Re: sqlite.org ISP problems

On Wednesday 31 March 2004 07:30 am, D. Richard Hipp wrote: > > 2. If you can recommend a good ISP, please do so. I'm hosting my site via dyndns.org, which works well for me. -- My GPG public key is at http://ronware.org/ fingerprint: 4E91 06E9 2020 114C 8BCD 55B2 0816 60AF 2B3D 4C51

[sqlite] Re: Quick import

On Monday 29 March 2004 09:14 am, Dembskey, E. (Evan) wrote: > Hi again, > > Is there a quick way to import a text file into a sqlite db? I have 110 > records, and would naturally prefer not to manually enter them. If there is > a way to get the field names from the same file, so much the

[sqlite] Re: Changing values from triggers

new.* or old.* inside a trigger, but you can accomplish what you want like this: -- File:test.sql -- Description: Test file for Avner Levy -- Author: Ron Aaron -- Created: Sun 28 Mar 2004 11:21:21 -- Last updated:Mon 29 Mar 2004 08:46:02 BEGI

[sqlite] Re: Report writer

On Tuesday 16 March 2004 06:42 am, Griggs, Donald wrote: > > Are you developing for Windows? If so, I don't know if one of these might > be of help: > > 1) I see there's a commercial, but not expensive product (US$40), > SqliteManager Thanks, Donald (and other who've responded). I will

[sqlite] Re: Report writer

On Sunday 14 March 2004 10:17 am, Will Leshner wrote: > What kind of features are you looking for in such a report writer? My program is a membership management database. The db has a list of people, with various information about them distributed over several tables. For example, the 'people'

[sqlite] Report writer

Hi all - Does anyone have a generic report writer which could be used with SQLite? I keep getting requests for the ability to have 'user created' reports, and I don't want to rewrite something someone else has done already if possible. I also can't afford a commercial solution, as this is for

[sqlite] Patch for MingW32 build on Windows

Hi all - I'm attaching my very tiny diffs to make the MingW32 compile on Windows generate a good sqlite.dll and a sqlite.exe which uses the dll. It also produces a libsqlite.a so you can link in other apps. The zip contains: Length Date TimeName

[sqlite] Re: Using SQLite

On Sunday 01 February 2004 04:06 pm, Demitri Muna wrote: > Hello, Hi, Demitri - > I need to embed a database into my application, and was referred to > SQLite. I narrowed down my options to it and PostgreSQL (which I am not > completely sure I can embed into an app). One thing that I need to be >

[sqlite] Re: random record

On Wednesday 14 January 2004 09:32 am, Caleb Groom wrote: > Does sqlite have some way to fetch a random record? I'm looking for > something similar to MySQL's 'select * from tbl order by rand() limit > 1'. Same thing: SELECT * FROM tbl ORDER BY random() LIMIT 1; works for me.

[sqlite] How do I coalesce values in a join?

Hi all - This may be a boneheaded question, but I cannot figure out how to accomplish what I want. I have two tables: people (id,first,last) and phones (id, type, phone) Where each person in the 'people' table might have up to four phones. I can easily get a report of phones by joining