Re: [sqlite] Sqlite + Dropbox

2017-04-07 Thread Adam DeVita
I've been using Dropbox to synchronize sqlite files with no problems for a year, but only use the Dropbox directory as a synchronization buffer, not as a place to do work. I usually 1) make a copy of the db in a non drop box directory, 2) complete all work on the copy, 3) replace the Dropbox

Re: [sqlite] Faster check: > or !=

2017-02-13 Thread Adam DeVita
How much control do you have? Can you put out your date code into an integer field? Can you set an index on id, projId, and Xtrab ? regards, Adam From: sqlite-users on behalf of jose isaias cabrera

Re: [sqlite] how is "pragma threads = 4" working

2016-09-16 Thread Adam Devita
Have you proven that the cpu is the bottleneck? Sorting a million rows seems like a lot, but even older single core cpus may be capable of 2 billion ops per second. [I apologize if this has been sorted out already I've got about 2 days of history on the thread] regards, Adam DeVita On Fri

Re: [sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

2016-08-25 Thread Adam Devita
Please retry your test without using keywords like "inner" as an alias for something. regards, Adam On Wed, Aug 24, 2016 at 11:26 PM, Richard Newman wrote: > Hi folks, > > According to my reading of < >>, a table alias

Re: [sqlite] Error File is Encrypted or is not a database

2016-08-18 Thread Adam Devita
ow the header is corrupted? I would like to > know the reason to resolve it. > Thanks again! > > 2016-08-18 10:14 GMT-03:00 Adam Devita <>: > > > Good day, > > > > A few things that you can try > > 1) One could download a hex editor

Re: [sqlite] Error File is Encrypted or is not a database

2016-08-18 Thread Adam Devita
Good day, A few things that you can try 1) One could download a hex editor and review the beginning of the file and compare to . If some other program has over-written the header, you should be able to observe that, hopefully identifying a program with a

Re: [sqlite] a couple of pre-initial questions

2016-07-06 Thread Adam Devita
to compile it) are at regards Adam DeVita On Wed, Jul 6, 2016 at 12:15 PM, John R. Sowden <> wrote: > Good Morning: > > I am a pre-newbie. A few questions. Q1: I am running xubuntu. When I > search for sql

[sqlite] Podcast with Dr Hipp: SQLite history, success and funding

2016-05-19 Thread Adam Devita
This link is a presentation on 'we wish git had this' by DRH. This is the fossil page on the subject of comparing vs git. That said, at my workplace we use git. How else can Windows

[sqlite] Fastest way to backup/copy database?

2016-05-09 Thread Adam Devita
Re WAL mode trick. I think you would want to complete a checkpoint and then do the backup, ensuring that no check-points are done during your backup time. This way, you know that your committed transactions prior to the backup are in the file being backed up. regards, Adam On Sat, May 7, 2016

[sqlite] Fastest way to backup/copy database?

2016-05-05 Thread Adam Devita
the remote host decided to change their address or pc and the sync fails because it is asking if THIS host can be trusted. regards, Adam DeVita On Thu, May 5, 2016 at 11:50 AM, Rob Willett wrote: > Hi, > > We did look at this before, and discarded the idea but I can?t remember >

[sqlite] strftime accepts an illegal time string

2016-05-05 Thread Adam Devita
ling it out so save a few KB on the device.) People on the list are genuinely trying to be helpful, even if cross language text comes across as terse, try to keep that context. best wishes, Adam DeVita On Thu, May 5, 2016 at 8:52 AM, Cecil Westerhof wrote: > 2016-05-05 12:39 GMT+0

[sqlite] Is it possible that dropping a big table takes very long

2016-04-22 Thread Adam Devita
of memory it used as dropped? (This is obvious for high security mode, but otherwise?) regards, Adam DeVita On Fri, Apr 22, 2016 at 8:23 AM, Cecil Westerhof wrote: > 2016-04-22 14:06 GMT+02:00 E.Pasma : > >> >> 22 apr 2016, Cecil Westerhof: >> >>> >>>

[sqlite] Primary key values can be NULL

2016-04-18 Thread Adam Devita
I had a similar thought, until I imagined Program uses sqlite DLL The program creates dbs, and sometimes does inserts with null primary keys. (Why is beyond the scope, it just does sometimes.) Upgrading the DLL would start making files in the new format, but the program using the dll doesn't

