What ever happened to Unql and is there any chance it will be revived?
It seemed like it would have been incredible useful.
:(
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 07/17/2011 09:50 AM, Simon Slavin wrote:
>
> On 17 Jul 2011, at 2:40pm, dcharno wrote:
>
>> I have a table where columns a and b form a unique key for column c. In
>> an attempt to speed up queries I added an index on a and b.
>>
>>CREATE TABLE t(a TEXT, b
I have a table where columns a and b form a unique key for column c. In
an attempt to speed up queries I added an index on a and b.
CREATE TABLE t(a TEXT, b TEXT, c TEXT, CONSTRAINT u UNIQUE(a,b));
CREATE INDEX iab ON t(a, b);
But, an automatic index is being used even though it seems
I have a database that returns SQLITE_CORRUPT during certain queries,
but other than that it opens, closes and generally works fine.
- Is there a way to check the database when its open, other than running
through a bunch of test queries?
- Is there any general way to fix corruption issues?
What are some of the things that people use virtual tables for? Are
there any good example usages?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
centipede moto wrote:
> I am new to c++ (I know php, c# etc), and thanks to this list I've gotten
> sqlite3 to open a db connection without failing to find its libraries. But
> now that I have an open db connection I am lost, I can work my way through
> the c++ itself but I'm having a hard time
P Kishor wrote:
> so, I have read the tutes on the website, but just wanted to confirm...
>
> I want to take baby steps to including sqlite's capabilities in my
> modeling program. Do I just include sqlite3.h and compile my program
> and magic will happen, or do I need to do something else?
>
>
> The SQLite website is implemented using a profoundly simple HTTP
> server that runs off of inetd. The complete source code is contained
> in a single file of C code that is available on-line at:
>
> http://www.sqlite.org/docsrc/artifact/84d487ac34
Just to clarify, this code is part
> Could you tell me where can I find such documentation, or can you
> recommend some books.
"The Definitive Guide to SQLite" by Michael Owens explains the SQLite
API in detail and provides a number of samples in C.
___
sqlite-users mailing list
D. Richard Hipp wrote:
> On Oct 9, 2008, at 9:11 PM, dcharno wrote:
>
>>> If you have issues or concerns with any aspect of the upcoming
>>> release, now would be a good time to raise them.
>> Is there any way to have both the BNF and syntax diagrams in the SQL
> If you have issues or concerns with any aspect of the upcoming
> release, now would be a good time to raise them.
Is there any way to have both the BNF and syntax diagrams in the SQL Syntax?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Darko Miletic wrote:
>> Maybe he is looking for a C++ wrapper for Sqlite.
>
> Than look no further. SOCI is the definite sqlite c++ wrapper.
>
> http://soci.sourceforge.net/
This wrapper looked really promising. But, the SQLite backend wasn't
being maintained and is no longer officially
Steven Woody wrote:
> On Sat, Jun 28, 2008 at 11:30 AM, dcharno <[EMAIL PROTECTED]> wrote:
>>> As an option, we also think about Berkeley DB, do you experts has
>>> experience using Berkeley DB on ARM/Linux with ulibc or glibc?
>> Berkeley DB may also be an option.
> As an option, we also think about Berkeley DB, do you experts has
> experience using Berkeley DB on ARM/Linux with ulibc or glibc?
Berkeley DB may also be an option. It really depends upon what you are
trying to accomplish, what your data set looks like, etc.
Ironically yes; I am translating
> I am considering to use SQLite in my current embedded application
> project. It's a ARM9/Linux. Do you experts think it is a good idea？
> And, is there any tips or considerations in this combination?
Currently using SQLite on an ARM7 running ucLinux.
SQLite is an excellent choice for many
>> Is there any future plan to develop sqlite in C++.
>>
>
> Why would anybody want to do that?
Maybe he is looking for a C++ wrapper for Sqlite.
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
___
sqlite-users mailing list
From: Dennis Cote <[EMAIL PROTECTED]>
> No, that's not true. A sub-query is like any other query. I have
> rearranged the query to make it more readable.
>
> select types.Track,types.URL
> from ALBUM
> inner join (select * from MUSIC where Artist_Id =?) as types
> on
> select types.Track,types.URL from ALBUM inner join (select * from MUSIC
> where Artist_Id =?) types on ALBUM.AlbumId=types.Album_Id order by
> ALBUM.YomiAlbumName ;
How does the subquery work in this statement? I thought subqueries
could only retrieve a single column.
Jeff Hamilton wrote:
> It shouldn't matter, the rowid is guaranteed to but unique since it's
> the row's key into the table data b-tree. The ORDER BY in my example
> adds sorting based on that value when the titles are the same so you
> in effect have a unique sort key that is ordered.
Ahh.
Jeff Hamilton wrote:
> What about something like this:
>
> SELECT title FROM tracks
> WHERE singer='Madonna'
>AND (title<:firsttitle OR (title=:firsttitle AND rowid<:firstrowid))
> ORDER BY title DESC, rowid ASC
> LIMIT 5;
>
> Then you only have to remember the single
>> In the next query, dump any rows where (title =
>> last_seen_title) and (rowid != last_seen_rowid).
>
> Up until you hit the last seen rowid, yes. That was my first idea as
> well.
Right. Tried it in a quick prototype and it seemed to worked okay.
> The big thing to remember is that
Jay A. Kreibich wrote:
> You quoted the backward example, but I'm going to use the forward version.
>
> In addition to the "last seen title", remember the RowID for every row
> with the same "last seen title".
>
> For the forward query use "AND title>=:firsttitle" and pitch rows
> that
[EMAIL PROTECTED] wrote:
> This issue keeps coming up so I did a wiki page.
> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
I'm using the method described in the wiki and it was working pretty
well until I hit a data set where the sorting column was not unique.
Here is the query from
[EMAIL PROTECTED] wrote:
> This issue keeps coming up so I did a wiki page.
> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
I'm using the method described in the wiki and it was working pretty
well until I hit a data set where the sorting column was not unique.
Here is the query from
I would like to recommend that Encriq create a forum or mailing list of
their own for those who are interesting in learning more. For me, what
might be an interesting product is quickly being overshadowed by this
thread.
You raise some interesting points. There is nothing secret about
Can we please stop this thread?
John Stanton wrote:
Emerson, one posts to a forum like this to get help and other ideas, not
to spark a debate. Many talented people gave you some of their time to
help you solve your problem and one in particular gave you a well
conceived and executed piece
Lloyd wrote:
Hi List,
Is there is any easy way to insert a value to a table, if and only if
it is not existing ?
http://sqlite.org/lang_conflict.html
ON CONFLICT clause
conflict-clause ::= ON CONFLICT conflict-algorithm
conflict-algorithm ::= ROLLBACK | ABORT | FAIL | IGNORE | REPLACE
27 matches
Mail list logo
