[sqlite] Select statement with ORDER BY specified by column value

: SELECT prop_value FROM Table1 WHERE obj_id=10 AND prop_key='key1' AND (prop_tag='ios' OR prop_tag='*') ORDER BY (prop_tag='ios') LIMIT 1; I would like to prioritise results based on the fact that the prop_tag column is 'ios'. Thanks. -- Marco Bambini https://www.sqlabs.com

[sqlite] A parser for sqlite databases to implement full ALTER TABLE support

More info at: https://github.com/marcobambini/sqlite-createtable-parser -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman

Re: [sqlite] what is server-process-edition?

So it has nothing to do with which table/row the transaction is modifying? In your example connection 2 always returns with an error on COMMIT? Seems like the improvement is only on when the error occurs and not on concurrency or am I missing something? -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] what is server-process-edition?

Is there a better formal description about the "transactions may not overlap" sentence? Is there any example about overlapping transactions? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs >> The begin-concurrent branch >> (https://sqlite.org/src/timel

[sqlite] sqlite server-process-edition and begin-concurrent

server-process-edition would be a better option for my case but is the branch still maintained and updated? Are the branches mutually exclusive or can be used both in the same process? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs

Re: [sqlite] Lazy virtual table creation

Philippe, with a bit of work you can use the authorize api in order to know when an access to a non existing table is performed. https://sqlite.org/c3ref/set_authorizer.html Hope this helps. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs > On 17 Mar 2018, at 15:53, Phili

[sqlite] Dynamically load all the sqlite functions

with dlsym and once done call dlclose. I noticed that all function prototypes are already defined inside sqlite3ext.h but I wondering if there is a function I could use to all the symbols from the lib without manually process all the function names. Any clue? Thanks. -- Marco Bambini

Re: [sqlite] Testing sqlite db to see if exists & ready

Seems like a good reason to introduce a way to query the existence of a particular pragma command, something like: PRAGMA exists('user_version'); or PRAGMA exists='user_version'; -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 6 Apr 2017, at

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

You could just filter by screen size instead of user agent. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 06 Sep 2016, at 14:26, Richard Hipp <d...@sqlite.org> wrote: > > On 9/6/16, Nelson, Erik - 2 <erik.l.nel...@bankof

[sqlite] CREATE TABLE parser

> On 02 Mar 2016, at 13:32, Luca Ferrari wrote: > > On Wed, Mar 2, 2016 at 1:10 PM, Marco Bambini wrote: >> I developed the parser myself. > > Great job but...what is the aim? > Why one should use this instead of, let's say, Perl SQL::Parser > <http://search.c

[sqlite] CREATE TABLE parser

I developed the parser myself. Here you go a link to the GitHub page: https://github.com/marcobambini/sqlite-createtable-parser -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 02 Mar 2016, at 11:50, Clemens Ladisch wrote: > > Marc

[sqlite] CREATE TABLE parser

can send me or help me find out some CREATE TABLE sql statements to add to my internal tests? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] System.Data.SQLite encryption

Anyone know which encryption algorithm is used in System.Data.SQLite? Seems like it doesn?t use the standard SEE sqlite extension. Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] sqlite3session

Is the sqlite3session module still available and supported? If not is there a replacement/workaround for it? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] Epoch time with timestamp in ms

sqlite to interpret timestamp in ms? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] sqlitediff

, nor a link to download the executable from http://www.sqlite.org/sqldiff.html <http://www.sqlite.org/sqldiff.html>. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs > On 24 May 2015, at 08:59, Luuk wrote: > > On 24-5-2015 08:39

[sqlite] sqlitediff

Where can I download sqlitediff and its source code? Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] Query help

to replace groupname with * if groupid is 0. Please note that groupid 0 is never written into the Groups table so my original query would return NULL as groupname with groupid is 0 instead of the required "*". Any idea? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://ins

Re: [sqlite] WITHOUT ROWID option

Thanks a lot Richard, I really appreciate. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs On 07 May 2014, at 16:31, Richard Hipp <d...@sqlite.org> wrote: > On Wed, May 7, 2014 at 9:00 AM, Marco Bambini <ma...@sqlabs.net> wr

Re: [sqlite] WITHOUT ROWID option

So, is there an official recommended way? or that check should require a manual sql parsing? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs On 07 May 2014, at 15:51, Igor Tandetnik <i...@tandetnik.org> wrote: > On 5/7/2014 9:40 AM, RSm

[sqlite] WITHOUT ROWID option

What is the best way to know if a table has been created with the WITHOUT ROWID option? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] sqlite3_analyzer source code

If I remember correctly, sqlite3_analyzer is a python script... I am not able to find its source code since in the download page there is a binary app only. Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] sqlite3session_changeset API oddity

= sqlite3session_changeset(session, , ); pnChangeset is always 0. Is this a bug or something not correctly documented? Please let me know. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite

[sqlite] Apply a changeset

Documentation is not very clear about this point… in order to apply a change set starting from a session should just I write something like: int rc= sqlite3session_changeset(session, , ); rc = sqlite3changeset_apply (db, pnChangeset, ppChangeset, NULL, NULL, NULL); Is that all? -- Marco Bambini

