Re: [sqlite] sqlite sync over network

if anybody tested in a real life situation. George C. Hello from GxG, gxg_...@yahoo.com On Friday, December 6, 2019, 2:32:53 AM GMT+2, Jens Alfke wrote: > On Dec 5, 2019, at 8:05 AM, George wrote: > > Changes -> bidirectional. All terminals ca

Re: [sqlite] sqlite sync over network

We have an app already done in Qt on all terminals. Sqlite it's already used by this app. The only missing part it's our sync to have data on PC for reports and also on screen reports on terminals if operator will need to check.We need sqlite because help us to manage data on terminal and

Re: [sqlite] sqlite sync over network

in a sync log table. If it's not possible than we have to check what we can do else. It's not really time critical so also here we can be flexible. George C. Sent from Yahoo Mail on Android On Thu, Dec 5, 2019 at 17:14, Simon Slavin wrote: On 5 Dec 2019, at 12:54pm, George wrote: > I n

Re: [sqlite] sqlite sync over network

terminals. No internet connection. We run this in our private LAN. All it's local and high speed. No problem with energy consumption, batteries etc. All working on backup UPS. George C. -gXg Sent from Yahoo Mail on Android On Thu, Dec 5, 2019 at 17:14, Simon Slavin wrote: On 5 Dec 2019, a

[sqlite] sqlite sync over network

Hi, I need to sync sqlite tables over network between few devices. Please help me with an opinion with what will be the best approach ? thanks, George ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi

Re: [sqlite] Bug in all-bnf.html documentation?

Fantastic, thank you! > On Jul 13, 2019, at 1:48 PM, Richard Hipp wrote: > > On 7/13/19, George King wrote: >> Is there any written description of the Sqlite grammar or is it >> now only described by the images? If nothing else, I'd be interested to peek >

Re: [sqlite] Bug in all-bnf.html documentation?

Thank you. Is there any written description of the Sqlite grammar or is it now only described by the images? If nothing else, I'd be interested to peek at any sort of grammar representation in the source code. > On Jul 13, 2019, at 12:28 PM, Richard Hipp wrote: > > On 7/13/19, Ge

[sqlite] Bug in all-bnf.html documentation?

ld send this report somewhere else. Thank you, George ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

imple solution ... heck look at SQLite ... so I think the capture one might be the best no matter what the mailman like package and mail server. You are in control ultimately. HTH, Regards, George ___ sqlite-users mailing list sqlite-users@mailinglis

Re: [sqlite] sqlite.org website is now HTTPS-only

On Thu, 7 Jun 2018 23:19:22 -0500 "J.B. Nicholson" wrote: > George wrote: > > Why can't we have both? I mean the software is in the public domain > > there is nothing to hide so what's the point of encrypting the site? > > ISPs and other intermediaries alter websi

Re: [sqlite] sqlite.org website is now HTTPS-only

can't we have both? I mean the software is in the public domain there is nothing to hide so what's the point of encrypting the site? Cheers and thank for you generosity and work. Best regards, George ___ sqlite-users mailing list sqlite-users@mailinglis

[sqlite] SQLite math/stats functions

Hey everyone I'm looking for various math/aggregation/stats functions for SQLite past what's offered by the existing language Deciles, linear math (correlation, regression), ranking, etc I've seen this http://www.sqlite.org/contrib/download/extension-functions.c?get=25 buts it's not nearly

[sqlite] FW: SQLite 4 compilation errors in Windows

ting Code... Apparently sqlite4 sources at the moment, comply only with Linux headers and libraries and are not ported to use Windows. Is there any provision in the future to fix the source to compile for windows environment? I attach the sources I used. Thanks George Georgopoulos This e-mail, and