[sqlite] Article about pointer abuse in SQLite

2016-03-22 Thread Adam Devita
variant of "hay, you are depending on implemented, not documented behaviour" ? regards, Adam DeVita On Tue, Mar 22, 2016 at 7:27 AM, Scott Doctor wrote: > > It is uninitialized. you are setting an initial value within an if > statement. For the compiler, the code has NOT ac

[sqlite] SQLite Pronunciation

2016-03-16 Thread Adam Devita
Since Jay is The Certified SQLite Professional , ( at ) and by fortunate co-incidence what he said (and DRH) happens to match what I was doing, I'll agree with them, and celebrate by making a potato salad with

[sqlite] How to enter Unicode character?

2016-02-08 Thread Adam Devita
Good day, What OS are you using? Have you read up on this? Also, Notepad++ is a good text editor for displaying / saving them. (I assume that you are wanting to generate some text files as scripts) regards, Adam DeVita On Mon, Feb 8

[sqlite] Bug: Successfully committed transaction rolled back after power failure

2016-02-01 Thread Adam Devita
At the risk of repeating something mentioned last week on this thread. One tactic to reduce/avoid the no-directory sync problem is to use WAL mode. The commit in WAL is write to the WAL file, so the the directory sync problem goes away. If you want to be in paranoid mode, don't trust others. Why

[sqlite] SQLite crashing

2016-01-25 Thread Adam Devita
een null at this point" Are you unit testing the trivial cases? Create+Destroy Create+Connect+Destroy Create+Connect+DoBasicQuery+Destroy regards, Adam On Mon, Jan 25, 2016 at 2:02 PM, Igor Korot wrote: > Hi, Adam, > > On Mon, Jan 25, 2016 at 11:27 AM, Adam Devita wrote: >>

[sqlite] SQLite crashing

2016-01-25 Thread Adam Devita
Where do you pass to the dll something that goes to sqlite3_close(db); ? ( ) When that happens, does m_db get set to NULL (or now refers to memory that is now NULL) Do you check for m_db == NULL before deleting it? regards, Adam DeVita On Mon, Jan 25, 2016

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Adam Devita
an redirect your output to another file and funnel everything through .read Be careful about empty set results! regards, Adam DeVita On Fri, Jan 15, 2016 at 8:32 AM, Dominique Devienne wrote: > On Fri, Jan 15, 2016 at 4:53 AM, Matthew Allen wrote: > >> It seems that sqlite3.exe (console)

[sqlite] analysis of a corrupt db

2016-01-14 Thread Adam Devita
be run under sub-optimal power conditions. It seems unlikely this is an sqlite issue. It may be a file system / hardware / harsh environment thing. Adam On Wed, Jan 13, 2016 at 7:00 PM, David Woodhouse wrote: > On Tue, 2016-01-12 at 12:18 -0500, Adam Devita wrote: >> >> A co-worker

[sqlite] analysis of a corrupt db

2016-01-12 Thread Adam Devita
# of entries in index sqlite_autoindex_config_1 regards, Adam On Tue, Jan 12, 2016 at 12:01 PM, Adam Devita wrote: > Good day, > Thank you for some avenues of investigation. > > Q: Does your program examine the codes returned by SQLite3 calls and > check to see that they

[sqlite] analysis of a corrupt db

2016-01-12 Thread Adam Devita
ur device doesn't have all the utilities but I can put a copy of the bad db on a development linux environment for further tests. On Tue, Jan 12, 2016 at 10:55 AM, Richard Hipp wrote: > On 1/12/16, Adam Devita wrote: >> >> Shell Tool Observations: >> SQLite version 201

[sqlite] analysis of a corrupt db

2016-01-12 Thread Adam Devita
e upgrade, or immediately after it as the normal mode works through the records with 'dirty' cache. That said, all ~200 records of 'dirty' cache should be updated in 1 transaction, so 1 record being wrong seems to not fit. ) regards, Adam DeVita BTW: While testing this, I noticed that if I ftp

[sqlite] Problem with accumulating decimal values

