Hi there,
I will need to get SQLite working soon on AIX. I have read the compile notes
from 2003 at http://www.sqlite.org/cvstrac/wiki?p=HowToCompile but was just
wondering if anyone has it running happily on AIX with the newer versions of
SQLIte?
Any hints or suggestions from people who have
On Wed, Sep 14, 2011 at 6:06 AM, Freddy López freddy.vat...@gmail.comwrote:
I would like to know if you can help me with it. My knowledge of C is poor.
We can't possibly help until we know what the problem is. Can you please
post the compiler output?
--
- stephan beal
When using OMIT_VIRTUALTABLE, I get a warning at line 11688 (3.7.7.1
amalgamation) that sqlite3GetVTable is used but never defined.
If I add
#ifndef SQLITE_OMIT_VIRTUALTABLE
#endif
around it, I get an error at line 81609, because this function is actually
used there!
a) Is this a bug, and when
I just realized the line numbers I gave are meaningless as they apply to my
custom amalgamation (generated with a bunch of OMIT_*).
Here is a better explanation of where to find these lines:
The first is near the end (4 lines up) of a block that starts with
#ifdef SQLITE_OMIT_VIRTUALTABLE
#
Hi,
I'm trying to access the extension-functions.c file from
http://www.sqlite.org/contrib but that page does not work. I need the
STDEV() function. Am I looking in the right place?
Thanks.
Bruce
___
sqlite-users mailing list
sqlite-users@sqlite.org
I was unaware of this. I thought it started to write to a Journal file
during the backup and then persisted it afterward. However, if this
scenario was happening, wouldn't the file size tend to jump around
sporadically around 200Mb instead of settling into one specific size?
On Tue, Sep 13, 2011
On 09/14/2011 03:38 PM, Baruch Burstein wrote:
When using OMIT_VIRTUALTABLE, I get a warning at line 11688 (3.7.7.1
amalgamation) that sqlite3GetVTable is used but never defined.
If I add
#ifndef SQLITE_OMIT_VIRTUALTABLE
#endif
around it, I get an error at line 81609, because this function is
Dear SQLite developers,
I think that named table constraints is great feature of DBMS engine. It
helps users of DB to centralize business logic as close to the data as
possible.
Do you plan to include this feature in the SQLite engine in future?
Example:
create table LOG (
ID integer primary
I did this. This produces a customized amalgamation. This is the
amalgamation I was referring to. Please see my follow-up mail.
On Wed, Sep 14, 2011 at 11:57 AM, Dan Kennedy d...@sqlite.org wrote:
On 09/14/2011 03:38 PM, Baruch Burstein wrote:
When using OMIT_VIRTUALTABLE, I get a warning at
On 13 Sep 2011, at 7:36pm, David Holtkamp wrote:
I was unaware of this. I thought it started to write to a Journal file
during the backup and then persisted it afterward. However, if this
scenario was happening, wouldn't the file size tend to jump around
sporadically around 200Mb instead of
On 14 Sep 2011, at 12:38pm, Eugene Viter wrote:
I think that named table constraints is great feature of DBMS engine. It
helps users of DB to centralize business logic as close to the data as
possible.
Do you plan to include this feature in the SQLite engine in future?
Example:
create
On Wed, Sep 14, 2011 at 6:09 AM, Freddy López freddy.vat...@gmail.comwrote:
I forget attach messages I get.
The first few compile errors imply that some header(s) (or declarations)
is/are missing, but i can't say which ones.
extension-functions.c:206:17: error: expected ‘=’, ‘,’, ‘;’, ‘asm’
In either case the wrapping and registration with
sqlite_create_collation_v2
is quite easy.
Yes, it is. I thought that the actual algorithm would be harder but I was
wrong.
It's surprisingly ease and simple to build a simple algorithm to handle utf8
ASCII and Latin Basic plane with standard
You can try my quick and dirty pseudo-universal extension for
less-than-perfect Unicode support.
Go download the extension at http://dl.dropbox.com/u/**
26433628/unifuzz.zip http://dl.dropbox.com/u/26433628/unifuzz.zip. Take
the time to fully read the explanations at top of the source
Hi All,
Does sqlite has encryption feature or not. If yes, how to do it and if No,
then is there any work around by which we can have that feature ??
Regards,
Ashokkumar
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 09/11/2011 08:27 PM, Antonio Maniero wrote:
It's very easy to replace the SQLite functions with user-defined ones,
so if someone wants to go the easy way (partial support for just the
common western scripts) it's easy. And already done by many, if you
search the mailing list.
It's exactly
On 14 Sep 2011, at 6:53pm, Ashokkumar Gupta wrote:
Does sqlite has encryption feature or not. If yes, how to do it and if No,
then is there any work around by which we can have that feature ??
The free version of SQLite has no encryption feature. There's a version with
encryption which
I added some functions to do that. I have ENCCOL, DECCOL, SIGCOL
(signature creation), CHECKSIG
Inserts and selects look something like this:
INSERT INTO TABLE x(col1) VALUES(ENCCOL(1))
SELECT DECCOL(col1) FROM x;
Nothing I want in an index can be encrypted, which is where SIGCOL comes
in, I can
On Mon, Sep 12, 2011 at 12:16:55 -0400, Igor Tandetnik wrote:
On 9/12/2011 12:02 PM, Mr. Puneet Kishor wrote:
On Sep 12, 2011, at 6:51 AM, Igor Tandetnik wrote:
Something like this:
select geo.id, min_age, max_age, age_bottom, age_top, name, color
from geo left join intervals i on i.id =
Have a look at:
http://sqlcipher.net
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ashokkumar Gupta
Sent: Wednesday, September 14, 2011 1:53 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How to : encrypt the data of
On Sep 14, 2011, at 3:14 PM, Simon Slavin wrote:
SQLite supports both column and table constraints:
Yes, but that's not the problem at hand.
Your exact text may not work to generate exactly the error you expect, but
you should find something similar.
That's the crux of the issue, as the
On 9/14/2011 2:07 PM, Jan Hudec wrote:
On Sep 12, 2011, at 6:51 AM, Igor Tandetnik wrote:
select geo.id, min_age, max_age, age_bottom, age_top, name, color
from geo left join intervals i on i.id = (
select id from intervals
where age_bottom=
(select age_bottom from intervals
On Sep 14, 2011, at 8:40 PM, Igor Tandetnik wrote:
Think about it this way. You have a phone book, where names are sorted by
last name, then first name. You want to find all people whose last name is
greater than 'Smith' and first name less than 'John'. The alphabetic order
helps you with
I have this database of employees. A simple select looks like this:
select ename, job from emp order by job;
ENAME, JOB
==
SCOTT, ANALYST
FORD, ANALYST
SMITH, CLERK
ADAMS, CLERK
JAMES, CLERK
MILLER, CLERK
JONES, MANAGER
BLAKE, MANAGER
CLARK, MANAGER
KING,
On Sep 14, 2011, at 8:55 PM, Magnus Thor Torfason wrote:
Now, I get a list of the jobs, and a random selection of employees. I would
have expected an error here. Of course, my actual query was different (this
is based on the Oracle example data base from very old days), but it was also
On 9/14/2011 2:55 PM, Magnus Thor Torfason wrote:
I then ran a query grouping employees by job:
select ename, job from emp group by job;
ENAME, JOB
==
FORD, ANALYST
MILLER, CLERK
CLARK, MANAGER
KING, PRESIDENT
TURNER, SALESMAN
Now, I get a list of the jobs, and a random
Would be pragma to reverse unordered selects show a different result?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Petite Abeille wrote:
On Sep 14, 2011, at 8:55 PM, Magnus Thor Torfason wrote:
Now, I get a list of the jobs, and a random selection of employees. I would
have expected an error here. Of course, my actual query was different (this
is based on the Oracle example data base from very old days),
Just wanted to add a small warning: the problem with using custom
collations is that if you use them in indexes, then all applications that
use the same database must also have the same collation for everything to
work OK.
I'm aware of this. Thanks.
I will build the like function too but
On Wed, Sep 14, 2011 at 02:55:06PM -0400, Magnus Thor Torfason scratched on the
wall:
I have this database of employees. A simple select looks like this:
Now, I get a list of the jobs, and a random selection of employees.
I would have expected an error here. Of course, my actual query was
On Wed, Sep 14, 2011 at 12:24:57PM -0700, Gerry Snyder scratched on the wall:
Would be pragma to reverse unordered selects show a different result?
Very likely, yes.
http://sqlite.org/pragma.html#pragma_reverse_unordered_selects
-j
--
Jay A. Kreibich J A Y @ K R E I B I.C H
On Sep 14, 2011, at 9:27 PM, Darren Duncan wrote:
Petite Abeille wrote:
On Sep 14, 2011, at 8:55 PM, Magnus Thor Torfason wrote:
Now, I get a list of the jobs, and a random selection of employees. I would
have expected an error here. Of course, my actual query was different (this
is based
Hello. I use sqlite3 python.
I followed exactly the steps to create a foreign key from the site
http://www.sqlite.org/foreignkeys.html but I still can insert enter values
not allowed for constraint.
Before I do the insert properly executed the instruction PRAGMA
FOREIGN_KEYS =ON but did not
Thank you all
On 13 sep, 22:24, Jay A. Kreibich j...@kreibi.ch wrote:
On Tue, Sep 13, 2011 at 09:16:32PM +0100, Simon Slavin scratched on the wall:
On 13 Sep 2011, at 7:22pm, Petite Abeille wrote:
On Sep 13, 2011, at 2:15 PM, Simon Slavin wrote:
It's about chunkiness, and which of
On 14 Sep 2011, at 9:46pm, Fabio Spadaro wrote:
Hello. I use sqlite3 python.
I followed exactly the steps to create a foreign key from the site
http://www.sqlite.org/foreignkeys.html but I still can insert enter values
not allowed for constraint.
So you get no error from the INSERT
On 15-Sep-2011, at 2:55 AM, Magnus Thor Torfason wrote:
I then ran a query grouping employees by job:
select ename, job from emp group by job;
ENAME, JOB
==
FORD, ANALYST
MILLER, CLERK
CLARK, MANAGER
KING, PRESIDENT
TURNER, SALESMAN
Now, I get a list of the
On Thu, Sep 15, 2011 at 07:00:43AM +0800, Mohd Radzi Ibrahim scratched on the
wall:
On 15-Sep-2011, at 2:55 AM, Magnus Thor Torfason wrote:
I then ran a query grouping employees by job:
select ename, job from emp group by job;
ENAME, JOB
==
FORD, ANALYST
Forgive me, fore I have forgotten the term used to describe the behavior if
a C if statement where it stops executing on the first false statement,
but... Does coalesce do that?
I have to put together a query that has a coalesce such that if the row from
the table is null, it then does a
On 9/14/2011 9:03 PM, Sam Carleton wrote:
Forgive me, fore I have forgotten the term used to describe the behavior if
a C if statement where it stops executing on the first false statement,
but... Does coalesce do that?
The word you are looking for is short-circuit, and no, unfortunately,
I build the latest version of SQLite on AIX regularly, using IBM's C compiler.
GNU will probably work just as well.
Feel free to email me directly if you have questions. I can't be much help
with GNU, but perhaps I can be with problems during the SQLite build.
Good luck.
--
Ross
On Sep
Hi Ross,
Many thanks for your response, I really appreciate it and will definitely drop
you a quick email if I have any issues with the build.
I am going to install GCC onto the AIX 5.3 box and will give it a try. I have
never used the IBM C compiler..do you prefer it to GCC?
Chat soon
41 matches
Mail list logo