Re: [sqlite] Using SQLite with R*Tree and FTS3 support in iOS

4.3 MB seems really too big... you are probably building a debug version of the library. -- Marco Bambini http://www.sqlabs.com On May 16, 2011, at 5:01 PM, Tito Ciuro wrote: > Hello, > > I have a question about SQLite running on iOS. If I'm not mistaken, SQLite on > iOS is

Re: [sqlite] vacuum and rowids

Dave please take a look at this blog post: http://www.sqlabs.com/blog/?p=51 -- Marco Bambini http://www.sqlabs.com On Apr 28, 2011, at 9:36 PM, Dave Hayden wrote: > When the VACUUM feature was added I took a look at using it to keep database > file sizes down, but disc

[sqlite] Disable lock controls on Windows

he locking method from myself using a semaphone file. Any suggest ? Thanks in advance. Regards, Marco Turco IT Business Devl Manager Software XP LLP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailma

Re: [sqlite] Help with a query

Thanks a lot Simon and Robert. -- Marco Bambini http://www.sqlabs.com On Mar 4, 2011, at 11:50 AM, Robert Hairgrove wrote: > On Fri, 2011-03-04 at 11:10 +0100, Marco Bambini wrote: >> Hello, >> I have a table defined as: >> CREATE TABLE MKProperties (id INTEGER PRIM

[sqlite] Help with a query

2 PARENTID0 2 RESOURCE_ORDER 1 3 PARENTID0 3 RESOURCE_ORDER 3 I need a query that returns all the obj_id with prop_key='PARENTID' AND prop_value='0' but ordered by prop_value WHERE prop_key='RESOURCE_ORDER'. Any help? -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] memory used by sqlite library

Michele take a look at the sqlite3_status function: http://www.sqlite.org/c3ref/status.html and http://www.sqlite.org/c3ref/c_status_malloc_count.html -- Marco Bambini http://www.sqlabs.com On Feb 25, 2011, at 2:17 PM, Michele Pradella wrote: > Do you know if is there a way to

Re: [sqlite] Query help

simple queries is a better approach for the maintainability of the project. Thanks a lot for your advices. -- Marco Bambini http://www.sqlabs.com On Feb 2, 2011, at 8:11 PM, Igor Tandetnik wrote: > On 2/2/2011 11:16 AM, Marco Bambini wrote: >> your query returns 3 columns, but I

Re: [sqlite] Query help

) and MKProperties contains (1,1,NAME,About Box) and (2,1,WIDTH,200) the result of the query should should be: col1col2 'ID'1 'NAME' 'About Box' 'WIDTH', '200' -- Marco Bambini http://www.sqlabs.com On Feb 2, 2011, at 1:43 PM, Igor Tandetnik wrote: > Marco Bambini <ma...@sqlabs.net&

[sqlite] Query help

using 3 select statements). Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite and windows server 2008 DFS

Hi, any experience using an sqlite db on Windows server 2008 with DFS enabled ? A customer with this configuration reported me that there is a lost of data. Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

[sqlite] TEMP TRIGGER and SQLITE_OMIT_TEMPDB

I recompile sqlite without the SQLITE_OMIT_TEMPDB macro. Anyone can confirm my assumption? Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] CREATE TEMP TRIGGER

Where I can find more information about TEMP TRIGGERs? In the official page: http://www.sqlite.org/lang_createtrigger.html there is no mention about the TEMP clause. Thanks. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list

[sqlite] [ANN] SQLiteConverter

have full control over the conversion process, you can decide to convert the entire database or just select the individual tables you want to backup. More information available from: http://www.sqlabs.com/sqliteconverter.php -- Marco Bambini http://www.sqlabs.com

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

manage a text search into the db using a select but I need to read all data , decrypt it and then make the text search, for this reason a low level cryptation would be better in my case. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org

Re: [sqlite] assert crash in wal

Try to add: -DSQLITE_THREADSAFE =1 to your compilation options. -- Marco Bambini http://www.sqlabs.com On Dec 15, 2010, at 2:34 PM, Yoni Londner wrote: > Hi, > > I wrote a little program that insert in a loop rows in to the DB, and in > another thread run wal_checkpoint.

