Re: [sqlite] how can I make SQLite work on Mono multiplatform project?

Please see: http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Difference between SQLITE_CONFIG_MULTITHREAD & SQLITE_CONFIG_SERIALIZED options

What is the difference between the SQLITE_CONFIG_MULTITHREAD & SQLITE_CONFIG_SERIALIZED options - When a) the same handle is shared between multiple threads in a process and when different handles are used by threads in a proceses. Is there any difference in concurrency ? What should be used

Re: [sqlite] Function context

[Simon Slavin] > On 13 Feb 2012, at 7:51pm, Steinar Midtskogen wrote: > >> One should think that the ability to calculate a moving average would >> be a pretty common request. But people do it in their application >> code instead? > > Actually, my expectation is the other way. I'm continually

[sqlite] how can I make SQLite work on Mono multiplatform project?

Hi all! Im almost finished with an application of mine that I developed with M Visual Studio 2010 using c#. The software uses a lot of SQLite transactions, all of which work perfect compiled and run under Windows.Now I try to make my app multiplatform, using Mono (for the first time). And I

Re: [sqlite] Function context

> More generally, I *often* see good C++ programmers pushing application > logic into SQL, and getting it wrong because they don't really know > SQL. As a result, my rule of thumb is to make the separation between > application code and SQL code based on whether the code is filtering > result

Re: [sqlite] Compiling SQLite3 to run on Windows Mobile 6.5

Thanks Michael I got it to work. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS) Sent: Saturday, February 11, 2012 7:57 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Compiling SQLite3

Re: [sqlite] Function context

On Mon, Feb 13, 2012 at 12:28 PM, Simon Slavin wrote: > On 13 Feb 2012, at 7:51pm, Steinar Midtskogen wrote: >> One should think that the ability to calculate a moving average would >> be a pretty common request.  But people do it in their application >> code instead? > >

Re: [sqlite] Function context

> Actually, my expectation is the other way. I'm continually surprised > by posts on this list that people expect to be able to use SQLite with > no external programming at all. I often see complicated compound JOIN > and sub-SELECT SQL commands here which can be replaced by four lines in > any

Re: [sqlite] Function context

On Mon, Feb 13, 2012 at 11:51 AM, Steinar Midtskogen wrote: > [Scott Hess] >> Unfortunately, I can't offhand think of a reasonable solution for you, >> I think I'd just use the SELECT to generate the data, while >> calculating the moving average in my application code. > >

Re: [sqlite] Function context

On 13 Feb 2012, at 7:51pm, Steinar Midtskogen wrote: > One should think that the ability to calculate a moving average would > be a pretty common request. But people do it in their application > code instead? Actually, my expectation is the other way. I'm continually surprised by posts on

Re: [sqlite] Function context

[Scott Hess] > I think you're making unwarranted assumptions about the order your > custom function will be called. Even if you added "ORDER BY" to the > end of the query, that wouldn't necessarily order the calls to your > custom function. Even if you find a workaround which allows you to >

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

Hello Dan, thank you for the response, that did it. Unfortunately, this 'breaks' the fts_table_terms functionality in the sense that real terms (e.g. with diacritics) cannot be retrieved using that table, since they're stored without. I wanted to use that table for autocomplete feature in a text

Re: [sqlite] Function context

On Mon, Feb 13, 2012 at 9:24 AM, Steinar Midtskogen wrote: > [Peter Aronson] >> (2) You can associate data with an argument to a regular user-defined >> function using sqlite3_set_auxdata() and sqlite3_get_auxdata() as long >> as the value of the argument is static.  If you

Re: [sqlite] Function context

I believe It's private to that query as it is stored in sqlite3_context structure at the moment (the context being stored in a stack variable during SQL execution as far as I can tell).  I'd assume this is stable behavior, but you'd have to ask the SQLite Dev team for an official answer.  I

Re: [sqlite] Function context

[Peter Aronson] > (2) You can associate data with an argument to a regular user-defined > function using sqlite3_set_auxdata() and sqlite3_get_auxdata() as long > as the value of the argument is static. If you don't normally have a > static argument to your function, you can add one (say a

Re: [sqlite] How to check whether a table is empty or not in sqlite.

