Question, does the %q operator offer any advantages over calling QuotedStr ?
Yes: The %q operator just duplicates internal quotes, it does insert quotes at
the beginning and the end of the string like QuotedStr does. You can can still
use sqlite3_mprintf's %Q operator for that.
Ralf
Why Sqlite doesn't support just the use of offset in select statements?
As such SQL does support the use of offset only, without limit. But in
case of Sqlite it's not possible to use offset without limit.
Also what is mentioned on website is different from what is there in
parser.c file. On
I am using sqlite version 3.3.7
Also what I have noticed is limit ALL is not supported.
limit_opt ::=,
limit_opt ::= LIMIT expr,
limit_opt ::= LIMIT expr OFFSET expr,
limit_opt ::= LIMIT expr COMMA expr,
expr doesn't contain ALL.
Hello,
I'm trying to write an application which will merge two or more databases
together.
The rules are that duplicate records will be added together.
As an example we can have two tables:
user(id integer primary, name text)
and
orders (id integer primary, apples integer, user_id foreign)
On 27.06.2007 02:27 CE(S)T, Robert Simpson wrote:
If you'd rather communicate directly with the database and process
per-row as quickly as possible, you can use the
DbCommand/DbDataReader model.
Hm, okay, that's what I referred to that I am using.
While some may argue whether or not 592k is
A moments reflection convinces me that this is not a good idea
as stated. But perhaps it can be the seed for a idea that will
actually work. Is there some way of adding customizations to
the database file itself, or perhaps to a separate file in a
standard place the SQLite always knows to look,
B V, Phanisekhar [EMAIL PROTECTED] wrote:
Also what I have noticed is limit ALL is not supported.
A negative value is interpreted as ALL. This is also documented at
http://sqlite.org/lang_select.html
Igor Tandetnik
Jiri Hajek [EMAIL PROTECTED] wrote:
The only argument against this was that individual implementations of
Unicode standard (i.e. mainly internal Windows methods or ICU library)
could differ. However, is it really a problem? I'd say that it isn't.
Unicode specifies exactly how characters should
Unfortunately, Unicode specifies no such thing. There is no such thing
as _the_ Unicode collation, if only because collation rules depend on
locale.
Yes, what I mean is to define how individual locales are identified in
SQLite, like that already suggested 'en_AU', 'tr_TR', etc.
On 6/27/07, Jiri Hajek [EMAIL PROTECTED] wrote:
I tried to think about this in as many details as possible and I'd say
that the original problem that I'd like to solve here (i.e. collation
of Unicode character sets) doesn't require any special complex
handling in SQLite. We really should just
B V, Phanisekhar [EMAIL PROTECTED] wrote:
Why Sqlite doesn't support just the use of offset in select
statements? As such SQL does support the use of offset only, without
limit. But in case of Sqlite it's not possible to use offset without
limit.
select * from tableName limit -1 offset 5;
--
Thank you very much for your information Mr. Hipp!
I will update my blog.
On 26/06/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Cesar D. Rodas [EMAIL PROTECTED] wrote:
I was surfing and I saw that sqlite website is very busy with a hight
band
width traffic (
On 6/27/07, Jiri Hajek [EMAIL PROTECTED] wrote:
Is it really that big issue that particular implementations can
differ? For example, doesn't VACUUM recreate indexes, so that they
would be accurate after moving to another platform (and if it doesn't,
shouldn't it?).
Right now sqlite database
D. Richard Hipp
The blog is updated!, and I think you should put in your website GoogleAds
to get other benefis with your wonderful project, and the comunity think
about this?
Thank you for take time for send me the update information.
Also this information will be publish in some free
Right now sqlite database files are portable across systems as-is.
You're proposing they should need to be explicitly prepared for
transport? Remember, the risk is silent data corruption. This is not
a trivial matter.
Well, I do understand that Unicode standard is quite a complicated
thing,
On 6/27/07, Jiri Hajek [EMAIL PROTECTED] wrote:
Right now sqlite database files are portable across systems as-is.
You're proposing they should need to be explicitly prepared for
transport? Remember, the risk is silent data corruption. This is not
a trivial matter.
Well, I do
--- Trevor Talbot [EMAIL PROTECTED] wrote:
Microsoft has changed the collation data sub-service pack, so for
practical purposes it's tied to a specific install of Windows unless
it contains logic to regenerate indexes on the fly.
At this point you realize that what you need is not a tiny
On 6/25/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
So the choices seem to be:
(1) Databases that corrupt if you move across platforms.
(2) A 10MB database engine
(3) Leave things as they are
OK. Here is a crazy idea for consideration:
You know that you can create a custom
On 6/27/07, Trevor Talbot [EMAIL PROTECTED] wrote:
On 6/25/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
So the choices seem to be:
(1) Databases that corrupt if you move across platforms.
(2) A 10MB database engine
(3) Leave things as they are
OK. Here is a crazy idea for
After thinking a bit, it occurs to me that there's a compromise for
the Unicode case that might be workable. The algorithm for collation
is pretty stable, it's just the locale data that's the problem. If
SQLite understands the algorithm, then locale data can go into special
tables in the
Hello,
I am using sqlite3 under Windows XP as a part of my
application, sqlite is compiled as a dll.
I am noticing big memory usage fluctuations coming
from my application which I believe may originate from
sqlite. I am seeing the following behaviour, on
machines with small amount of free memory
ak1mbox-jxta-FFYn/[EMAIL PROTECTED] wrote:
I am using sqlite3 under Windows XP as a part of my
application, sqlite is compiled as a dll.
I am noticing big memory usage fluctuations coming
from my application which I believe may originate from
sqlite. I am seeing the following behaviour, on
On 6/27/07, Jiri Hajek [EMAIL PROTECTED] wrote:
Actually, reading one of the links you posted
(http://blogs.msdn.com/michkap/archive/2005/05/04/414520.aspx -
everybody please read it before continuing in discussion), I got (what
I think is a great) idea: Let's include version information about
Hi-
No, I am not confident that my file locking code is working. For vxWorks, I
needed to alter the .lock functionality, as it wouldn't compile. Pretty
much changes such as calling stat() instead of lstat(), etc. However, for
this example, I do know that the two threads operate serially (ie,
Hello, is there a way to query the number of open database connections?
--
Nathan Constant
All,
Does sqlite implement LISTEN or NOTIFY commands?
Basically if one application modifies the database will sqlite notify
other interested applications about the modification?
Shilpa
-
To unsubscribe, send email to
On 6/27/07, Shilpa Sheoran [EMAIL PROTECTED] wrote:
All,
Does sqlite implement LISTEN or NOTIFY commands?
Basically if one application modifies the database will sqlite notify
other interested applications about the modification?
I do not believe that SQLite implements the non-standard
Actually, reading one of the links you posted
(http://blogs.msdn.com/michkap/archive/2005/05/04/414520.aspx -
everybody please read it before continuing in discussion), I got (what
I think is a great) idea: Let's include version information about
collation algorithm we are using. So,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul KOENIG [EMAIL PROTECTED] writes:
Thanks but i forgot to specify that i'm on Mac :(
Something else for me ??
Druid?
http://sourceforge.net/projects/druid/
Bill
- --
Bill Harris http://facilitatedsystems.com/weblog/
In the misty mists of time, we made the decision to minimize namespace
pollution by trying to keep everything in a single file. fts2.c is
almost to 6000 lines, almost as big as btree.c. Does anyone have
strong thoughts about the negatives of breaking things up?
Offhand, the major bits of
From: Dan Kennedy...
On Tue, 2007-06-26 at 17:50 -0400, jose isaias cabrera wrote:
Greetings.
CREATE TABLE LSOpenJobs
(
id integer primary key, ProjID integer, subProjID, parent,
children, login, cust, proj, PClass, PSubClass, bdate, ddate, edate, pm,
pmuk, lang, vendor,
--- Scott Hess [EMAIL PROTECTED] wrote:
In the misty mists of time, we made the decision to minimize namespace
pollution by trying to keep everything in a single file. fts2.c is
almost to 6000 lines, almost as big as btree.c. Does anyone have
strong thoughts about the negatives of breaking
--- Nate Constant [EMAIL PROTECTED] wrote:
Hello, is there a way to query the number of open database connections?
Within a single application, I don't think so - not a public API, anyway.
You have to keep track of connections yourself.
From multiple sqlite applications sharing the same
Can someone else confirm this for me?
On unix, I'm seeing processes that have been clone/exec'd inheriting
file handles to sqlite databases that were opened in the parent process
(and hence subsequently don't/can't get closed in the child process).
The solution is the FD_CLOEXEC fcntl on the
page_size must be the first statement.
PRAGMA page_size=4096;
PRAGMA default_cache_size=25;
CREATE TABLE timestamp (date TEXT, time TEXT, script_version REAL);
INSERT INTO timestamp VALUES('27/06/07', '14:38:18', '0.01');
sqlite3 temp.db .read create.load
create.load is actually the
On 6/27/07, Neil Hughes [EMAIL PROTECTED] wrote:
PRAGMA default_cache_size=25;
PRAGMA page_size=4096;
CREATE TABLE timestamp (date TEXT, time TEXT, script_version REAL);
INSERT INTO timestamp VALUES('27/06/07', '14:38:18', '0.01');
I've only just learned this today during an innocent
On 6/27/07, Bill KING [EMAIL PROTECTED] wrote:
Can someone else confirm this for me?
Yes.
On unix, I'm seeing processes that have been clone/exec'd inheriting
file handles to sqlite databases that were opened in the parent process
(and hence subsequently don't/can't get closed in the child
Hello all:
I was reading through a couple of sqlite tutorials and I noticed
examples of timestamping database entries by using triggers. I wanted
to ask people's opinion about using triggers to timestamp records in a
database.
Which is 'better': using a trigger to timestamp records or
On 6/27/07, jose isaias cabrera [EMAIL PROTECTED] wrote:
On Tue, 2007-06-26 at 17:50 -0400, jose isaias cabrera wrote:
Greetings.
CREATE TABLE LSOpenJobs
(
id integer primary key, ProjID integer, subProjID, parent,
children, login, cust, proj, PClass, PSubClass, bdate,
Why not youself take charge of this work.that's not be somehow complex.
All,
Does sqlite implement LISTEN or NOTIFY commands?
Basically if one application modifies the database will sqlite notify
other interested applications about the modification?
Shilpa
On 6/27/07, Andrew Finkenstadt [EMAIL PROTECTED] wrote:
On 6/27/07, Neil Hughes [EMAIL PROTECTED] wrote:
PRAGMA default_cache_size=25;
PRAGMA page_size=4096;
CREATE TABLE timestamp (date TEXT, time TEXT, script_version REAL);
INSERT INTO timestamp VALUES('27/06/07', '14:38:18',
From: Trevor Talbot...
On 6/27/07, jose isaias cabrera [EMAIL PROTECTED] wrote:
On Tue, 2007-06-26 at 17:50 -0400, jose isaias cabrera wrote:
Greetings.
CREATE TABLE LSOpenJobs
(
id integer primary key, ProjID integer, subProjID, parent,
children, login, cust, proj,
Nate Constant wrote:
Hello, is there a way to query the number of open database connections?
An open file monitor like lsof will do it.
-
To unsubscribe, send email to [EMAIL PROTECTED]
Hi,
I have a database which has a table that contains BLOB data. The table
has two columns - one is Row_Num which is of type AUTO_INCREMENT
(INTERGER_PRIMARY_KEY) and the other column Data contains BLOB data.
I am writing a program (in MS VC++) which has to read the blob data in
all the
Krishnamoorthy, Priya (IE10) wrote:
Hi,
I have a database which has a table that contains BLOB data. The table
has two columns - one is Row_Num which is of type AUTO_INCREMENT
(INTERGER_PRIMARY_KEY) and the other column Data contains BLOB data.
I am writing a program (in MS VC++) which
GetTable will retrive entire snapshot of our table.I guess u app
is a 32bit application hence u can maximum access 2GB of user address space.
Upgrade to 64bit to access beyond this limit.
regards
ragha
PS:Sqlite is designed for small data sets amied at Embedded apps
On 6/27/07, Krishnamoorthy, Priya (IE10)
[EMAIL PROTECTED] wrote:
for (int i=1;i = b.numRows() ; i++)
sql_command.format(select Data from %s where Row_Num =
%d;,table_name,i);
q = db.execQuery(sql_command);
if (!q.eof())
This method works
Thanks Igor Dennis,
As far as I can tell, LIMIT and OFFSET clauses are not specified in
any
version of SQL standard. What is your belief based on that this query
is
supported by SQL, and what precisely do you mean by the term SQL in
this assertion?
I thought limit and offset are part of
48 matches
Mail list logo