[sqlite] How to disable locking method on Sqlite (window)

in a MacOSX + Wine due to the fact that the application runs in a Windows like environment. Any ideas to disable the internal Sqlite locking method on a Window app ? Thanks in advance Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] R: R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

Hi, tried but unfortunately it doesn't runs. The window application running under Wine hasn't direct access to the absolute path. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per conto di Sylvain Pointeau Inviato: domenica 12

[sqlite] R: R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

ould have the same problem. However, if you want to see how to mount that drive from the command-line on a Mac, type 'man mount_smbfs'. Tried. Unfortunately seems that the "nobrl" option is not available. Gr... Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [

[sqlite] R: R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

ail-archive.com/sqlite-users@sqlite.org/msg20409.html anyway I am not sure this parameter is supported on Mac Os X mount command but I am not an expert in Mac & Unix Os. Any ideas ? Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlit

[sqlite] R: Lock problem opening a Sqlite db on a Samba/CIFS shared disk

of product there isn't an high concurrency in writing and tracking the locks it appears that only 4-5 locks/day for just 0.3 seconds each one executed on these bigger network. Marco -Messaggio originale- Da: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] Per

[sqlite] Lock problem opening a Sqlite db on a Samba/CIFS shared disk

support the Samba/CIFS disk with reference to the locking system. I am really in trouble because I have more than 50 customers with mixed network (Windows/Mac OS X) having this problem in the next future. Any ideas or turn-around to solve this problem ? Thanks in advance Marco Turco

Re: [sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

I just tried it on my Mac and this new build works pretty well. Thanks a lot for your assistance. -- Marco Bambini http://www.sqlabs.com On Dec 8, 2010, at 1:54 AM, Richard Hipp wrote: > In Tue, Dec 7, 2010 at 7:15 PM, Richard Hipp <d...@sqlite.org> wrote: >> On Tue, Dec 7,

[sqlite] sqlite3_analyzer issue on MacOS X 10.6.5

Running sqlite3_analyzer on a MacOS X 10.6.5 results in the following issue: dyld: Library not loaded: /usr/local/lib/libtcl8.6.dylib Referenced from: /Users/marco/Desktop/sqlite3_analyzer Reason: image not found Trace/BPT trap Seems like a broken binary to me. Any idea? -- Marco Bambini http

[sqlite] Date/Time query help

starting from now (in localtime). Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Database corrupted

Hello, I'm doing some tests to get the best out of the threading models for sqlite. All tests are done on a multicore processor, windows XP; sqlite is working in WAL mode. I've got a database image corrupted when using SQLITE_THREADSAFE=2 and two threads, each opening a private connection to

[sqlite] WAL mode and backup API

Hello, if a running sqlite database is in WAL mode and a backup is performed on that db using the sqlite3_backup API, does that process is considered like a reader and can proceed concurrently with other readers and with the other writer? Thanks a lot for your answer. -- Marco Bambini http

[sqlite] [ANN] SQLiteConverter



 A SQLiteConverter single license is $49 USD. Company and multiplatform licenses are also available. For more information, please visit the SQLabs website. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

[sqlite] DELETE with 64bit unsigned integer key

lve this issue? Thank you, Marco ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Strange error

onstraints -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [ANN] SQLiteManager 3.5

-- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_column_name

Unfortunately I cannot modify the query... it is supplied by an user. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Nov 13, 2009, at 3:10 PM, Virgilio Fornazin wrote: > SELECT > field as NAME > > does not work? > > On Fri, Nov 13, 20

[sqlite] sqlite3_column_name

sqlite 3.6.19 CREATE TABLE foo (col1 INTEGER PRIMARY KEY, col2 TEXT); a SELECT rowid, col1, col2 returns the following column names with sqlite3_column_name: col1, col1, col2 Is there a way to force the first column name to be returned as rowid and not as its col1 alias? Thanks. -- Marco

Re: [sqlite] Viewer for blobs in hex?

Hello Yan, you could use my SQLiteManager application: http://www.sqlabs.com/sqlitemanager.php Regards, -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Sep 21, 2009, at 9:43 AM, Yan Bertrand wrote: >Hi all, > > > > I would

Re: [sqlite] Explanation

Yes, you are right (as always). Time with SQLITE_THREADSAFE=0 is about 4.33 seconds now. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 28, 2009, at 5:23 PM, D. Richard Hipp wrote: > > On Aug 28, 2009, at 11:17 AM, Mike Eggleston

Re: [sqlite] Explanation

Library is statically linked into the final app and the db is newly created... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 28, 2009, at 5:17 PM, Mike Eggleston wrote: > On Fri, 28 Aug 2009, Marco Bambini might have said: > >> Hello, >&g

[sqlite] Explanation

possible explanation? Thanks. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] translating CSV file into sqlite3 database for iPhone?

Have you tried my SQLiteManager app? http://www.sqlabs.com/sqlitemanager.php It can easily convert/import your CSV file into an sqlite3 database. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Aug 7, 2009, at 4:57 PM, Adam DeVita wrote: > This is wh

[sqlite] [ANN] SQLiteManager 3.0

VIADANA, Italy (June 24, 2009) - SQLabs is proud to announce today the worldwide availability of SQLiteManager 3.0, the most powerful sqlite database manager tool for MacOS X and Windows. SQLiteManager is a "next generation" GUI database manager for sqlite databases. It combines an

Re: [sqlite] Why row is not found?

Hello Martin, it's a db than an user sent me... so I really don't know... -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:31 AM, Martin Engelschalk wrote: > Hi Marco, > > How do you insert this data into your database? > I

Re: [sqlite] Why row is not found?

I understand that the issue could be caused by the wrong datatype... but what is strange is that the same db and the same query worked fine with sqlite 3.4.2 and the behavior changed with sqlite 3.6.x -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5

Re: [sqlite] Why row is not found?

I just posted the db on my website... there is one row and there aren't invisible characters. Please note that the following query returns the exact row: SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin'; but I really don't have an explanation... -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] Why row is not found?

You can download the db from: http://www.sqlabs.com/download/test.sqlite It's only 4KB. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:04 AM, Marco Bambini wrote: > Anyone can please explain me why this query: > SELECT * FROM lo_user

[sqlite] Why row is not found?

Anyone can please explain me why this query: SELECT * FROM lo_user WHERE lo_name='admin'; returns 0 rows in this db? Thanks. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users

Re: [sqlite] most efficient way to get 1st row

SELECT ... LIMIT 1; -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On May 19, 2009, at 5:03 PM, Sam Carleton wrote: > I am far from a SQL expert, but I am 99.9% sure there is SQL syntax > to limit > the number of results, I have not looked it

Re: [sqlite] SQL logic error or missing database

Thanks a lot for the explanation Igor. -- Marco Bambini On May 14, 2009, at 1:55 PM, Igor Tandetnik wrote: > "Marco Bambini" <ma...@sqlabs.net> wrote > in message news:aa7dd05f-4679-43dd-9dd3-2ba6b98af...@sqlabs.net >> I have two threads that are writin

[sqlite] SQL logic error or missing database

rror or missing database (printed with sqlite3_errmsg). Any explanation of the possible causes for the missed rows? Thanks. -- Marco Bambini ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Query takes ages

nneau Integer ); CREATE TABLE typeformats (id_typeFormat Integer NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE, format VarChar NOT NULL ); Can someone suggest me the best index/indexes to use for such a query? or the best way to rewrite it in a way more manageable by sqlite? I really appreciate your

