On Feb 19, 2008, at 11:46 PM, Cesar D. Rodas wrote:
> I want to know if some one had the althttp.c quoted here
> http://www.mail-archive.com/sqlite-users@sqlite.org/msg14449.html.
>
http://www.sqlite.org/docsrc/finfo?name=misc/althttpd.c
The link above probably won't work until you login. Use
Hello,
I was looking to the sqlite website after a long time and it looks very
great, it had growth notably and my congratulations for SQLite Consortium.
Well before I begin explaining my idea I want to know if some one had the
althttp.c quoted here
http://www.mail-archive.com/sqlite-users@sqlit
Twice recently, on different computers I've had clients lose their OS
X Address Book. Alas, they've not had backups. I've been able to
track down much of their data still remains in an sqlite3 data.syncdb
file. But when I access the DB, I find that tables with the actual
contacts have b
Rael Bauer <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
> 1. with sqlite Is it possible to have a primary key made up of 2 fields?
> (If so how...)
> (from firebird:
> ALTER TABLE "table1" ADD CONSTRAINT PK_TABLE1 PRIMARY KEY
> ("field1","field2");)
>
>
> 2. Is it possible to add a
Can somebody with the ability to compile and test for wince
please test check-in [4802] for me.
http://www.sqlite.org/cvstrac/chngview?cn=4802
For that matter, is there anybody out there who would like
to become the official wince maintainer for SQLite? If you
are able to compile, test, and d
Hi,
1. with sqlite Is it possible to have a primary key made up of 2 fields? (If
so how...)
(from firebird:
ALTER TABLE "table1" ADD CONSTRAINT PK_TABLE1 PRIMARY KEY
("field1","field2");)
2. Is it possible to add a primary key with an "ALTER" statement like:
ALTER TABLE
I believe the configure script is not maintained. It probably needs more
patches than this.
Mike
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Im Auftrag von Nicolas Williams
Gesendet: Mittwoch, 20. Februar 2008 00:19
An: General Discussion of SQLite Database
On Wed, Feb 20, 2008 at 12:09:16AM +0100, Michael Ruck wrote:
> This is most likely done to reduce compiled code size. For a lot of systems
> this code probably is wasted space, as the feature is not used everywhere.
> For embedded systems the ability to simply cut features at compile time to
> red
This is most likely done to reduce compiled code size. For a lot of systems
this code probably is wasted space, as the feature is not used everywhere.
For embedded systems the ability to simply cut features at compile time to
reduce code size is very important.
Mike
-Ursprüngliche Nachricht--
On Tue, Feb 19, 2008 at 2:08 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote:
> On Feb 19, 2008 3:59 PM, Scott Hess <[EMAIL PROTECTED]> wrote:
> > On Tue, Feb 19, 2008 at 1:49 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote:
> > > Also, I've seen references to fts3 -- is there a compelling reason for
> >
I searched and found that SQLITE_OMIT_LOAD_EXTENSION is defined by
default to protect applications that might otherwise unwittingly allow
SQL that loads extensions. I understand that, but, by default
extensions cannot be loaded until sqlite3_enable_load_extension() is
called to enable them. So wh
Hi Toby,
> I'm using the C++ API (although I'm not sure this matters), and need
> the
> names of all the tables I've put in the database (user tables?).
>
> From a quick google, it would appear I might need to use system tables
> or something like this, but I'm not too sure how to do this.
sele
On Feb 19, 2008 4:08 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote:
> Is fts3 built-in to sqlite? I don't build my own -- I use the tcl
> bindings and just download a binary. I'm too stingy to buy a microsoft
> compiler :-\
You would think after so many years in the industry I'd learn to spend
5 minu
Toby Roworth <[EMAIL PROTECTED]> wrote:
> I'm using the C++ API (although I'm not sure this matters), and need
> the names of all the tables I've put in the database (user tables?).
select name from sqlite_master where type='table';
Igor Tandetnik
__
On Feb 19, 2008 3:59 PM, Scott Hess <[EMAIL PROTECTED]> wrote:
> On Tue, Feb 19, 2008 at 1:49 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote:
> > Also, I've seen references to fts3 -- is there a compelling reason for
> > me to switch to fts3 from fts2?
>
> fts2 has a design flaw which can cause corru
I'm using the C++ API (although I'm not sure this matters), and need the
names of all the tables I've put in the database (user tables?).
From a quick google, it would appear I might need to use system tables
or something like this, but I'm not too sure how to do this.
Sorry if I sent this twice
On Tue, Feb 19, 2008 at 1:49 PM, Bryan Oakley <[EMAIL PROTECTED]> wrote:
> My code uses fts2, and for the first time today I discovered that no
> stemming appears to be going on under the covers. Googling around I
> see that I need to add "tokenize porter" when creating my table.
> Adding that
I'm revisiting a project I started a while ago, and have a question
about the FTS module(s). I haven't had my head wrapped around SQLite
in a long time -- I wrote the code, it works, and that's all I've had
to think about it for over year. So forgive me if I'm asking a common
question.
My code use
On 10.4.11 server (PPC), I am trying to build amalgamation 3.5.6. It
hangs on make
server2:/usr/local/src/sqlite-3.5.6 punkish$ make
if /bin/sh ./libtool --tag=CC --mode=compile gcc
-DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\"
-DPACKAGE_VERSION=\"3.5.6\" -DPACKAGE_STRING=\"sqlite\ 3.5.6\
[EMAIL PROTECTED] wrote:
> Honestly, the last time I did a WinCE compile was before the amalgamation, so
> I did not realize it had become so easy to compile for WinCE. Guess I'll be
> needing to make a new build when I get home tonight :)
>
> From: "Fin Springs" <[EMAIL PROTECTED]>
>
>>> Her
I have downloaded the amalgamation . I used devC++ builder/compiler by
bloodshed software.
The steps I took to compile the project
1. Create SQLite3 Project
2. Add files to project (sqlite3.c,sqlite3.h,sqlite3ext.h)
3.Go to Project -project options
4.Under Compiler tab ,select optimization->furth
On Feb 19, 2008 3:10 PM, Fin Springs <[EMAIL PROTECTED]> wrote:
> > Here's a link to an WinCE port: http://sqlite-wince.sourceforge.net/
> Is there a reason to use this port any more? The straight 3.5.6
> amalgamation compiles and runs fine for me on Windows CE 5.0 and
> includes specific '#if OS_W
Honestly, the last time I did a WinCE compile was before the amalgamation, so I
did not realize it had become so easy to compile for WinCE. Guess I'll be
needing to make a new build when I get home tonight :)
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftwar
"David A. Cobb" <[EMAIL PROTECTED]> wrote:
> It appears that, given SQLite's Manifest Typing, the appropriate type of
> a UUID -- 16bytes, binary -- would be BLOB. One would not want to try
> converting the ID to anything, if only for the cost in time.
>
> Can a BLOB be the Primary Key for a ta
It appears that, given SQLite's Manifest Typing, the appropriate type of
a UUID -- 16bytes, binary -- would be BLOB. One would not want to try
converting the ID to anything, if only for the cost in time.
Can a BLOB be the Primary Key for a table?
TIA
___
vl.pavlov wrote:
>
> C++ aplication should put words into sqlite3 database, but if word that
> should be put into the dbase is already in the table of the dbase it should
> increase the number which is in the second column of the same row. how?
>
> eg:
> coffee | 3
> milk | 1
>
> ...
>
> i use
> Here's a link to an WinCE port: http://sqlite-wince.sourceforge.net/
Is there a reason to use this port any more? The straight 3.5.6
amalgamation compiles and runs fine for me on Windows CE 5.0 and
includes specific '#if OS_WINCE' sections for CE (to define localtime,
etc).
__
Hi all,
While playing around with sqlit3_open_v2, I was unpleasantly surprised
to find that my (test) database was deleted after opening it. It
turned out I was using
sqlite3_open_v2("test.db", &db, SQLITE_READONLY, 0);
instead of
sqlite3_open_v2("test.db", &db, SQLITE_OPEN_READONLY, 0);
Digg
hello 2 all
C++ aplication should put words into sqlite3 database, but if word that
should be put into the dbase is already in the table of the dbase it should
increase the number which is in the second column of the same row. how?
eg:
coffee | 3
milk | 1
...
i use standard functions from sqli
Here's a link to an WinCE port: http://sqlite-wince.sourceforge.net/
You can also check out this: http://www.sqlite.org/cvstrac/wiki?p=SqlitePorts
And: http://www.sqlite.org/cvstrac/wiki?p=SqlitePalm
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/
---
SQL Maestro Group announces the release of AnySQL Maestro - a freeware, but
powerful tool for all the database engines accessible via ODBC driver or OLE
DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL,
SQLite, etc).
http://www.sqlmaestro.com/products/anysql/maestro/
AnySQL M
Sam Carleton a écrit :
> I see that SQLite runs on Windows, OSX, and *NIX, will it run on
> Windows Mobile (CE) or any embedded OS's?
>
It runs on any CE that I know
Noel
> Sam
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqli
I see that SQLite runs on Windows, OSX, and *NIX, will it run on
Windows Mobile (CE) or any embedded OS's?
Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
33 matches
Mail list logo