[sqlite] sqlite3_preupdate functions

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

[sqlite] List of registered tokenizers

What is the correct way to get a list of all registered sqlite tokenizers? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] FTS4 search for terms inside a word

* FROM myTable WHERE myColumn LIKE '%super%'; While with the MATCH operator it does not find anything: SELECT * FROM myTable WHERE myColumn MATCH '*super*'; Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs

[sqlite] sqlite and Mac App Store sandbox

have another solution? Any help? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] UTF-8

sqlite API? Please note that since I have access to the sqlite amalgamation source code I could also expose an internal function. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs ___ sqlite-users maili

[sqlite] ANN: SQLiteManager 4 - Working with sqlite databases will never be the same!

Hello, we are extremely proud to announce a major release for our SQLiteManager application (available for both MacOS X and Windows). SQLiteManager is a powerful database management system for sqlite databases, it combines an easy to use interface with blazing speed and advanced features.

[sqlite] Write to a View

t I do not understand what if the correct way to perform the operation. Thanks. -- 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] [ANN] SQLiteDoctor

Announcing SQLiteDoctor, the only way to recover your corrupted sqlite databases. Details available from: http://www.sqlabs.com/sqlitedoctor.php -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Columns involved in a WHERE clause

Can I parse the output of the EXPLAIN my_query statement in order to have an indirect access to columns involved in the WHERE clause? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs On Sep 21, 2012, at 4:10 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Sep

Re: [sqlite] Columns involved in a WHERE clause

Can I parse the output of the EXPLAIN my_query statement in order to have an indirect access to columns involved in the WHERE clause? -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs On Sep 21, 2012, at 4:10 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Sep

[sqlite] Columns involved in a WHERE clause

Hello, is there a way to extract column names involved in a WHERE clause of a query without manually parse the select statement? For example from a query like: SELECT * FROM myTable WHERE col1=… AND col2=…; I would need to extract both col1 and col2. Thanks. -- Marco Bambini http

[sqlite] Send me your corrupted databases

Hello, can you please send me your corrupted database files? (or put somewhere where I can download them). I am finishing a new sqlite utility and I would like to test it with a lot of different databases. Thanks a lot! -- Marco Bambini http://www.sqlabs.com

[sqlite] sqlite4 locking and concurrency

Hello, I am wondering if someone is able to provide some details (or directions) about locking and concurrency in sqlite 4. I guess there should be improvements over sqlite 3 but I am looking for information. Thanks. -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] Difference between 3.7.11 and 3.7.13

I am sorry, but it was sent twice for a mistake. -- Marco Bambini http://www.sqlabs.com On Jun 21, 2012, at 2:41 PM, Marco Bambini wrote: > Consider the following example: > > CREATE TABLE t1(x); > CREATE TABLE t2(y); > SELECT max((SELECT avg(x) FROM t2)) FROM t1; > > Wi

[sqlite] Difference between 3.7.11 and 3.7.13

Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlab

[sqlite] Difference between 3.7.11 and 3.7.13

Consider the following example: CREATE TABLE t1(x); CREATE TABLE t2(y); SELECT max((SELECT avg(x) FROM t2)) FROM t1; With sqlite 3.7.11 NULL is returned, while with sqlite 3.7.13 an error "Misuse of aggregate: avg()" is returned. Any thought? -- Marco Bambini http://www.sqlab

Re: [sqlite] sqlite sessions: handling rollbacks

Can you post some code or more details? Sessions has been specifically developed to handle rollbacks so your issue sounds really strange to me. -- Marco Bambini http://www.sqlabs.com On Jun 13, 2012, at 8:57 PM, Charles Samuels wrote: > > I'm using sqlite's sessions module, a

Re: [sqlite] The "sessions" branch

./configure; make sqlite3.c preupdate_hook code is in-line but no sessions related code. -- Marco Bambini http://www.sqlabs.com On Jun 4, 2012, at 4:38 PM, Richard Hipp wrote: > On Mon, Jun 4, 2012 at 10:34 AM, Marco Bambini <ma...@sqlabs.net> wrote: > >> I just tried to

Re: [sqlite] The "sessions" branch

ree/rtree.c keywordhash.h opcodes.c opcodes.h parse.c parse.h config.h sqlite3.h tsrc no ./ext/session/ folder is included. Any help? -- Marco Bambini http://www.sqlabs.com On May 31, 2012, at 9:27 PM, Richard Hipp wrote: > On Thu, May 31, 2012 at 2:55 PM, Charles Samuels <char...@ca

[sqlite] Table already exists error code

anks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Visual Studio 2008 Express and sqlite3.c

something confuse the Visual C++ compiler. Any idea? -- Marco Bambini http://www.sqlabs.com On Mar 30, 2012, at 1:08 PM, Nick Shaw wrote: > -Original Message- >> I am trying to compile the latest sqlite 3.7.11 amalgamation C file within a >> Visual Studio 2008 Expr

