On 23/10/2007, Vijaya Lakshmi <[EMAIL PROTECTED]> wrote:
.
> sqlite.org and used the command line
>
> sqlite>sqlite old.db .dump | sqlite 3 new.db
> but after this nothing happens it just shows as below...
> >
Type the command at the operating system prompt, not whilst sqlite is
already runnin
Richard Klein schrieb:
Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
Joe Wilson wrote:
Just implement it and run the test suite.
It's easier to respond to a specific problem than a hypothetical.
Is the test suite available only in Tcl? Or is there a C version
as well?
Tcl.
Hi all!
I have developed a small windows application that use a SQLite database
as it's main format.
The file is NOT a kind of document, it's more of a settings-file stored
in the users "Application data"-directory and the extension will not be
associated with the application.
I know I can u
On Mon, 2007-10-22 at 12:10 -0700, Mark Spiegel wrote:
> Thanks Dan. How about the second part. Should the PENDING_LOCK be
> taken en route from the SHARD_LOCK to EXCLUSIVE_LOCK? Which is right,
> the code or the function header?
Doesn't really matter as far as I know. Which I guess means
th
I have compiled and used SQLite 3 up to 3.4.2 without problems, but
recent changes on SQL 3.5.x introduced some issues, see below.
I am using mingw (gnu compiler for w32):
gcc version 4.1.3 20070829
NASM version 0.99.04
GNU ld (GNU Binutils) 2.17.50.20070806
GNU Make 3.81
The used this source cod
--- Klemens Friedl <[EMAIL PROTECTED]> wrote:
> Has someone already used mingw to build
http://www.sqlite.org/cvstrac/tktview?tn=931
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
sqlite>sqlite old.db .dump | sqlite 3 new.db
but after this nothing happens it just shows as below...
>
Please help us..
-Original Message-
From: Vijaya Lakshmi [mailto:[EMAIL PROTECTED]
Hi, Vijaya,
You don't want "sqlite 3", but instead you want the current version
of the
2007/10/23, Joe Wilson <[EMAIL PROTECTED]>:
> --- Klemens Friedl <[EMAIL PROTECTED]> wrote:
> > Has someone already used mingw to build
>
> http://www.sqlite.org/cvstrac/tktview?tn=931
the makefile looks outdated (2006-Dec-28).
The makefile (my makefile) itself is (from my understanding) not the
I that case you need to implenment a custom function and launch it from
a trigger.
d_maniger06 wrote:
im sorry but i havent get your point..im rather new in sqlite and i just need
to make a c program, that when i insert on a table in my database, something
is written on a file, or even just be
FYI: When this multi-row-insert patch is combined with today's CVS
OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]),
the multi-row ASCII INSERT statements are as much as 25% faster than
the equivalent number of traditional individual ASCII INSERT statements
within a transa
--- Klemens Friedl <[EMAIL PROTECTED]> wrote:
> 2007/10/23, Joe Wilson <[EMAIL PROTECTED]>:
> > --- Klemens Friedl <[EMAIL PROTECTED]> wrote:
> > > Has someone already used mingw to build
> >
> > http://www.sqlite.org/cvstrac/tktview?tn=931
>
> the makefile looks outdated (2006-Dec-28).
Not sure
Hi All,
I am exploring the use of the Virtual Table capability of SQLite 3.5.1
for implementing alternative backing store and have a couple of
questions for virtual table gurus:
Say I define a virtual table module registered as "custom" and then
define virtual table T as follows:
CREATE VIRTUAL
"Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am exploring the use of the Virtual Table capability of SQLite 3.5.1
> for implementing alternative backing store and have a couple of
> questions for virtual table gurus:
>
> Say I define a virtual table module registered as "cust
2007/10/23, Joe Wilson <[EMAIL PROTECTED]>:
> --- Klemens Friedl <[EMAIL PROTECTED]> wrote:
> > 2007/10/23, Joe Wilson <[EMAIL PROTECTED]>:
> > > --- Klemens Friedl <[EMAIL PROTECTED]> wrote:
> > > > Has someone already used mingw to build
> > > http://www.sqlite.org/cvstrac/tktview?tn=931
> > the
Joe,
that is quite interesting performance gain...
One thing that might help with this "multi row" insert is the concept
of binding address variables. IMHO, the binding functions (sqlite_bind_int etc)
should allow one to permanently bind an address to a placeholder.
Then you multi row insert c
Joe Wilson <[EMAIL PROTECTED]> wrote:
> FYI: When this multi-row-insert patch is combined with today's CVS
> OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]),
> the multi-row ASCII INSERT statements are as much as 25% faster than
> the equivalent number of traditional indiv
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > FYI: When this multi-row-insert patch is combined with today's CVS
> > OP_Real and OP_Int64 fix for Tickets #2733 and #2731 (Check-in [4507]),
> > the multi-row ASCII INSERT statements are as much as 25% faster than
> > th
You're solving a different problem. Better to stick with the
existing API for what you're proposing.
I just want a faster, more compact and flexible SQL INSERT command
from the command-line without resorting to custom programming.
--- Ken <[EMAIL PROTECTED]> wrote:
> Joe,
>
> that is quite int
Does anyone know of a good sql formatter that's compatible with
sqlite3's syntax?
I'm looking for a command line-based tool with sources that can be
cross-compiled to the usual suspects (Win32, Unix, Mac OS X).
-
To uns
Hey all,
I'm new to sqlite3, but it seems really cool, and I'm excited to be
using it in a project. I'm also new to database programming in C.
I've got a question, though. (I'm using SQLite 3.5.1 and C.) If
I've got my database pointer, sqlite3 *database, and I have two
threads that ar
Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
I should be able to use your test suite
s/your/the/
Sqlite and its test suite are drh's work.
Hmm ... Somehow I got the impression that the team of SQLite
core developers had expanded to include a few folks in addition
to drh, an
--- Richard Klein <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > --- Richard Klein <[EMAIL PROTECTED]> wrote:
> >> I should be able to use your test suite
> >
> > s/your/the/
> > Sqlite and its test suite are drh's work.
>
> Hmm ... Somehow I got the impression that the team of SQLite
> core
Same problem, just a different thought process.
The .dump format could me made to use a CSV making it more compact.
A new command ".imp" command could be made to use my proposed array based
processing. And also use DRH's recommendation to use a TXN
Unfortunately, .dump is generic for
How do I filter out records that contain WHITE SPACE in a field or
have this field empty?
For example:
select * from mytable
where fld <> "" and fld LIKE .
-
To unsubscribe, send email to [EMAIL PROTECTED]
---
--- Ken <[EMAIL PROTECTED]> wrote:
>A new command ".imp" command could be made to use my proposed array based
> processing.
There's already an .import command in the shell.
> I don't agree with the aproach of modify the SQL language to create a
> generic high speed
> loading interface.
Yuriy Martsynovskyy
<[EMAIL PROTECTED]> wrote:
How do I filter out records that contain WHITE SPACE in a field or
have this field empty?
For example:
select * from mytable
where fld <> "" and fld LIKE .
fld <> '' and not (fld LIKE '% %')
-- that's percent space percent
Igor Tandetnik
Hi, I've written an application in C that integrates sqlite-3.3.12. Up
to now for months everything was running fast and smooth.
Now, I installed sqlite3 and compiled my application on a different
computer.
The installations were ok, but upon activating my application, it quits
with the error:
...s
How do I filter out records that contain WHITE SPACE in a field or
have this field empty?
For example:
select * from mytable
where fld <> "" and fld LIKE .
Do you mean "contain ONLY white space"? Are you after this?
select * from mytable
where trim(fld) <> ""
---
Hi All,
Do you know any tool to compare two databases both schema and content of the
tables.
Thanks,
Jodie
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
Joe Wilson wrote:
--- Richard Klein <[EMAIL PROTECTED]> wrote:
I should be able to use your test suite
s/your/the/
Sqlite and its test suite are drh's work.
Hmm ... Somehow I got the impression that
I've been using SQLite on several minor projects now (it makes File IO so
easy), and the one suggestion I would make would be to make the
documentation (api reference) downloadable.
It would be very handy for myself and probably many others to be able to
download the API reference and keep it with
Andrew Wiley wrote:
I've been using SQLite on several minor projects now (it makes File IO so
easy), and the one suggestion I would make would be to make the
documentation (api reference) downloadable.
It would be very handy for myself and probably many others to be able to
download the API refer
ok..i have this sample code:
[code]
void printIfInsert()
{
printf( "Insertion was done in t1\n" );
}
void createTrigger( sqlite** db, sqlite_vm** pvm )
{
char* errMsg;
const char** psql = NULL;
const char* sql = "CREATE TRIGGER onInsertTrig AFTER INSERT on t2 BEGIN
printIfInsert;
Hello,
I have few questions on SQLite3, i'm using it through
pdo with php5.
- is unsigned int available?
- can we insert a row with an autoinc primary key, so
I don't need to provide it when I insert a new row?
- if NULL values are possible for primary keys, then
autoinc key can't have this NUL
Hi,
I second this request. I've been wondering for a long time why the
documentation isn't available off-line. How about making the documentation
available as a PDF file?
Kind regards, Olaf
- Original Message -
From: "Andrew Wiley" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October
d_maniger06 wrote:
ok..i have this sample code:
[code]
void printIfInsert()
{
printf( "Insertion was done in t1\n" );
}
void createTrigger( sqlite** db, sqlite_vm** pvm )
{
char* errMsg;
const char** psql = NULL;
const char* sql = "CREATE TRIGGER onInsertTrig AFTER INSERT on t2
A project for you. Pick up the documentation, transform it to PDF and
make it an Sqlite contribution on sqlite.org.
Olaf Beckman Lapré wrote:
Hi,
I second this request. I've been wondering for a long time why the
documentation isn't available off-line. How about making the
documentation ava
Aren't there any source documents? I assume the documentation wasn't written
in HTML originally.
Olaf
- Original Message -
From: "John Stanton" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, October 24, 2007 07:50
Subject: Re: [sqlite] Documentation - Downloadable?
A project for you. Pi
38 matches
Mail list logo