[sqlite] Newbie issue - Linux error malloc.c:2372: sysmalloc: Assertion `(old_top == (((mbinptr) (((char *)

On Sun, 7 Jun 2015 21:36:51 +0200 George wrote: > On Sat, 06 Jun 2015 21:14:46 +0700 > Dan Kennedy wrote: > > > On 06/06/2015 03:19 AM, George wrote: > > > Hello everyone, > > > > > > I am new to the list. I am working on an application in which I >

[sqlite] Newbie issue - Linux error malloc.c:2372: sysmalloc: Assertion `(old_top == (((mbinptr) (((char *)

On Sat, 06 Jun 2015 21:14:46 +0700 Dan Kennedy wrote: > On 06/06/2015 03:19 AM, George wrote: > > Hello everyone, > > > > I am new to the list. I am working on an application in which I > > will be embedding SQLite as the database engine. The application is >

[sqlite] Newbie issue - Linux error malloc.c:2372: sysmalloc: Assertion `(old_top == (((mbinptr) (((char *)

tp://www.ubuntu.com/; SUPPORT_URL="http://help.ubuntu.com/; BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/; I have compiled sqlite.o with the following: gcc -c -Wall -O0 -g -std=c99 -Dlinux -I/usr/local/include sqlite3.c \ -DSQLITE_THREADSAFE=1 -DSQLITE_OMIT_LOAD_EXTENSION -o obj/sqlite3.o Any suggestions or directions greatly appreciated. TIA, George

Re: [sqlite] Mixing journal modes from different threads

Good evening Dr. Hipp, ok, got it. Thank you for the quick clarification. I only asked on the mailing list because I couldn't find this kind of information in the docs (or I didn't look thoroughly enough); if it's the first case, perhaps it should be mentioned somewhere... Thanks again, George

[sqlite] Mixing journal modes from different threads

journalling. I'm using it like that because most of the times I'm using SELECT queries only and I don't want journal files to be created (as it's the case with WAL). Is this the right way of doing it? Thank you, George. ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Adobe Air do not include on sqlite database

On Thu, Jan 2, 2014 at 11:29 PM, Digradi Socobaris wrote: > My app Adobe Air try to save some data in a sqlite 3 database, but the app > when insert a data, it does without problem, but i cant see the data when > browse by the lita or sqlite browser. It look like empty

Re: [sqlite] Inefficient query plan in queries with multiple joins

On Sat, Nov 30, 2013 at 1:55 PM, Richard Hipp wrote: > > If you have a LIMIT 25, then the TEMP B-TREE never holds more than 25 rows, > specifically the top 25 rows seen so far. But SQLite still has to scan > through the entire results set looking for other rows that belong in

[sqlite] Inefficient query plan in queries with multiple joins

I have a query that is used to populate a table in my website. The query joins 4 different tables and returns around 10 columns, and I want to order on 4 of them, each of those 4 being on a different table. I also use a LIMIT clause for pagination. I have noticed that when I order using just one

[sqlite] incredibly minor documentation bug

Don't ask me what use case made me notice this, but the http://www.sqlite.org/lang_corefunc.html documentation for abs(), as of 12:29PM EDT on 10/26/2013, is only about 99.89157978275145% accurate. "If X is the integer -9223372036854775807 then abs(X) throws an integer overflow

Re: [sqlite] rtree value rounding

Shish writes: > The rtree docs say that as well as 2D geometry, it could be used to > index ranges of time - this is what I'm doing, but I've found a > problem and workaround: > > It seems that the indexed values are stored as a small floating-point > value, and thus large numbers (for

[sqlite] Is database corruption possible when writing from multiple processes?

The webpage [1] mentions that if the sqlite library is linked twice into the same application there is the possibility that the database will be corrupted. Is this also possible when two different processes (each of which has only linked the library once) are accessing the same database? If not,

Re: [sqlite] Curious query plan selection

On 4/16/12, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Apr 16, 2012 at 9:43 AM, George <pinkisntw...@gmail.com> wrote: > >> >> create table if not exists SnapshotsMarketsRunners( >>ID integer primary key, >>SnapshotsI

Re: [sqlite] Curious query plan selection

On 4/16/12, Richard Hipp wrote: > Hard to say why, without knowing your schema. Here is the schema: create table if not exists Errors( ID integer primary key, Timestamp text not null, ErrorCode text, Name text, RequestName text,

[sqlite] Curious query plan selection

Compare the following two queries and their query plans: 1) explain query plan select * from snapshotsmarketsrunners where marketsru nnersid in (1); 0|0|0|SEARCH TABLE snapshotsmarketsrunners USING INDEX SnapshotsMarketsRunnersMa rketsRunnersIDSnapshotsID (MarketsRunnersID=?) (~10 rows)

Re: [sqlite] Diacritics handling in FTS with a custom tokenizer

input. But I can live with that, as long as searching works with *and* without diacritics. Thanks again, George. On Wed, Feb 8, 2012 at 8:30 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 02/09/2012 12:49 AM, George Ionescu wrote: > >> Hello Dan, >> >> yes, I

Re: [sqlite] Diacritics handling in FTS with a custom tokenizer

Hello Dan, yes, I thought of that. But wouldn't this break the snippet's function? If the tokenizer will return text without diacritics, wouldn't the snippet return the same? Thanks, George. 2012/2/8 Dan Kennedy <danielk1...@gmail.com> > On 02/08/2012 11:34 PM, George Ionescu wrote: &

[sqlite] Diacritics handling in FTS with a custom tokenizer

/sevkin/snowball_fts3 Thank you, George. PS: Other FTS engines (e.g. DTSearch/Sphinx) handle this: you can index text with diacritics and search with or without them. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

Re: [sqlite] Testing PRAGMA integrity_check functionality

Thanks for the suggestion and the link. On Fri, Dec 2, 2011 at 11:49 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 02/12/11 06:44, George Eckert wrote: > > Does anyone know of a "good" way t

[sqlite] Testing PRAGMA integrity_check functionality

Does anyone know of a "good" way to forfce an error in a database so that PRAGMA integrity_check would produce an error? Thanks, George Eckert ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listi

Re: [sqlite] Adobe Air - Using SQLite db, cannot "UPDATE" nor "INSERT"

It may make little REAL difference, but the SELECT statement you show does not have a semicolon at the end, but the INSERT statement does. Perhaps the error returned is misleading? -- George Eckert On Tuesday, November 15, 2011 at 6:09 PM, BertD wrote: > > Hello all, > &

[sqlite] SQLITE_FCNTL_CHUNK_SIZE + wal files

Is there a way to make the wal files honor the chunk size specified by sqlite3_file_control and SQLITE_FCNTL_CHUNK_SIZE ? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [OT] Re: Tool for database designer

On 9/19/2011 1:24 PM, Petite Abeille wrote: On Sep 19, 2011, at 7:02 PM, George Brink wrote: You can use PowerDesigner Trivia #1: PowerDesigner download weights 390 MB. This compares to 1.4 MB for SQLite. By weight, PowerDesigner does not provide 390 times the value of SQLite. Trivia #2

Re: [sqlite] Tool for database designer

On 9/19/2011 1:13 AM, Madhan Kumar wrote: I want to design the table structure and create scripts with a database designer Do we have any tool(Free or cost) for Sqlite to design the tables, similar like powerdesigner. You can use PowerDesigner, just select 'ANSI Level 2' for DBMS.

Re: [sqlite] error:library routine out of sequence

Yes, q.finalize() should close the previous query. But that is not the point here. All query objects are build upon the same resource (database connection). This resource cannot be shared between two queries. They have to be created and killed sequentially. CppSQLite3Query q1=

[sqlite] fts3 table name cannot be the same as column name

I think this is a bug... If you trying to create FTS3/FTS4 table, make sure that column name in FTS table is not the same as the table name. C:\Projects>sqlite3 aaa SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create

[sqlite] cannot compile SQLite 3.7.7.1 with ICU 4.8.1 on windows

Environment: Windows XP, MinGW+MSYS ICU configured with: sh runConfigureICU MinGW --enable-static --enable-shared make && make install Produces several libraries (both static and shared). Attempting to compile sqlite-amalgamation-3070701: gcc -osqlite3 sqlite3.c shell.c

Re: [sqlite] SQLITE return codes for insert/delete/update/select

On 5/11/2011 3:52 PM, cricketfan wrote: > > I dont know if it is just me but I find the return codes for SQL operation > quite confusing. I am new to SQLITE, have learnt a few things and wanted to > know if going in the correct direction, You are thinking in the wrong direction. SQLITE_DONE means

Re: [sqlite] Merry Christmas

+1 = 4 -- The days of good English has went. -- We can either use our money to serve God or our god will be our money. On Dec 25, 2010, at 7:48, "Guy \(Hotmail\)" wrote: > +1 = 3 > > -Original Message- > From: TR Shaw > Sent: Saturday, December 25, 2010

Re: [sqlite] beginner

more thing: there is an iPod Touch app which is a fully- functioning SQLite console and instructions. Awesome. George R. -- The days of good English has went. -- We can either use our money to serve God or our god will be our money. On Dec 17, 2010, at 10:01, "Jay A. Kreibich" &l

Re: [sqlite] Inserting data using a compound SELECT

or your reples! This list has been very helpful and educational! George R. Igor Tandetnik wrote: > Drake Wilson <dr...@begriffli.ch> wrote: > >> INSERT INTO "cast" (titleID, castID) >>((SELECT titleID FROM titles WHERE title = 'Alien'), >> (SELE

Re: [sqlite] Inserting data using a compound SELECT

Ah, yes, I'm sorry: I mistyped. I have "titleID" and "artistID" in that table. Puneet Kishor wrote: > > > George Roberge wrote: >> Greetings, all. >> >> I'm having trouble getting an insert statement to function properly, and >> am no

[sqlite] Inserting data using a compound SELECT

If this can't be done I suppose I could add one value as a SELECT statement, then try to locate that row in the table and do an UPDATE to the other column (in this case, the cast column) where I just inserted the data. Thank you! George R. -- www.andforthelamb.org www.outreachhockey.org

[sqlite] Composite Foreign Key constraint fails when it should not.

pens often. Thanks! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sql api for ufs

. Not sure how I could roll their products into my developments.... Thanks, Cheers, George ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sql api for ufs

s there any obvious limitation or complexity I'm missing? I welcome comments off line or to either of the lists I'm posting to (but please not both). -George ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Composite Foreign Key not enforced

> Fixed. See http://www.sqlite.org/src/info/dd08e5a988 and http://www.sqlite.org/src/info/636f86095e Gee! That was super FAST! Thanks a lot! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-

Re: [sqlite] Composite Foreign Key not enforced

. I was please to see that SQLite3 was 2.5 faster than MS SQL Compact. And it is on pair with MS SQL Express (i.e. same speed). But SQLite3 is not restricted to 4Gig database! And it is much much easier to install than MS SQL Express/Server. Cool! I like it very much! Bye bye George Somer

Re: [sqlite] Composite Foreign Key not enforced

s enforced while doing INSERT, but not while doing DELETE! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Composite Foreign Key not enforced

tid = 1; SELECT * FROM artist; Is there something I am doing wrong? Thanks! George Somers ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite files and locking on Lustre filesystems.

My computing environment at work is bringing a new cluster online, in addition to some local storage there will be shared access to SAN style storage using the Lustre filesystem. My reading about Lustre tells me that it supports POSIX semantics, including flock and lockf (although they must be

Re: [sqlite] SQLite server for Windows/Linux?

did you try www.SQLitening.com Gilles Ganault-3 wrote: > > Hello > > I know that SQLite is meant as a server-less, file server-based > solution, but... since Richard Hipp has also written a single-EXE SCM > solution (www.fossil-scm.org), I wanted to check if someone had > recently written a

Re: [sqlite] Imprecise entry into rtree

Igor Tandetnik writes: > Steve Lianoglou wrote: > > So I'm building a db with some RTree indices to store genome > > information. Among other things, I have an RTree index to store the > > start/end positions of genes on chromosomes. The problem is that the > > numbers stored in the RTree

Re: [sqlite] rtree's rounding some integer values but not others.

George Hartzell writes: > I've reduced a problem that I'm having to the following test case. > > I insert two rows into an rtree table. In the first case when I > select chromStart and chromEnd I get the same values as I inserted. > In the second case the chromEnd is 1 grea

[sqlite] rtree's rounding some integer values but not others.

I've reduced a problem that I'm having to the following test case. I insert two rows into an rtree table. In the first case when I select chromStart and chromEnd I get the same values as I inserted. In the second case the chromEnd is 1 greater than what I inserted. In the third case chromStart

Re: [sqlite] How to get started SQLite Encryption Extensions(SEE) in SQLite

Simon Slavin writes: > On 4 Oct 2009, at 3:08am, Andi Suhandi wrote: > > > Since SQLite support C++, I have to ask these questions > > You could ask somewhere else. > > SQLite supports C. It does not support C++, it just doesn't violate > it. There is nothing in SQLite that takes

[sqlite] build db in memory then dump to a persistent file.

Hi all, I use an SQLite database w/ the rtree extension to hold information about genetic polymorphism (snp's), based on UCSC's mapping work and their mysql table dumps. My database is write-once, read from then on. One of the tables has almost 19 million rows. This is the table on which I

Re: [sqlite] SQLite JDBC - org.sqlite.NativeDB.step taking up too much time

This makes a lot of sense now - I haven't read up on the C interface and assumed that "step" was a JDBC thing. Thanks for clearing that up. George. On 09/26/2009 01:01 AM, Pavel Ivanov wrote: >> Does anyone know why this method might be so expensive? >> >

[sqlite] SQLite JDBC - org.sqlite.NativeDB.step taking up too much time

ret = new SQLVal(val); } } Thanks for any help. George. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite profiler

in between "EXPLAIN" and "EXPLAIN QUERY PLAN" would be great for my needs. George. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Undesired query plan when using GROUP BY

Y PLAN['s] behavior is undocumented, unspecified, and variable" - should I just ignore the numbers shown in the query plan, or could they be useful for my understanding of what sqlite is doing? Thanks, George. ___ sqlite-users mailing list sqlite-use

Re: [sqlite] SQLITE_BUSY question

Oops, I RTFMed poorly. Thanks for the help. :-) Dennis Cote wrote: > George Ryan wrote: > >> Hello. I'm a first-time sqlite user, and I have a question. I'm using >> the C/C++ API as shown in the code below, and the sqlite3_step() >> function always seems to return

Re: [sqlite] SQLITE_BUSY question

Nope, it's a local ext3 filesystem. D. Richard Hipp wrote: > On Jul 9, 2008, at 11:00 AM, George Ryan wrote: > > >> Hello. I'm a first-time sqlite user, and I have a question. I'm using >> the C/C++ API as shown in the code below, and the sqlite3_step() >> func

[sqlite] SQLITE_BUSY question

y.c_str(), query.size(), , 0 ); if ( rc ) { cout << "failed to create statement" << endl; sqlite3_close( db_ ); return EXIT_FAILURE; } rc = sqlite3_step( stmt ); cout << "step returned " << rc << endl; sqlite3_finaliz

[sqlite] User defined functions naming problem

Hello dear sqlite users, Hello dr. Hipp, I'm trying to create a user-defined function having the name LEFT but that does not seem to work (I get an sql parsing error). All is fine if I rename it to STRLEFT, but I'd stick to the first one since I'd like to add some compatibility with other db

[sqlite] Enabling recursive triggers

1 set updcnt=updcnt+1; end sqlite> select * from t1; 1|a|2 sqlite> update t1 set intcol=1; Segmentation fault Advice on how to pursue enabling recursion? My C is rusty. I prefer Linux but also run Windows. TIA, George Herson <1>http://marc.theaimsgroup.com/?l=sqlite-users=2=1=recurs

Re: [sqlite] table persistance (newbie)

warning, readers: the below is boring. I'm just following up. --- Rich Shepard <[EMAIL PROTECTED]> wrote: > On Sun, 1 Oct 2006, George Herson wrote: > > > It seems to me that > http://www.sqlite.org/lang_createtable.html should > > mention the ramifications of not p

Re: [sqlite] table persistance (newbie)

Thanks for the info, Rich Shepard and Jan Kandziora. 3 documention-related suggestions about this: It seems to me that http://www.sqlite.org/lang_createtable.html should mention the ramifications of not passing in a database name when using the sqlite3 executable. the executable should confirm

[sqlite] table persistance (newbie)

turned out my pockets, checked a few directories, and found no tables (except an empty sqlite_master). Did I in fact lose the tables? How do I save next time? TIA, George - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: SQLite vs MS Access

(accessed via ADO) and SQLiteDb. Accessing sqlite via ODBC is an option. However, the ADO dependecy you're stuck with is something that should be avoided. Regards, George Ionescu - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: AW: AW: Re: spatial sqlite anyone ?

-style notation for storing my gis elements. George.

[sqlite] Re: spatial sqlite anyone ?

of doing readers/writers. This way, if anyone needs to work with a special format he/she could write it if it doesn't exist. I'm saying that because, for example, I've chosen to use an SVG-style notation for storing my gis elements. George

[sqlite] Re: spatial sqlite anyone ?

is CGAL (http://www.cgal.org/). I didn't benchmarked it mostly because GEOS suited my needs just fine, but how knows, it might be better than the ones I mentioned. George.

RE: [sqlite] Vacuum Command

: [sqlite] Vacuum Command I am new to SQLITE but in some other database vacuum want to have full controll test with Transaction as BEGIN EXCLUSIVE TRANSACTION test VACUUM [tableName] END TRANSACTION test // Anders George Mavroudes skrev: > Sorry for the omission and thanks for the qu

RE: [sqlite] Vacuum Command

] and then execute the VACUUM command, will this temporarily delete the table (causing a SCHEMA_CHANGE) and then add this table back into the db? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 10:08 AM To: George Mavroudes Subject: Re

[sqlite] Vacuum Command

hi, - I am pretty new to SQLITE and I am having a problem with the following sequence of commands: - DELETE FROM [tableName] - VACUUM [tableName] The project I am working on has multiple threads Reading / Writing to this table and other tables, and after

[sqlite] Problems running the Lemon parser to generate parse.c and parse.h

ed parse.c is different from the one in official distribution (using v3.2.7). Is there something I'm doing wrong here? Thanks. George.

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

uch. I didn't want to start a riot... Thanks again. George.

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

d to SQL Server and MySQL. And I don't really think I'm asking much: all I want is that when I ask for Field1 column, the database engine to report Field1 and not FIELD1. Do you think this is a stupid think to ask? Thanks again. George.

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

/cvstrac/wiki?p=ColumnNames) created by Dr. Hipp. It can be found at: http://www.sqlite.org/cvstrac/attach_get/167/ColumnNames.htm George.

[sqlite] RDBMS handling of column names (was: Trouble with column names)

it.   Thanks. George.

Re: Re: [sqlite] Trouble with column names

>>notice the uppercase F from Field1, although field1 is requested. >>So, it seems that sqlite returns column names as defined in schema, not as >>requested by the user. This may not seem a big problem, but it becomes one >>when working with columns and trying to refer them by name and not

[sqlite] Trouble with column names

Hello Dr. Hipp, Hello dear sqlite users, while working with sqlite v3.2.1, I've noticed another annoyance in the way sqlite returns column names (besides the bug with #1141, duplicated as #1218). Using sqlite command line, enter the following: sqlite3 test.db create table test(Field1

Re: [sqlite] HEllo All

Hello Gupta, depending on the platform you're using, you could try our SQLiteDb (ActiveX COM Wrapper) which support on-the-fly database encryption. (search for it at http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers) Best regards, George Ionescu

[sqlite] Bug from ticket 1141 breaks existing applications

an easy one), since it breaks existing applications. Thanks. Regards. George Ionescu. _ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

[sqlite] Very slow and blocking SELECT query

was really expecting to be able to make changes to the database while SELECT queries are executing... I'm using version sqlite command-line v3.1.1 beta. Thanks. George Ionescu.

Re: [sqlite] ODBC ADO

: you can have a whole database engine by delivering a single file to the client. Best regards, George Ionescu

Re: [sqlite] db admin tool

Hello sten, you could try SQLiteDb Query Analyzer from http://www.terrainformatica.com/sqlitedb (it's included in the SQLiteDb install package). It's not much right now but it's going to be improved alot in the next weeks. Best regards, George Ionescu

Re: [sqlite] db admin tool

Hello sten, you could try SQLiteDb Query Analyzer from http://www.terrainformatica.com/sqlitedb (it's included in the SQLiteDb install package). It's not much right now but it's going to be improved alot in the next weeks. Best regards, George Ionescu

Re: [sqlite] Legal to use sqlite docs in commercial applications ?

ibuted to the documentation. Thanks. How can I distinguish between *your* documentations and everyone else's ? Regards, George Ionescu

[sqlite] Legal to use sqlite docs in commercial applications ?

Hello Dr. Hipp, Hello sqlite users, I would like to know if it's legal to use sqlite documentation (sql syntax, sqlite logo etc.) into commercial applications' documentation (which are obviously built on top of sqlite). Thanks. Regards, George Ionescu

[sqlite] Legal to use sqlite docs in commercial applications?

Hello Dr. Hipp, Hello sqlite users, I would like to know if it's legal to use sqlite documentation (sql syntax, sqlite logo etc.) into commercial applications' documentation (which are obviously built on top of sqlite). Thanks. Regards, George Ionescu

[sqlite] Anyone knows any sqlite based bullettin board ?

Hello Dr. Hipp, hello sqlite users, I'm looking for an sqlite-based bulletin board to run under linux. Any recommendations? Thanks. Regards, George Ionescu

[sqlite] Re: Bug with sqlite3_column_decltype?

to tell sqlite myself the each column's affinity. And, according to the docs, the syntax I'm using is supported. Regards, George Ionescu _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.com/

[sqlite] Bug with sqlite3_column_decltype?

(results are as expected). However, when I ask for first column's type with sqlite3_column_decltype, the result I get is: AFFINITYINT,[Cu I'm using v3.0.7 Any ideas? Regards, George Ionescu

Re: [sqlite] SQLITE_ERROR instead of SQLITE_FULL

g: don't you think that "you're disk is full" is more correct than "sql error or missing database"? Since there's really no sql error and the database is still there. Regards, George Ionescu

[sqlite] SQLITE_ERROR instead of SQLITE_FULL

free space on C: (the location where was the database). So, my question is this: if sqlite cannot insert data into the database because it doesn't have enough free space, shouldn't it return SQLITE_FULL insted of SQLITE_ERROR ? Regards, George Ionescu

[sqlite] Encrypting data stored in database

string' but, when the sqlite database is opened in a file viewer, 'some string' would not be visible but only it's encrypted form. Regards, George Ionescu

  1   2   >