2015-12-16 Thread Adam Devita
Good day, As a matter of interest, when calculating interest on a sum of money expressed in pennies, how do you handle int arithmetic truncating? Is that an accounting design rule thing when dealing with fractions of a penny to round? Is this an arbitrary quantization? Once upon a time there

[sqlite] Problem with accumulating decimal values

2015-12-11 Thread Adam Devita
A good start at the long answer can be found in the archives of this list. also found at at (web search sqlite "simple math question") It

[sqlite] How to see SQLite debugging information

2015-12-09 Thread Adam Devita
or potential source of error in a chain. regards, Adam DeVita On Wed, Dec 9, 2015 at 10:12 AM, Bart Smissaert wrote: > Will look at this, it is a VB6 console app and that may just do the job: > > > RBS > > On Wed, Dec 9, 2015 at 1:03 PM, wrote:

[sqlite] Making data unique

2015-12-07 Thread Adam Devita
When you are about to insert into the table and find that ID & Date/time are identical to another record, but the data is different, do you want to overwrite, or not? Do you want an error? Adam On Mon, Dec 7, 2015 at 10:01 AM, Andrew Stewart wrote: > Hi, > I have a table that

[sqlite] Warnings for non-deterministic queries?

2015-11-27 Thread Adam Devita
I think the OP meant to write: "If the expression is an aggregate expression, it is evaluated across all rows in the group. Otherwise, it is evaluated against a single arbitrarily chosen row from within the group. " Is there a way I could programmatically determine that a query is going to use an

[sqlite] Mailing list policy change

2015-10-29 Thread Adam Devita
Assuming the A*spammer is a basic algo subscribed to the list, and sending to any sender in a reasonably short time after posting; Question: Is it possible for the admin to easily backup the list, bisect it, and test for spam? That technique should identify the offending address in

[sqlite] setup C code with cppunit using test db

2015-08-11 Thread Adam Devita
into this one? What should I do ? regards, Adam DeVita -- -- VerifEye Technologies Inc. 151 Whitehall Dr. Unit 2 Markham, ON L3R 9T1

[sqlite] what is typical pattern for test double of sqlite c api

2015-08-11 Thread Adam Devita
Good day, I'm about to implement TDD for an existing c project that uses sqlite, using CPPUnit. Sqlite would be a dependency from the point of view of the routines making calls to it. Is is typical to just write a link time stub to substitute commonly used parts of the interface (exec, open,

[sqlite] CSV excel import

2015-07-30 Thread Adam Devita
Instead of trying to conform to MS-Excel's csv format, wouldn't it be better to write an import from .xls (or .ods if that is an open standard) directly? That way each cell's value can be bound to a position holder in a query. No more fussing with "In this country we use this symbol to denote

[sqlite] Could frequent 'database is locked' errors mean SQLite is not a good fit for my application?

2015-07-02 Thread Adam Devita
Good day, I'm sure others on the list will add better insight, but is your task parallel enough that your nodes can work with a copy of the database and submit changes the one the others copy from when 'done' their calculation? Are you using ?

[sqlite] FW: SQLite (1.0.97) access via LAN

2015-06-26 Thread Adam Devita
What happens if you map a network drive to \\PC-Name\C\FolderName (say drive X:) and then try to open the file as x:\data.db ? Adam On Thu, Jun 25, 2015 at 10:24 AM, Takashi Fukuda wrote: > Donald Griggs tried to help this problem, and we looked at the Jean C's > advice. However the problem

[sqlite] building SQLite DLL with Visual C++

2015-04-23 Thread Adam Devita
e to store data. I studied SQL and Oracle 10 > years ago. I have almost completed the database for the project. My > problem is how to integrate the SQL db into my VB program. > > On Wed, Apr 22, 2015 at 10:16 AM, Adam Devita wrote: > >> Good day, >> >> >>

[sqlite] building SQLite DLL with Visual C++

2015-04-22 Thread Adam Devita
) ? If you insist on creating your own dll, try the vs wizard to create a dll project, then add code to it. regards, Adam DeVita On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik wrote: > On 4/21/2015 11:01 AM, Jay Smith wrote: >> >> Before I sent the last message I had signed up to becom

[sqlite] Why is empty string not equal to empty blob?