Re: [sqlite] Memory Usage

SQLITE_STATUS_PARSER_STACK current: 0 high: 0 2009-04-21 15:24:25 SQLITE_STATUS_PAGECACHE_SIZE current: 0 high: 0 2009-04-21 15:24:25 SQLITE_STATUS_SCRATCH_SIZE current: 4480 high: 6664 -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Apr 21, 2009, at 3:12 PM, D

Re: [sqlite] Memory Usage

The database is on-disk ... does huge not committed transactions uses memory? -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Apr 21, 2009, at 2:27 PM, D. Richard Hipp wrote: > > On Apr 21, 2009, at 8:22 AM, Marco Bambini wrote: > >>

Re: [sqlite] Memory Usage

Yes, executing sqlite3_memory_used () after 183,000 INSERT statement returns: 106,766,848. Database is never closed during application lifetime. Each statement is prepared, stepped and properly finalized. P.S. the database is encrypted using your modules. -- Marco Bambini http://www.sqlabs.com

[sqlite] Memory Usage

PRAGMA cache_size with no luck ... I tried also to recompile with SQLITE_ENABLE_MEMORY_MANAGMENT and use sqlite3_soft_heap_limit but nothing seems to change. Please help. Thanks. -- Marco Bambini ___ sqlite-users mailing list sqlite-users