On 2/13/2012 11:20 AM, Kit wrote: 2012/2/13 Igor Tandetnik: bhaskarReddy wrote: How to check whether a table is empty or not. If a table is empty, i want to do some logic. If not another logic. select exists (select 1 from MyTable); SELECT

Re: [sqlite] Call PRAGMA from TCL API

On 13 Feb 2012, at 4:05pm, Tilsley, Jerry M. wrote: > How can I call the pragma statements, more specifically the PRAGMA > FOREIGN_KEYS=ON from within the Tcl environment? Execute them the same way you'd execute a 'SELECT' SQL command. Simon. ___

Re: [sqlite] How to check whether a table is empty or not in sqlite.

2012/2/13 Igor Tandetnik : > bhaskarReddy wrote: >>        How to check whether a table is empty or not. If a table is empty, i >> want to do some logic. If not another logic. > > select exists (select 1 from MyTable); SELECT exists(SELECT 1 FROM MyTable

Re: [sqlite] How to check whether a table is empty or not in sqlite.

On Mon, Feb 13, 2012 at 03:48:24PM +, Simon Slavin scratched on the wall: > > On 13 Feb 2012, at 1:02pm, Igor Tandetnik wrote: > > > bhaskarReddy wrote: > >> How to check whether a table is empty or not. If a table is empty, i > >> want to do some logic. If not

[sqlite] Call PRAGMA from TCL API

All, How can I call the pragma statements, more specifically the PRAGMA FOREIGN_KEYS=ON from within the Tcl environment? Thanks, Jerry Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any

Re: [sqlite] freelist_count - can it shrink back?

Regarding: My question is, when I insert new data, is the needed space allocated out > of the free_list or do the db file grows larger and the free space stays > till vacuum operation is performed? > Basically, my question is: on intensive inserts and deletes will the freed > space be re-used ? >

Re: [sqlite] How to check whether a table is empty or not in sqlite.

On 13 Feb 2012, at 1:02pm, Igor Tandetnik wrote: > bhaskarReddy wrote: >> How to check whether a table is empty or not. If a table is empty, i >> want to do some logic. If not another logic. > > select exists (select 1 from MyTable); Or SELECT COUNT(*) from MyTable

Re: [sqlite] Function context

You can't call sqlite3_aggregate_context() in a non-aggregate function. However, there *are* a couple of other things you can do. (1) All forms of sqlite3_create_function() take as 5th argument a void pointer to an arbitrary user data structure. This data structure can be accessed in a

[sqlite] Function context

Hello Is it possible to have a context for a custom SQL function that is NOT an aggregate function? It might sound silly, but if a SELECT statement with this function causes the function to be called in a defined order (as with the step function of an aggregate function), this can be useful to

Re: [sqlite] multiple rows of VALUES in an INSERT incompatible with SQLITE_OMIT_COMPOUND_SELECT

On 13.02.2012 10:18, Dan Kennedy wrote: > On 02/10/2012 11:06 PM, Ralf Junker wrote: >> >>> The new feature to insert multiple rows of VALUES in a single INSERT >>> >>>http://www.sqlite.org/src/info/eb3b6a0ceb >>> >>> gives wrong results if SQLite is compiled with >>>

Re: [sqlite] How to check whether a table is empty or not in sqlite.

bhaskarReddy wrote: >How to check whether a table is empty or not. If a table is empty, i > want to do some logic. If not another logic. select exists (select 1 from MyTable); -- Igor Tandetnik ___ sqlite-users mailing list

[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

[sqlite] How to check whether a table is empty or not in sqlite.

HI Friends, How to check whether a table is empty or not. If a table is empty, i want to do some logic. If not another logic. Can any one tell me how to check if table in a data base is empty or not, using sqlite3. Regards, Bhaskar. -- View this message in context:

Re: [sqlite] multiple rows of VALUES in an INSERT incompatible with SQLITE_OMIT_COMPOUND_SELECT

On 02/10/2012 11:06 PM, Ralf Junker wrote: On 07.02.2012 12:28, Ralf Junker wrote: The new feature to insert multiple rows of VALUES in a single INSERT http://www.sqlite.org/src/info/eb3b6a0ceb gives wrong results if SQLite is compiled with SQLITE_OMIT_COMPOUND_SELECT. Has the team seen