2015-03-19 Thread Adam Devita
As a general rule of thumb, if things are different type, they can't be equal. One already knows the column type. To compare apples to apples, one would cast to convert them. sqlite> SELECT '' = x''; 0 sqlite> SELECT cast('' as blob) = x''; 1 Perhaps some confusion comes from how numbers are

[sqlite] (no subject)

2015-03-11 Thread Adam Devita
from "SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4, but work fine with PHP5. Work just as well on a platform Linux as on Windows or MAC." from "SQLite is a

[sqlite] minor doc error

2015-03-09 Thread Adam Devita "On of the distinctive features of SQLite" should be "One of the distinctive features of SQLite"

Re: [sqlite] Best Practice: Storing Dates

2015-01-14 Thread Adam Devita
, have the authority to change the time zone or implementation date for their population, there is a high potential for change. 3rd party time zone rule libraries can externalize most of the maintenance work without affecting the core app or the database. regards, Adam DeVita On Wed, Jan 14, 2015

Re: [sqlite] Counting rows

2014-12-11 Thread Adam Devita
>From previous reading (years ago on this list) I normally do select count(1) from tableName ; to count the rows in a table. as an alternate, select count(primary_key_or_SomeIndexName) from tableName when trying to get an actual count. beware: select count(someField) from table; will not count

Re: [sqlite] DEFAULT expression ignored for INTEGER PRIMARY KEYs?

2014-09-25 Thread Adam Devita
Your table definition seems to have a contradiction. The expression INTEGER PRIMARY KEY is a special keyword that means 'auto-increment', which would be a default value. DEFAULT (random() ) would contradict the auto-increment instruction. The row id was being used to generate the key. On Thu,

Re: [sqlite] Window functions?

2014-08-28 Thread Adam Devita
likely to change without notice. Thanks for the references about windowing functions. Very interesting. The point of what is heavy now vs in 2020 is well made. Is Windowing a Major endeavor, better for sqlite 4? Adam DeVita On Wed, Aug 27, 2014 at 8:25 PM, Keith Medcalf <>

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-12 Thread Adam Devita
1a) Somebody is paying you to do it. 1b) Incremental cost (or risk) of supporting it is small compared to the cost (or risk) of porting /upgrading Adam On Tue, Aug 12, 2014 at 2:46 AM, Klaas V wrote: > > > Jan wrote: " ** can manually set this value to 1 to emulate

Re: [sqlite] SQLite Support for CE x32 FW 3.5

2014-08-06 Thread Adam Devita
Did you already read ? On Tue, Aug 5, 2014 at 10:32 AM, Tobias Stüker wrote: > Hello, > > I am developing an .NET Framework 3.5 application for a Windows CE

Re: [sqlite] How synchronize two databases

2014-03-10 Thread Adam Devita
. regards, Adam DeVita On Mon, Mar 10, 2014 at 8:15 AM, Simon Slavin <> wrote: > > On 10 Mar 2014, at 12:58pm, Muhammad Bashir Al-Noimi <> > wrote: > > > May I get some help from you guys? > > If you're asking how to syn

Re: [sqlite] SQLite destroys civilization.

2014-03-03 Thread Adam Devita
LOL! Hopefully they wrote credit at the top of the source file. I saw season 1 of the show. Aaron is a "good guy". A On Sun, Mar 2, 2014 at 9:40 PM, mm.w <> wrote: > LOL > > don't know if it will go thru see png > >

Re: [sqlite] Recommended way to delete rows

2014-02-28 Thread Adam Devita
Yes. On Fri, Feb 28, 2014 at 12:18 PM, L. Wood wrote: > > I expect #2 to work best. Make sure to enclose the whole thing in an > > explicit transaction (or at least, run large batches within explicit > > transactions; one implicit transaction per deleted row will be slow as >

Re: [sqlite] How to use SQLite in C#

2014-02-13 Thread Adam Devita
ols. regards, Adam DeVita On Wed, Feb 12, 2014 at 9:23 AM, Jamiil <> wrote: > After downloading sqlite-netFx451-static-binary-x64-2013- and > uncompressing it, I got this list of file: > > Installer.exe > Installer.pdb > northwind

Re: [sqlite] Proposed enhancement to the sqlite3.exe command-line shell