[sqlite] Memory usage

as possible (memory usage was much lower with version 3.2.1 for example) ... so, how can keep memory usage low or to a limit similar to the old versions? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield

[sqlite] Query help

appreciate any help. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_THREADSAFE=1 and in-memory databases

-memory db in a multithreaded environment and they must be unique. Any help would be really appreciate. Thanks. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlit

Re: [sqlite] SQLite version 3.6.11

What about backup of encrypted databases? -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Feb 18, 2009, at 1:28 AM, D. Richard Hipp wrote: > SQLite version 3.6.11 is now available from the SQLite website: > > http://www.sqlite.org/ > > Vers

Re: [sqlite] Transaction within script

Is there any documentation available about savepoints? -- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 2, 2009, at 2:19 AM, D. Richard Hipp wrote: > > On Jan 1, 2009, at 7:25 PM, Igor Tandetnik wrote: > >>

Re: [sqlite] Transactions on attached databases

It's a very useful API, thanks a lot. -- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Dec 12, 2008, at 5:26 PM, D. Richard Hipp wrote: > > On Dec 12, 2008, at 11:16 AM, Marco Bambini wrote: > >> I have two databas

[sqlite] Transactions on attached databases

ike to know if db1 seems a db with write operations from sqlite's point of view)... and should the transaction be started on db2 or it doesn't matter when the two dbs are attached? Thanks a lot for the clarifications. -- Marco Bambini ___ sqlite-users m

[sqlite] Why SQLITE_LOCKED here?

... but sometimes it still occurs. Any idea of the reason of the error? Any idea about how to solve the issue without using the sqlite3_busy_handler or sqlite3_busy_timeout functions? Thanks a lot for the clarifications. -- Marco Bambini ___ sqlite-users

Re: [sqlite] Unable to compile fts2 as loadable extension

Yes I know and fts3 is enabled by default but I need to be able to load fts2 as an external extension for legacy support. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 8, 2008, at 6:15 AM, Alexandre Courbot wrote: >

[sqlite] Unable to compile fts2 as loadable extension

sqlite3_api_routines *sqlite3_api; in fts2_tokenizer.c. But now the linked reports missing sqlite3_malloc, sqlite3_free, sqlite3_realloc symbols. Do I have to link with sqlite3.c or I should just write some wrapper functions? Can fts2 be compiled as an external loadable extension? --- Marco Bambini http

Re: [sqlite] Virtual tables

the name of all the tables (not virtual) created inside the db (save their names somewhere) - and at the end copy all the tables whose name was not previously saved I wondering if is there a simpler/better solution... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

Re: [sqlite] Virtual tables

Yes but creating a virtual tables involves the creations of other related tables ... does all the virtual table implementations (fts1, fts2, fts3) follow the same schema or it is implementation dependent? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

[sqlite] Virtual tables

What is the best way to identify virtual tables inside a sqlite database? Thanks a lot. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLITE_CORE use for ??

Thanks a lot for the clarification. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jul 30, 2008, at 4:28 PM, D. Richard Hipp wrote: > > On Jul 30, 2008, at 10:22 AM, Marco Bambini wrote: > >> Can someone clarify th

Re: [sqlite] SQLITE_CORE use for ??

Can someone clarify this point please? I mean, if I want to compile sqlite in a way that it should be able to load extensions, SQLITE_CORE could be defined or not? Or if it doesn't matter, what is its role? Thanks. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

Re: [sqlite] Max limits on the following

http://www.sqlite.org/limits.html --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jun 23, 2008, at 8:55 AM, Shailesh Birari wrote: > Hello all, > I wanted to know if there are any upper limits on the following: I > ha

Re: [sqlite] Comparison of SQLite applications for Mac