[sqlite] Visual Studio 2008 Express and sqlite3.c

\sqlite3.c(110555) : error C2059: syntax error : '!' Can someone is able to give me an explanation and a way to fix them? Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

[sqlite] Trigger or sql to preserve order

reordering oid within the same pid in case of INSERT, UPDATE and DELETE. Please note that if the trigger is too complicated then I could just execute a smart sql statement every time table foo changes. Anyone have a smart solution? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com

[sqlite] SQLite extensions repository

Hello, I am wondering if there is there a place that collect all available sqlite extensions. Please let me know. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] SQLite extensions repository

Hello, I am wondering if there is there a place that collect all available sqlite extensions. Please let me know. Thanks. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Explanation

sqlite 3.7.8 on MacOS X This query works fine: SELECT rowid, * FROM 'customer' WHERE rowid < 100; While this query does not return anything: SELECT rowid, * FROM 'customer' WHERE 'rowid' < 100; Do you have an explanation? -- Marco Bambini http://www.sqlabs.com http://twitter.com/

[sqlite] ANN: SQLiteSync

to the databases or an optional SQL text script can be generated. SQLiteSync is available for both MacOS X and Windows. More information available from: http://www.sqlabs.com/sqlitesync.php Sincerely. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs

Re: [sqlite] PRAGMA index_info explanation

Thanks a lot Tom, don't know why this email was delivered even today, it was sent yesterday and Dr. Hipp already replied me. Anyway… thanks a lot for your detailed explanation, I really appreciate. -- Marco Bambini http://www.sqlabs.com On Jan 11, 2012, at 4:06 PM, BareFeetWare wrote

[sqlite] PRAGMA index_info explanation

ame of the column being indexed. I am particularly interested in the rank fields … what does rank really means here? Is there a lower/upper bound to this rank value? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sql

[sqlite] PRAGMA index_info explanation

ame of the column being indexed. I am particularly interested in the rank fields … what does rank really means here? Is there a lower/upper bound to this rank value? Thanks a lot. -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs ___ sql

Re: [sqlite] sql server management studio like tool for SQLite

Take a look at my SQLiteManager app: http://www.sqlabs.com/sqlitemanager.php -- Marco Bambini http://www.sqlabs.com On Nov 6, 2011, at 7:04 PM, Pete wrote: > Opinions on the best one for OS X? > Pete > > > > > > >> Message: 6 >> Date: Sat, 05 N

Re: [sqlite] Help with SQLite error message

https://discussions.apple.com/message/15712311#15712311 -- Marco Bambini http://www.sqlabs.com On Sep 5, 2011, at 10:46 PM, Lani Gonzales wrote: > Dear Technical Support: > > Please help me remove this error message: > > The procedure entry point sqlite3_wal_c

Re: [sqlite] Need Help! -- SQlite database on server

Please take a look at cubeSQL: http://www.sqlabs.com/cubesql.php -- Marco Bambini http://www.sqlabs.com On Aug 4, 2011, at 7:15 PM, Vinoth raj wrote: > Dear SQLite users, > > I have been using SQlite database since three years. Suddenly I have a > requirement for client/se

[sqlite] Comments

Why this valid statement: CREATE TABLE USER( id text, -- the id of the user nametext-- the name of the user ); gives me a syntax error with sqlite 3.7.6.3? Thanks. -- Marco Bambini http://www.sqlabs.com

Re: [sqlite] Query help

Thanks a lot Igor, it's perfect now. -- Marco Bambini http://www.sqlabs.com On Jun 12, 2011, at 4:46 PM, Igor Tandetnik wrote: > Marco Bambini <ma...@sqlabs.net> wrote: >> I have a table Clients defined as (simplified version): >> CREATE TABLE Clients (i

Re: [sqlite] Query help

No I am sorry but I need to query the ping_timeout column from inside the same query. -- Marco Bambini http://www.sqlabs.com On Jun 12, 2011, at 2:02 PM, Roger Andersson wrote: > On 06/12/11 01:52 PM, Marco Bambini wrote: >> things are recently changed in my app and ping_timeo

[sqlite] Query help

seconds', 'localtime');", settings.ping_timeout); using just the ping_timeout column in the Clients table instead of the settings.ping_timeout global property. Any idea? -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing li

Re: [sqlite] How to know the offset of a rowid inside a table?

Thanks Martin and Richard, solution was so simple that I think to need a time break today. Should I add an ORDER BY rowid clause at the end of the SELECT statement or its implicit by the WHERE clause? Thanks a lot. -- Marco Bambini http://www.sqlabs.com On Jun 8, 2011, at 4:27 PM

[sqlite] How to know the offset of a rowid inside a table?

by 1 but I am quite sure that should be a more elegant way. 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] Proper way to escape table name and column name

What is the official way to escape table name that contains a space and column name that contain a spaces? Thanks a lot. -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] [ANN] cubeSQL

starts at $299 USD. For more information, please visit the SQLabs website: http://www.sqlabs.com -- Marco Bambini http://www.sqlabs.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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] 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

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.

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] 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] 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

  1   2   >