2014-02-10 Thread Adam Devita
Good day, I'd rather the warning be in the text when you open the sqlite tool with an implied in memory database. Put an extra \n if you want the warning to stand out. Adam On Mon, Feb 10, 2014 at 1:26 PM, Petite Abeille wrote: > > On Feb 10, 2014, at 5:19 PM,

Re: [sqlite] possible bug 3.8.1 /3.8.3

2014-02-03 Thread Adam Devita
is picked. regards, Adam On Mon, Feb 3, 2014 at 12:47 PM, Richard Hipp <> wrote: > Can you provide data? Without some sample data, we cannot tell if the > answer SQLite is providing is right or wrong. > > > On Mon, Feb 3, 2014 at 12:25 PM, Adam Devita <adev..

[sqlite] possible bug 3.8.1 /3.8.3

2014-02-03 Thread Adam Devita
ULL, data_blob BLOB NOT NULL); sqlite> SELECT id, data_blob FROM data WHERE stream_num = 2 order by timestamp asc LIMIT 1; 4|☺ sqlite> SELECT id, data_blob FROM data WHERE timestamp = (SELECT MIN(timestamp) FROM data WHERE stream_num = 2) LIMIT 1; 3|☻ sqlite> regards,

Re: [sqlite] SQLite patch contribution

2013-07-22 Thread Adam DeVita
Is it possible for one in a nation that doesn't permit dedication to public domain to simply gift the work (and intellectual rights) to someone personally, who can and will the reassign it to the public domain (such as a member of the sqlite dev team)? On Mon, Jul 22, 2013 at 9:30 AM, Dušan

Re: [sqlite] Command-line utility

2013-07-11 Thread Adam DeVita scroll to "Precompiled Binaries for Windows" It runs just fine on 32 bit windows. Adam On Thu, Jul 11, 2013 at 12:20 PM, RSmith wrote: > Could someone send me a build with the current trunk of the command-line > utility for Windows 32Bit

Re: [sqlite] Getting Started with Sqlite

2013-05-22 Thread Adam DeVita
When you open the command prompt you will see something like this: c:\PINTS>sqlite3.exe SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> The above clearly indicates version 3.6.10. Others on the list will correct me if I am wrong, but the

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Adam DeVita
If you can get the errors, by say redirecting the output from the .read to a file, the error message will likely be enlightening. When I recover corrupt db files, there are often some records with a conflicting primary key. In those cases I have to edit the input to fix the old one. Naturally,

Re: [sqlite] Malformed database recovery

2013-05-14 Thread Adam DeVita
Where there any errors on .read dump_all.sql ? was PRAGMA integrity_check; on the new file or the old one? On Tue, May 14, 2013 at 10:29 AM, Marcin wrote: > Hi everybody. > > Somehow my database got malformed, and journal file is unfortunately > nowhere to found. > >

Re: [sqlite] example code?