Please take a look also at my SQLiteManager app: http://www.sqlabs.net/sqlitemanager.php --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On May 8, 2008, at 8:56 AM, Neville Franks wrote: > Hi Hartwig, > The last release for this w

Re: [sqlite] String is changing after inserting into database

Is your database UTF-16 encoded? More information at: http://www.sqlite.org/pragma.html PRAGMA encoding section. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Apr 18, 2008, at 8:37 AM, Harish Dixit wrote: > Hello, >

Re: [sqlite] how to select uncomitted rows?

. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Apr 17, 2008, at 9:43 PM, Alex Katebi wrote: > The reason I did not keep track in a seperate table was because I > wanted to > do it using triggers. But triggers don't trigger unt

Re: [sqlite] Malformed database schema with SQLite version > 3.5.x

Yes, of course I can send you the DB: the file is under 1MB, about 100K if compressed via .zip Can I send it to you via e-mail? Thanks very much for the support ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

it is the Connector or Driver on top of SQLite which determines the actual field type into the component layer of Delphi. This is what the DbExpress driver is supposed to do, translate the database specifics into Delphi specifics (and back). Regards, Marco

Re: [sqlite] Transaction log writing performance

mprovement on MacOS X. So, is safe so to set PRAGMA synchronous=NORMAL; under MacOS X? It would be really nice to know under which modern file system it is safe to skip 3 and 4. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ ___

[sqlite] sqlite 3.5.5 and SQLITE_ENABLE_LOCKING_STYLE=1

It is safe to define SQLITE_ENABLE_LOCKING_STYLE=1 with sqlite 3.5.5 if I am interested in opening database files on a shared volumes on Mac? As far as I know it was the only workaround ... or something is changed in recent versions? Thanks. --- Marco Bambini http://www.sqlabs.net http

Re: [sqlite] Version 3.5.5 Released

What about speed? Can we expect the same performance of version 3.5.4? Thanks a lot for your continue improvements. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 31, 2008, at 6:33 PM, [EMAIL PROTECTED] wrote: SQLite version

Re: [sqlite] Next Version of SQLite

What will be the main benefits of the new virtual machine? I mean, it will be just faster or there will be other improvements in the library? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jan 13, 2008, at 3:07 AM, D. Richard

Re: [sqlite] How to get record count

SELECT count(*) FROM myTable; --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Dec 12, 2007, at 2:55 PM, Tom Parke wrote: How can I get a count of the number of records in a table? Sqlite3_get_table() might work, but I only need

[sqlite] UNION and ORDER BY errors starting from sqlite 3.4.2

are created by: CREATE TABLE a (field); CREATE TABLE b (field); Please note that the above queries worked fine with sqlite 3.2.x or 3.3.x. Any idea? --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

Re: [sqlite] Suggests for improving the SQLite website

I vote for (4). --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Nov 9, 2007, at 7:45 PM, [EMAIL PROTECTED] wrote: "Mark Wyszomierski" <[EMAIL PROTECTED]> wrote: Not a terribly useful comment but was just glancing

Re: [sqlite] Suggests for improving the SQLite website

Another solution is to design your css for standard browser and then just create a iefixes.css file to load only in IE that contains the various fixes for that browser. The trick is to add that lines in the head section: --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

is still 99... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 10:38 PM, Joe Wilson wrote: You're not the least bit interested in finding out what the issue in CodeWarrior was? It might be a symptom of another problem

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

The problem was somewhere inside CodeWarrior because the same exact code worked fine with Visual C. I used CodeWarrior for Win for all my win32 sqlite compilation but it seems time to update my Win Dev environment... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

Hmm ... I was using CodeWarrior for Windows ... maybe its time to upgrade --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 12:14 PM, Dan Petitt wrote: I compiled up your code and ran it on Windows using VC6

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

No, the database is created by the code it doesn't already exists. I was able to reproduce the issue only on Windows, Mac and Linux worked fine. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 31, 2007, at 10:25 AM, Stephan

Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version

lt); // close db sqlite3_close(db); printf("simple test finished!\n"); return 0; abort: printf("%s\n", sqlite3_errmsg(db)); if (db != NULL) sqlite3_close(db); return -1; } On Windows (not on Mac!) it returns 99

