Re: [sqlite] Point a newbie in the right direction ;)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Monte Milanuk wrote: > Where I need some help (or more specifically, some pointers towards books, > tutorials and such) is on how I should organize the data in SQLite - how to > split it up between tables, referencing them in queries, backups, dumps,

Re: [sqlite] Formatted text with fts3

Hello! On Tuesday 10 March 2009 06:16:16 Alexandre Courbot wrote: > Never did this myself, but I think you can do what you need by writing > your own tokenizer: > > http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/README.tokenizers It's not good advice for a few documented module. I

[sqlite] nullable select fields

Hi All, I'm developing an application which relies on sqllite as back-end. Now I face to this problem: I've got a form that allows the user to fill a lot of fields, obliviously only a little part of them will actually be filled, the others isn't gonna be in the search criteria. So I prepare a

Re: [sqlite] nullable select fields

Hi, see sqlite3_bind_null: http://www.sqlite.org/capi3ref.html#sqlite3_bind_blob Martin Andrea Galeazzi schrieb: > Hi All, > I'm developing an application which relies on sqllite as back-end. Now > I face to this problem: I've got a form that allows the user to fill a > lot of fields,

Re: [sqlite] nullable select fields

"Andrea Galeazzi" wrote in message news:49b6557c.3060...@korg.it > I'm developing an application which relies on sqllite as back-end. > Now I face to this problem: I've got a form that allows the user to > fill a lot of fields, obliviously only a little part of them will >

[sqlite] In-memory SQLite multithreaded access

Hello, I want to use the in-memory storage for the following scenario : - The content is added in the beginning (multiple insert statements) - Afterwards, all the accesses will consist only of select queries. The problem is that I want the read accesses to be executed, in parallel, from multiple

Re: [sqlite] nullable select fields

On 10/03/2009 10:56 PM, Andrea Galeazzi wrote: > Hi All, > I'm developing an application which relies on sqllite as back-end. Now > I face to this problem: I've got a form that allows the user to fill a > lot of fields, obliviously only a little part of them will actually be > filled, the

Re: [sqlite] Formatted text with fts3

Thank you for the pointers Alexandre and Alexey. I spent about 30 minutes looking into the parser, and it looks like it is a possibility. I'll require a more in-depth understanding in order to do this. I would probably start with the simple parser, and go from there. > I think to prepare html

Re: [sqlite] nullable select fields

Citando John Machin : > On 10/03/2009 10:56 PM, Andrea Galeazzi wrote: >> Hi All, >> I'm developing an application which relies on sqllite as back-end. Now >> I face to this problem: I've got a form that allows the user to fill a >> lot of fields, obliviously only a little

Re: [sqlite] nullable select fields

Andrea Galeazzi wrote: > Hi All, > I'm developing an application which relies on sqllite as back-end. Now > I face to this problem: I've got a form that allows the user to fill a > lot of fields, obliviously only a little part of them will actually be > filled, the others isn't gonna be in

[sqlite] get_table and bind

is it possible to use a similar function to get_table but starting by a statement in order to use the bind facilities? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] get_table and bind

galea...@korg.it wrote: > is it possible to use a similar function to get_table but starting by > a statement in order to use the bind facilities? Anything wrong with calling sqlite3_step in a loop? Igor Tandetnik ___ sqlite-users mailing list

[sqlite] Nested SELECTS using UNION and INTERSECT syntax problems....

I can't for the life of me figure this out. I'm trying to do a nested select like this: SELECT x FROM (( UNION ) INTERSECT ( UNION )) WHERE X= Each of the select a through d statements all return the same column x. If I remove the inner parentheses, it executes just fine but of course the

[sqlite] advice about opening an encrypted database

using the standard sqlite encryption option: If I open a database I expect to be encrypted, and call sqlite_key to establish the expected key, how should I verify that the database is now open for business? Ie that the key was correct. Similarly, if I open a database might or might not be

Re: [sqlite] Formatted text with fts3

Scott, Thanks so much for your thoughtful response. Things can get complicated (especially with full text searching) when using formatted text. What I really want to do is retain the formatting, to display in a HTML file. The text out of the database would be wrapped by a basic HTML outter

Re: [sqlite] I need help with very complex queries

You have specified how the movies table relates to the other tables, but you haven't specified any independent selection criteria for any tables. For example, in your query you need to add something like: and genres.genre = 'drama'. For this query, only the movies and genres tables are needed

Re: [sqlite] I need help with very complex queries

Jim Wilcoxson wrote: > > For example, in your query you need to add something like: > and genres.genre = 'drama'. Yes but if I add that I neither get any result: sqlite3 movies.db "select movies.id,title,year from movies,genres,countries,languages,keywords,tags where movies.id = genres.id and

Re: [sqlite] I need help with very complex queries

"Yuzem" wrote in message news:22446301.p...@talk.nabble.com > As an example, I have: > tables: > movies genres keywords languages countries etc... > > movies columns: > id title year director etc > > The others are: > id "name of the table" (example: id genres) > > The

[sqlite] Creating a secondary table automatically

I am new to SQLite and am trying to automatically create a secondary table which my python app will query against. The secondary table is a summary of the 1st table by specific types. I have looked at stored procedures (but sqlite does not support these) and triggers with no success. Any

[sqlite] Extract error text in C API

I am using triggers to handle database integrity as suggested by the docs. When a violation occurs the 'SELECT RAISE(ROLLBACK, "Blah")' is executed. I want to get extract the 'Blah' text using the C API but cannot seem to work out how to do it. I feel I am missing something obvious... can

Re: [sqlite] Creating a secondary table automatically

On Tue, 10 Mar 2009, Erik Smith wrote: > I am new to SQLite and am trying to automatically create a secondary table > which my python app will query against. The secondary table is a summary of > the 1st table by specific types. I have looked at stored procedures (but > sqlite does not support

[sqlite] Any Way to Peak at Next Row?

I'm creating some reports with some SQLite data. One report groups data by one column and subtotals each group. It's working well but it really doesn't look right when the last item in a group is at the bottom of the page and the subtotal is then orphaned on the start of the next page. I really

[sqlite] compilation : undefined symbols.

Hello Sir, I downloaded sqlite 3.6.11 code for my project in my organisation. I'm not using the amalgamation code.  I'm building the source code files in unix environment. I'm not new to sqlite, I have earlier worked on 3.2.2. My project need is very simple - to store and read data (persistent

Re: [sqlite] Any Way to Peak at Next Row?

On Tue, 2009-03-10 at 20:28 -0700, jonwood wrote: > I'm creating some reports with some SQLite data. One report groups data by > one column and subtotals each group. > > It's working well but it really doesn't look right when the last item in a > group is at the bottom of the page and the

Re: [sqlite] Any Way to Peak at Next Row?

> What you want is to fetch the data into memory first, and then process > it later. They way you describe the goal, you'd only have to keep 1 > record in memory. Yeah, I've been toying with that. It makes things a bit more complex than I'd like but sounds like that can't be avoided. > Also, if