2013-01-28 Thread Adam DeVita
>From this URL The basics of how to set your project and include/reference the Dlls are there. You should be able to adapt to your IDE. (I currently use VS2010 for C# sqlite projects.) and this one

Re: [sqlite] complex update

2012-12-19 Thread Adam DeVita
Thank you for the principal. I had to rewrite a little since I only wanted to affect the rows that were using the max entry. Adam On Tue, Dec 18, 2012 at 12:58 PM, Igor Tandetnik <> wrote: > On 12/18/2012 12:27 PM, Adam DeVita wrote: >> >> There is a tab

[sqlite] complex update

2012-12-18 Thread Adam DeVita
Good day, I'm attempting to fix some bad data: There is a table products where has a location id. Unfortunately duplicate dictionary names got added to list of locations products haslocationid and a bunch of other stuff I can easily get the max (bad) and min (good) location ids

Re: [sqlite] just a test

2012-12-10 Thread Adam DeVita
Gmail users: You can set a Filter to ensure the Igor's messages are delivered to your in-box. I did this last week and since then his messages do not end up in my SPAM folder. If you search "This message may not have been sent by..." warning in Gmail help, there are instructions. Adam On

Re: [sqlite] VC++ and SQLite

2012-11-12 Thread Adam DeVita
It isn't VS2010 specific. Even going back to VS6 writing your own C++ wrapper and including the.c file you had to tell it to not use precompiled headers for that file. (Both Debug and Release builds) You should tell VS that this file will not ever be using precompiled headers. On VS2012

Re: [sqlite] statement prepares OK but step returns SQLITE_NOTADB

2012-10-29 Thread Adam DeVita
Thanks for the clarification. Adam On Sat, Oct 27, 2012 at 12:13 PM, Simon Slavin wrote: > > On 27 Oct 2012, at 6:36am, Dan Kennedy wrote: > >> On 10/27/2012 07:06 AM, Simon Slavin wrote: >>> >>> On 26 Oct 2012, at 11:05pm, Clemens

[sqlite] statement prepares OK but step returns SQLITE_NOTADB

2012-10-26 Thread Adam DeVita
the statement given that it returned an error. I'm using the basic amalgamation c file SQLite version 3.7.4. regards, Adam DeVita ___ sqlite-users mailing list

Re: [sqlite] Why can't SQLite drop columns?

2012-10-09 Thread Adam DeVita
I expect that users accept that Alter table can be expensive.Is there more to it? Some sort of ACID breakdown? regards, Adam DeVita On Tue, Oct 9, 2012 at 12:45 PM, Peter Haworth <> wrote: > Pete > lcSQL Software <> > You're probably

Re: [sqlite] SQLLite Question regarding instances and files

2012-09-18 Thread Adam DeVita
Good day, You are treating the database files as test log files, correct? If you are wanting a PC to execute a program that accesses an sqlite database file on a network, it is possible. If you read through previous discussions in this mail list archive you will find numerous warnings and

Re: [sqlite] C# Dynamic data type

2012-08-08 Thread Adam DeVita
char *line3="x1234.5"; > datatype(line1); > datatype(line2); > datatype(line3); > } > ~ > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit > Northrop Grumman Information Systems >

[sqlite] C# Dynamic data type

2012-08-07 Thread Adam DeVita
Good day, I've been reading a bit of conflicted stuff online in terms of data type. The most basic question, in C#, is can you easily determine the data type of the Nth entry in a column. {Ex: Create table A( x TEXT, y ) ... a few inserts, binding a float, then a string, then an int into y..

Re: [sqlite] sqlite3 database unreadable on Mountain Lion

2012-08-03 Thread Adam DeVita
Good day, I had a similar sounding issue on 2 different flavours of Windows. The problem was an over active anti-virus program. Adam On Fri, Aug 3, 2012 at 11:45 AM, Simon Slavin wrote: > > On 3 Aug 2012, at 3:33pm, Tobias Giesen wrote: > >> I

Re: [sqlite] Not sure how to interrupt this

2012-06-28 Thread Adam DeVita
SQLITE DONE is what you get when you successfully run an insert. What is the problem? Adam On Wed, Jun 27, 2012 at 7:02 PM, Jeff Archer wrote: > I am getting back SQLITE_DONE (101) from sqlite3_step() and the statement > is clearly being executed. > > SQL: "INSERT INTO

Re: [sqlite] Problem with including sqlite3.c into c++ project