Re: [sqlite] Proposed sqlite3_initialize() interface

I think that sqlite3_initialize should be allowed to be called more than once. With the help of a static flag, only the first time it is executed the proper initialize functions will be invoked, successive calls to the sqlite3_initialize should just be a NOP operation... --- Marco Bambini

[sqlite] Strange error in sqlite 3.4.2 Win32 version

b2 = 100 and b3 = 101" ) I wonder if there was a bug in the 3.4.2 version that I should fix... Please note that I cannot upgrade to the latest 3.5.x versions... Thanks a lot. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/

Re: [sqlite] Re: Custom functions and *

Thanks a lot Joe, I'll take a look at that. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Oct 18, 2007, at 7:05 PM, Joe Wilson wrote: --- Marco Bambini <[EMAIL PROTECTED]> wrote: I need to create a custom function that r

Re: [sqlite] Re: Custom functions and *

I need to create a custom function that returns all the value from that row. If the * syntax was supported then I don't need to save or retrieve all the column's name for that table. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver

Re: [sqlite] sqlite3_update_hook

Thanks Dennis for your reply. I would like to avoid triggers for performance reasons. I haven't found an official solution so I am implementing my own sqlite3_update_notify API that is executed before the operation takes place. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net

[sqlite] sqlite3_update_hook

Hi, with sqlite3_update_hook I can get the rowid of the row AFTER it has been INSERTed, DELETEd or UPDATEd. Is there a way to get the rowid of a row BEFORE it is DELETEd or UPDATEd ? If not, can someone suggest a good approach to this problem? Thanks a lot, --- Marco Bambini http

Re: [sqlite] Advice about a trigger

I know John, obviously "sql" should be replaced with a way to get the original sql statement that created that row. My question was is there is some smart way to retrieve it... --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/

[sqlite] Advice about a trigger

, operation) VALUES (old.rowid, "sql", "table1", 1); END The missing field is "sql" ... do you have a smart idea to solve my problem? Thanks. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http:

Re: [sqlite] why a VIEW doesn't contain a ROWID

Hi Kees, He is telling about the Rowid the unique number that represents each row in the table, not about a table column named "ID" or anything else, or the primary key of the table. []'s, Marco Antonio Abreu IT Quality Systems [EMAIL PROTECTED] http://www.itquality.com.br Kees

Re: [sqlite] sqlite versions, binary compatibility

of 3.3.18. []'s, Marco Antonio Abreu IT Quality Systems [EMAIL PROTECTED] http://www.itquality.com.br Ray Kiddy wrote: > > Hello - > > I tried to use an older version of the sqlite3 executable on Mac OS X > with a data file from a newer version. No joy resulted. >

Re: [sqlite] Towards SQLite version 3.5.0

a concept of a NULL pointer. Dennis Cote Just pass 0 in that case. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] incredible slow performance of a trigger

e use some thing like "TEXT(40)". Finally, indexes help queries performances. []'s, Marco Antonio Abreu IT Quality Systems [EMAIL PROTECTED] http://www.itquality.com.br Zlatko Matic wrote: > Hello. > I have terrible performance when executing the following query, which > inserts

Re: [sqlite] Proposed incompatible change to SQLite

We'll be more than happy with a change like that. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Aug 9, 2007, at 5:37 PM, [EMAIL PROTECTED] wrote: We are considering a change to the SQLite API which is technically not backwards

Re: [sqlite] fts2 in the amalgamation source?

works fine and I was able to compile it. Hope this help. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ http://www.sqlabs.net/realsqlserver/ On Jul 26, 2007, at 4:41 PM, [EMAIL PROTECTED] wrote: "David Crawshaw" <[EMAIL PROTECTED]> wrote: Hello all,

Re: [sqlite] Get the data from previous months: please, help me to optimize the query...

a in 200ms, that is really good (compared to the one before). Thanks again Marco 2007/7/13, Joe Wilson <[EMAIL PROTECTED]>: --- Christian Smith <[EMAIL PROTECTED]> wrote: > > Much faster - add 3 new fields in CustomerData which you can populate > > via SQLite's trigge

<    1   2   3   >