2012-06-25 Thread Adam DeVita
Do not use precompiled headers on sqlite3.c On Mon, Jun 25, 2012 at 4:22 PM, Pavel Ivanov wrote: > On Mon, Jun 25, 2012 at 4:15 PM, > wrote: > > Hello, > > > > Im using MSVS 2010 for an c++ GUI project. > > After including sqlite3.h

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-28 Thread Adam DeVita
operating systems too? > > > > Peter Walburn > Software Engineer > E-mail: > Units 44-46 Howe Moss Avenue, Kirkhill Industrial Estate, Dyce, Aberdeen > AB21 0GP > Tel: +44 (0)1224 772763 > Fax: +44 (0)1224 772783 > &

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-25 Thread Adam DeVita
83 > > > > > > -Original Message- > From: [mailto: >] On Behalf Of Adam DeVita > Sent: 25 May 2012 16:37 > To: General Discussion of SQLite Database > Subject: Re: [s

Re: [sqlite] FW: Problem with SQLite when deployed.

2012-05-25 Thread Adam DeVita
Simple thing first: Did you ensure that the SQLite.Interop.dll is in the path that the PC is searching? regards, Adam On Fri, May 25, 2012 at 10:57 AM, Peter Walburn <> wrote: > Hi, > > I have an application written in C# .Net 4.0 Framework. I use SQLite > within

Re: [sqlite] Please review this email to sqlite's mailing list

2012-05-16 Thread Adam DeVita
Did you check out Could you use an in-memory db to act as a db for a save point? When you are ready to commit, do so from 1 in memory db, while accumulating into another in preparation for that save point. Adam On Tue, May 15, 2012 at 1:55 PM, Charles

Re: [sqlite] [sqlite-dev] Explain what 'transaction' means in javascript for sqlite, please?

2012-05-09 Thread Adam DeVita
STW: other references On Wed, May 9, 2012 at 10:32 AM, Pavel Ivanov wrote: > And again you wrote to the wrong

[sqlite] .NET and network server

2012-04-24 Thread Adam DeVita
Good day, Is anyone using .NET c# code as a client to connect to one of the free network server implementations? regards, Adam ___ sqlite-users mailing list

[sqlite] error 404

2012-04-23 Thread Adam DeVita
Good day, This page Is giving an error 404 for this link *SQL4Sockets* ( regards, Adam ___ sqlite-users mailing list

[sqlite] type-o on

2012-04-19 Thread Adam DeVita
ite for .NET is missing a letter 'd'. The word "an" should be "and". " source code and binaries" regards, Adam DeVita ___ sqlite-users mailing list

Re: [sqlite] why one row's results isn't the same between program and command shell

2012-03-21 Thread Adam DeVita
Sorry for false alarm. Please disregard this thread: Solution: make sure you quit everything and isolate the code. There is a subsequent write to the new record that made it appear as a problem, when it wasn't. Adam On Wed, Mar 21, 2012 at 3:25 PM, Adam DeVita <>

[sqlite] why one row's results isn't the same between program and command shell

2012-03-21 Thread Adam DeVita
-1E-90-31-8D-19|3||1 PROGRAMMER-LAB00-03-0D-00-00-01|3||1 ADAM-PC00-25-64-8C-5A-3B|3|2012.|0 (Windows 7 32 bit edition PC. Tried with new copy of amalgamation 3.7.11 as well as 3.7.4) Why is the last entry wrong? Any suggestions as to how to review? regards, Adam DeVita VerifEye

Re: [sqlite] insert image into db - windows batch

2012-01-18 Thread Adam DeVita
, X'reference_to_your_hex_data' ) the X' ' to denotes your hex value. This is listed in the documentation. regards, Adam DeVita On Wed, Jan 18, 2012 at 10:02 AM, Petr Lázňovský <> wrote: > > On 18 Jan 2012, at 12:30pm, Petr Lázňovský wrote: > > >>>> have windows ba

Re: [sqlite] Auto index with wrong number of entries

2011-06-29 Thread Adam DeVita
; > On 29 Jun 2011, at 2:04pm, Adam DeVita wrote: > > > On Tue, Jun 28, 2011 at 11:34 AM, Simon Slavin <> > wrote: > > > >> Use the sqlite3 command-line shell to dump the database to SQL commands, > >> then create a new database by read

Re: [sqlite] Auto index with wrong number of entries

2011-06-29 Thread Adam DeVita
Success! On Tue, Jun 28, 2011 at 11:34 AM, Simon Slavin <> wrote: > > On 28 Jun 2011, at 4:22pm, Adam DeVita wrote: > > > I can see the data that I want to export. How do I fix these indexes? > > Use the sqlite3 command-line shell to dump t

[sqlite] Auto index with wrong number of entries

2011-06-28 Thread Adam DeVita
from ... table above. I can see the data that I want to export. How do I fix these indexes? regards, Adam DeVita ___ sqlite-users mailing list

Re: [sqlite] SQLite as a Logger: How to mimic "rotation of logs"?

2011-05-10 Thread Adam DeVita
Why not use INSERT OR REPLACE to your advantage? If you set the maximum number of log entries you wanted to keep, then kept track of your log insert statement, you could wrap by int this_log_entry_id=1; //initialize.. actually could be initialized by getting the log entry id of the min date in

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-19 Thread Adam DeVita
; > > eLaReF > > > > > On 18/04/2011 14:46, Pavel Ivanov wrote: > > You won't be able to insert. The statement will fail. > > > > Pavel > > > > > > On Mon, Apr 18, 2011 at 9:44 AM, Adam DeVita<> > wrote: >

[sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-18 Thread Adam DeVita
Good day, What happens if you insert more than your RAM size into an in memory database? (I'm particularly interested in the Windows context). regards, Adam ___ sqlite-users mailing list

Re: [sqlite] X most recent entries

2011-03-14 Thread Adam DeVita
ELECT rowid FROM > multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM > multiturnTable WHERE player2 = '?') AND (complete=0 OR p1SubmitScore=0 > OR p2SubmitScore=0) > > And I only want to consider the last 5000 for any SELECTs from > multiturnTable. > > Thanks, >

Re: [sqlite] X most recent entries

2011-03-14 Thread Adam DeVita
select id from table order by id desc limit 5000 Adam On Mon, Mar 14, 2011 at 1:52 PM, Ian Hardingham wrote: > Hey guys. > > I have a table with an autoincrement primary ID, and as part of a select > I would like to only take the 5000 "largest"/most recent ids. Is there > a

Re: [sqlite] Propose minor incompatible API change

2011-01-11 Thread Adam DeVita
I think that a bunch of good points have been made, especially as to why you should hold your ground. (I don't have sympathy for poor code that doesn't follow the documentation, especially when there is a large, competent, and helpful community group that usually comes to people's aid in less

Re: [sqlite] R: R: Crypto lib for Sqlite - suggest required

2011-01-10 Thread Adam DeVita
Just to add my $0.02 We use HASP HL Encryption. (We use HASP keys for end user products so it was 'free' to my internal product tracking system db.) This key allows the exe to get encrypted and optionally a data file as well. The encryption of the program provides us

Re: [sqlite] 64 bit sqlite 3

2010-12-22 Thread Adam DeVita
cially released code. Now, after showing that my 64 bit problems go away when I include the amalgamation source in the project, the whining just stops. thanks :) Adam On Fri, Dec 17, 2010 at 5:20 PM, Simon Slavin <> wrote: > > On 17 Dec 2010, at 4:30pm, Adam DeVita wr

Re: [sqlite] 64 bit sqlite 3

2010-12-17 Thread Adam DeVita
Will a 64 bit Windows DLL eventually be posted for download? On Fri, Dec 17, 2010 at 9:45 AM, Eric Smith wrote: > On Fri, Dec 17, 2010 at 4:36 AM, giuseppe500 wrote: > > There is a version of SQLite 3 for 64-bit systems? > > or, you can simply compile

Re: [sqlite] Tricky grouping query

2010-10-01 Thread Adam DeVita
Why would you want to do this in plane sql, as opposed to using the API to go through the list and derive it? On Fri, Oct 1, 2010 at 3:37 PM, Andy Chambers wrote: > Given the following > > create table events ( > id, > date, > status > ); > insert into events

Re: [sqlite] Is there a table that show all the available function from sqlite3?

2010-08-13 Thread Adam DeVita
Are you looking for ? On Fri, Aug 13, 2010 at 12:37 PM, Peng Yu wrote: > Hi, > > > > I don't see a table that shows all the available functions in sqlite3. > Would you please let me know if there is

Re: [sqlite] Substring (LIKE "%key%") searches, would FTS3 with suffix-tree tokenizer be the fast way?

2010-08-06 Thread Adam DeVita
A variant on Simon's plan. Are the 10,000 rows static, slowly changing, or frequently changing? Does it make sense to pre-calculate some counts at the time data is loaded? Is this memory constrained so much that you can't afford 1 or 2 MB to let you look up based on ints? (I'm assuming that one

Re: [sqlite] concat 2 const chars ?

2010-07-09 Thread Adam DeVita
and don't use strcpy here is why On Fri, Jul 9, 2010 at 3:06 PM, rollerueckwaerts wrote: > > Hello, > I try to get an sql query string from 2 const chars. > > const char *language; > language = "'6'"; >

Re: [sqlite] concat 2 const chars ?

2010-07-09 Thread Adam DeVita
>From the point of view of a C question, make your array of characters large enough to hold the characters you want (and terminating null) before copying them in. >From the point of view of an SQL: if you want to change the comparison constant in a where clause, look up bind parameters. read

  1   2   >