[sqlite] Result of checking SQLite with PVS-Studio static code analyzer

[info]

Hello, I just did a quick check of SQLite version 3.24.0 with PVS-Studio 
(https://www.viva64.com), a static code analyzer.


I have singled out a few strange code fragments that the analyzer warned 
about that I think could be real bugs:


1. ext\misc\fileio.c:207 Last argument of memset() is 
"sizeof(WIN32_FIND_DATA)", however, the data type of variable "fd" is 
"WIN32_FIND_DATAW" (NOTE: wide version with W at end). The size of these 
two data types differ (at least on my machine) and I assume 
"sizeof(WIN32_FIND_DATAW)" should be used instead.
2. src\insert.c:908 "==" has higher precedence than "&&" so code will be 
executed as "== (0 && ...)". I assume programmer wanted "((pColumn==0) 
&& ...)".
3. src\os_win.c On lines 3299 and 3306 both if-statements have the same 
conditionals ("locktype==EXCLUSIVE_LOCK && res"). Based on the comment 
before the first if-statment maybe it should be "locktype==PENDING_LOCK" 
in the first if-statement?
4. tool\lemon.c:2860 Before returning on line 2860 you forgot to free() 
"filebuf".


Regards, Johan Mattsson
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] db File Remains Open After Connection is Closed

[RNACS - Info]

Simon,

Does not help.  I put a breakpoint at the "SQLconn = Nothing" statement &
checked the value of SQLconn.State. It was "Closed", so I continued one &
still got the error.

Ray

-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Simon
Slavin
Sent: Thursday, March 05, 2015 3:58 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] db File Remains Open After Connection is Closed


> On 5 Mar 2015, at 8:34pm, RNACS - Info  wrote:
> 
> The code I am using is:
> 
>' Close license database connection 
>If Not IsNothing(SQLconn) Then
>If SQLconn.State <> ConnectionState.Closed Then
>SQLconn.Close()
>End If
>SQLconn = Nothing
>End If

After "SQLconn.Close()", check again the state of the connection to see if
it was successfully closed.  If not, display an error message.

Simon.
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] db File Remains Open After Connection is Closed

[RNACS - Info]

No.  Any commands will have finished before the user can get to the screen
that allows them to move the data files.

Ray Andrews

-Original Message-
From: sqlite-users-boun...@mailinglists.sqlite.org
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of J Decker
Sent: Thursday, March 05, 2015 3:45 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] db File Remains Open After Connection is Closed

do you have any ... SqliteCommand's laying around that aren't finished?

On Thu, Mar 5, 2015 at 12:34 PM, RNACS - Info  wrote:

> I have a program written in Visual Basic .NET.
>
> One of the functions of the program is to move all of the program's 
> data, including a SQLite database to a different folder.
>
> The program is a 32-bit application using System.Data.SQLite.dll.
>
> I am having a problem that after I copy the data to the new folder, 
> the program fails when I try to delete the old folder.  The error 
> message says that the folder cannot be deleted because the SQLite 
> database file is in use by another process.
>
> The code I am using is:
>
> ' Close license database connection
> If Not IsNothing(SQLconn) Then
> If SQLconn.State <> ConnectionState.Closed Then
> SQLconn.Close()
> End If
> SQLconn = Nothing
> End If
>
> ' Move data files
>  '\ code to move files goes here
>
> ' Delete old directory
>  Directory.Delete(strOldLocation,
> FileIO.DeleteDirectoryOption.DeleteAllContents)
>
> The error occurs when I try to execute the "Directory.Delete" statement.
>
> "SQLconn" is a SQLiteConnection to my database file.  Once the 
> connection is closed & disposed of, what still has the .db file still 
> open?  How do I close the file so I can delete it?
>
> Thank you for any assistance.
>
> Ray Andrews
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] db File Remains Open After Connection is Closed

[RNACS - Info]

I have a program written in Visual Basic .NET.

One of the functions of the program is to move all of the program's data,
including a SQLite database to a different folder.

The program is a 32-bit application using System.Data.SQLite.dll.

I am having a problem that after I copy the data to the new folder, the
program fails when I try to delete the old folder.  The error message says
that the folder cannot be deleted because the SQLite database file is in use
by another process.

The code I am using is:

' Close license database connection 
If Not IsNothing(SQLconn) Then
If SQLconn.State <> ConnectionState.Closed Then
SQLconn.Close()
End If
SQLconn = Nothing
End If

' Move data files
 '\ code to move files goes here

' Delete old directory
 Directory.Delete(strOldLocation,
FileIO.DeleteDirectoryOption.DeleteAllContents)

The error occurs when I try to execute the "Directory.Delete" statement.  

"SQLconn" is a SQLiteConnection to my database file.  Once the connection is
closed & disposed of, what still has the .db file still open?  How do I
close the file so I can delete it?

Thank you for any assistance.

Ray Andrews

[sqlite] System.Data.SQLite

[info]

Hello,

 

I installed System.Data.SQLite (1.80) to my system.

The testprogram runs fine.

When putting the reference into VS Studio 2008 it takes an error: reference
can´t be found.

I copied the dll in several directories in my program without success.

I tried all the things I know but I can´t get it run.

Can anyone help?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite and OpenOffice

[Phil Hansen - Info]

Phil Hansen - Info wrote:
> Have just started using Sqlite and have got a simple database created 
> and populated.
> Found that OO base can be used to access Sqlite.
> However the literature is a bit vague.
> I downloaded the .zip file which should be copied to 
> openoffice1.1/user/uno_packages.
> No such folder. Did find /usr/lib/openoffice/ but no user/uno_packages 
> so made the folders and copied the .zip file there.
> Next instruction is go to the openoffice1.1/program dir and execute the 
> pkgchk tool.
> Again no such folder but did find /usr/lib/openoffice/program but there 
> is no pkgchk.
> 
> Now lost. Any ideas on what I have done wrong and what to do get it up 
> and running.
> 
> Thanks

Forgot to mention I am using Ubuntu 9.04 as OS

-- 

Phillip Hansen
Skil-Phil Solutions
Phone - 0332677266
Cell - 0824541247
Fax - 0866552138
--

A goldfish has a memory span of three seconds.
I know people who can beat this.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite and OpenOffice

[Phil Hansen - Info]

Have just started using Sqlite and have got a simple database created 
and populated.
Found that OO base can be used to access Sqlite.
However the literature is a bit vague.
I downloaded the .zip file which should be copied to 
openoffice1.1/user/uno_packages.
No such folder. Did find /usr/lib/openoffice/ but no user/uno_packages 
so made the folders and copied the .zip file there.
Next instruction is go to the openoffice1.1/program dir and execute the 
pkgchk tool.
Again no such folder but did find /usr/lib/openoffice/program but there 
is no pkgchk.

Now lost. Any ideas on what I have done wrong and what to do get it up 
and running.

Thanks
-- 
Phillip Hansen


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

RE: [sqlite] How do I get MATCH and REGEXP

[Info]

So, if I understand correctly, SQLite does not support these two operators
"out of the box".
Is there an easy way to get user-defined functions for regexp and match? Or
has no one developed those yet?

Regards,
Rick van der Lans

-Oorspronkelijk bericht-
Van: Kees Nuyt [mailto:[EMAIL PROTECTED] 
Verzonden: Friday, February 09, 2007 10:55 PM
Aan: sqlite-users@sqlite.org
Onderwerp: Re: [sqlite] How do I get MATCH and REGEXP


On Fri, 9 Feb 2007 21:11:31 +0100, Rick wrote:

>The manual mentions the support for the MATCH and the REGEXP operators. But
>if I use it, it doesn't work. Do I have to do something special to install
>those operators?

http://www.sqlite.org/lang_expr.html tells:

"The REGEXP operator is a special syntax for the regexp() user
function. No regexp() user function is defined by default and so
use of the REGEXP operator will normally result in an error
message. If a user-defined function named "regexp" is added at
run-time, that function will be called in order to implement the
REGEXP operator.

The MATCH operator is a special syntax for the match() user
function. The default match() function implementation raises and
exception and is not really useful for anything. But extensions
can override the match() function with more helpful logic."

>Regards,
>Rick van der Lans

HTH
-- 
  (  Kees Nuyt
  )
c[_]


-
To unsubscribe, send email to [EMAIL PROTECTED]

-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] How do I get MATCH and REGEXP

[Info]

The manual mentions the support for the MATCH and the REGEXP operators. But
if I use it, it doesn't work. Do I have to do something special to install
those operators?

Regards,
Rick van der Lans




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] Does julianday work according to the manual?

[Info]

Thanks for your help, guys,
It now makes sense.

Rick van der Lans

-Oorspronkelijk bericht-
Van: Doug Currie [mailto:[EMAIL PROTECTED] 
Verzonden: Wednesday, January 31, 2007 4:16 PM
Aan: sqlite-users@sqlite.org
Onderwerp: Re: [sqlite] Does julianday work according to the manual?

On Wednesday, January 31, 2007 Rick van der Lans wrote:

> The manual states that the function julianday returns the number of days
> since noon in Greenwich on November 24, 4714 B.C. That would imply that
the
> statement:

> Select julianday('-4714-11-24 12:00:00');

> Should return 0.0. But it doesn't, it returns -365.0

> Does this mean, that the manual should say "since noon in Greenwich on
> November 24, 4713 B.C.? Or am I missing something?


sqlite> Select julianday('-0001-11-24 12:00:00');
1721022.0
sqlite> Select julianday('-11-24 12:00:00');
1721388.0
sqlite> Select julianday('0001-11-24 12:00:00');
1721753.0

There is no year 0. The calendar goes from -1 BCE to 1 CE. -11-24
is 1 BCE. So, if you want November 24, 4714 B.C. you need to say

sqlite> Select julianday('-4713-11-24 12:00:00');
0.0

e

-- 
Doug Currie
Londonderry, NH, USA



-
To unsubscribe, send email to [EMAIL PROTECTED]

-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] joins, brackets and non-existing columns

[Info]

If I use the following inner join of 3 tables:

SELECT  T1.A
FROM(T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B

SQLite returns an error message saying that the column T1.A does not exist.
If I run this statement on MysQL, Oracle or DB2, they accept it. And in
fact, this is correct SQL.
If I remove the brackets, SQLite also accepts it. But sometimes you want to
work with brackets, if you are combining inner and left outer joins.

Any idea why this is not accepted by SQLite?

Rick van der Lans




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

RE: [sqlite] adding years,months, days with decimals using datetime function

[info]

So, it is not a bug but an unadvertised feature. :-)

What will happen most likely? That working with decimals for years will also
be added in the future, or that working with decimals for months and days
will be removed?

Rick van der Lans

-Oorspronkelijk bericht-
Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Verzonden: woensdag 31 januari 2007 17:04
Aan: sqlite-users@sqlite.org
Onderwerp: Re: [sqlite] adding years,months, days with decimals using
datetime function

"info" <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> If I use the expression datetime('2000-01-01','1.5 months'), SQLite
returns
> 2000-02-16 00:00:00. This means that it added one month plus half a month.
> Makes sense.
> 
> If I use the expression datetime('2000-01-01','1.5 days'), I get
2000-01-02
> 12:00:00. Again this makes sense: 1.5 days is equal to 1 day plus 12
hours.
> 
> But with the expression datetime('2000-01-01','1.5 years') the result is
> 2001-01-01 00:00:00. Which means, SQLite added only 1 year and not an
extra
> 6 months.
> 
> Can anyone explain why using decimals works for months and days and not
for
> years?
> 

Because nobody has ever written the code to do that.  :-)
--
D. Richard Hipp  <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]

-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] adding years,months, days with decimals using datetime function

[info]

Hi,

If I use the expression datetime('2000-01-01','1.5 months'), SQLite returns
2000-02-16 00:00:00. This means that it added one month plus half a month.
Makes sense.

If I use the expression datetime('2000-01-01','1.5 days'), I get 2000-01-02
12:00:00. Again this makes sense: 1.5 days is equal to 1 day plus 12 hours.

But with the expression datetime('2000-01-01','1.5 years') the result is
2001-01-01 00:00:00. Which means, SQLite added only 1 year and not an extra
6 months.

Can anyone explain why using decimals works for months and days and not for
years?

Rick van der Lans




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Does julianday work according to the manual?

[info]

Hi,

The manual states that the function julianday returns the number of days
since noon in Greenwich on November 24, 4714 B.C. That would imply that the
statement:

Select julianday('-4714-11-24 12:00:00');

Should return 0.0. But it doesn't, it returns -365.0

Does this mean, that the manual should say "since noon in Greenwich on
November 24, 4713 B.C.? Or am I missing something?

Rick van der Lans




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] multiple order by value bug?

[info]

Hi list, 



sqlite version: 3.3.8 

I have 2 tables: 


---
CREATE TABLE kereset (realid INTEGER NOT NULL, id INTEGER NOT NULL, datum 
DATETIME, jogcim CHAR(1) NOT NULL, brutto INT NOT NULL, ado INT NOT NULL, 
adoalap INT NOT NULL); 

CREATE TABLE szemely (id INTEGER NOT NULL, nev VARCHAR(128) NOT NULL COLLATE 
MAGYAR, leanynev VARCHAR(128) COLLATE MAGYAR, anyanev VARCHAR(128) COLLATE 
MAGYAR, szulhely VARCHAR(128) COLLATE MAGYAR, szuldat DATETIME, adoszam 
VARCHAR(10), irszam INT, varos VARCHAR(64) COLLATE MAGYAR, cim VARCHAR(128) 
COLLATE MAGYAR, telefon VARCHAR(64), adoalap INT, adosav INT, szolgdij INT, 
torolve BOOLEAN DEFAULT FALSE);
--- 


my query:
---
SELECT szemely.nev, szemely.anyanev, szemely.szulhely, szemely.adoszam, 
kereset.datum,szemely.id FROM szemely,kereset WHERE (kereset.datum >= 
19950101 AND kereset.datum <= 19951231) AND (szemely.nev >= '000' AND 
szemely.nev <= 'zzz') AND kereset.id = szemely.id ORDER BY 
szemely.nev,szemely.anyanev
--- 

This query works fine (I think my collate function too), but if I accomodate 
it with "ORDER BY szemely.nev,szemely.anyanev,kereset.datum", then sorting 
is in wrong order. 

If you need it, I send my collate function. 


regards
---
kiru


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] problems to install pysqlite

[SKORPIO-INFO]

SKORPIO-INFO ha scritto:

  
Accidents!! I do not succeed re-install pysqlite!!! they give always
this error to me!!
  
  
  
You can help me?
  
p.s.  with all the versions, also the previous ones!!

Re: [sqlite] Query select....

[SKORPIO-INFO]

That is? excuse but creed not to have understood your participation... :)
However I have resolved my problem that was a syntax error of which
I did not succeed to understand of the reason then but... I have 
resolved

Hi Max
Martins Mozeiko ha scritto:
And now tell us, which part of your problem relates to SQLite? :)
--
Martins
From: SKORPIO-INFO [EMAIL PROTECTED]
Date: Fri,  1 Apr 2005 15:17:56 +0300
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Query select
 

ok :)
I have resolved this problem:
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE 
data_slot='01-04-2005' AND ((num_slot > "+str(contatore[1])+") AND 
(num_slot < "+str(contatore[0])+"))")

Thanks
SKORPIO-INFO ha scritto:
   

Hi to all,
I have the necessity to carry out a query that it must find an 
occurrence to me in which the date is x and that a data field is 
comprised between y and z

This is the example:
contatore = [20,33]
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE 
data_slot='01-04-2005' AND ((num_slot > contatore[1]) AND (num_slot < 
contatore[0]))")

thi is the table:
CREATE TABLE slot( id_slot INTEGER(11) PRIMARY KEY, univocal_number 
VARCHAR(12), data_slot VARCHAR(10), num_slot VARCHAR(5) )

the error reporting is:
DatabaseError: near "[1]": syntax error
Help Me :)

 

 

Re: [sqlite] Query select....

[SKORPIO-INFO]

ok :)
I have resolved this problem:
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE 
data_slot='01-04-2005' AND ((num_slot > "+str(contatore[1])+") AND 
(num_slot < "+str(contatore[0])+"))")

Thanks
SKORPIO-INFO ha scritto:
Hi to all,
I have the necessity to carry out a query that it must find an 
occurrence to me in which the date is x and that a data field is 
comprised between y and z

This is the example:
contatore = [20,33]
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE 
data_slot='01-04-2005' AND ((num_slot > contatore[1]) AND (num_slot < 
contatore[0]))")

thi is the table:
CREATE TABLE slot( id_slot INTEGER(11) PRIMARY KEY, univocal_number 
VARCHAR(12), data_slot VARCHAR(10), num_slot VARCHAR(5) )

the error reporting is:
DatabaseError: near "[1]": syntax error
Help Me :)

[sqlite] Query select....

[SKORPIO-INFO]

Hi to all,
I have the necessity to carry out a query that it must find an 
occurrence to me in which the date is x and that a data field is 
comprised between y and z

This is the example:
contatore = [20,33]
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE 
data_slot='01-04-2005' AND ((num_slot > contatore[1]) AND (num_slot < 
contatore[0]))")

thi is the table:
CREATE TABLE slot( id_slot INTEGER(11) PRIMARY KEY, univocal_number 
VARCHAR(12), data_slot VARCHAR(10), num_slot VARCHAR(5) )

the error reporting is:
DatabaseError: near "[1]": syntax error
Help Me :)

Re: [sqlite] error query???

[SKORPIO-INFO]

ok but if I put the "begin" before query me it says:
DatabaseError: cannot start a transaction within a transaction
if I do not put it the "begin", it makes the query correctly me but it 
gives back the following
message to me:

Exception _sqlite.DatabaseError: 'cannot rollback - no transaction is 
active' in > ignored

if instead it does not put not even "commit" the operations nonm they
come truly carried out on the database!!?
what I must make then?


Dan Kennedy ha scritto:
This is just a guess.
SQLite has no implicit transaction like Oracle and some other systems.
So to do the 'commit', you have to first do 'begin'. Otherwise each
SQL command is in it's own little transaction, automatically committed.
Dan.
--- SKORPIO-INFO <[EMAIL PROTECTED]> wrote:
 

ah!! opsss  .  this is the query
   # Esecuzione delle modifiche selezionate
   def ExecuteMixChange(self, event):
   # Effettuo la connessione al database
   DATABASE = sqlite.connect('CF_BSS.db')
   # Assegnazione del cursore
   DB_BSS = DATABASE.cursor()
   for x in self.QUERY_MIX:
   query_command = self.QUERY_MIX[x]   <<<===  questo è un 
dizionario che contiene le query che ho raccolto e che faccio fare tutte 
insieme cliccando il pulsante di applicazuione modifiche :):)

   DB_BSS.execute( query_command )
   print query_command
   # Effettuo la conferma delle query eseguite
   DB_BSS.execute('commit')  ###<<<===  questo è il commit che 
do io .è sbagliato???  ... non mi sembra però ??
   # Effettuo la chiusura della connessione al database
   DB_BSS.close()
   # Messaggio di avviso per il riavvio del programma
   all_function.WindowMessageInfo("info", FILE_LINGUA, 1002, self)


hi!!
SKORPIO-INFO ha scritto:
   

hi!! sorry fo my english.
UPDATE mission_name SET ability = '0' WHERE id_mission = '1'
why if I make this query me it goes to good aim but it gives back this
error to me?
---
Exception _sqlite.DatabaseError: 'cannot rollback - no transaction is 
active' in > ignored
---

the table is this:
create table mission_name(id_mission integer(11) primary key, 
name_mission varchar(40), ability varchar(2))

an insertion:
insert into mission_name(id_mission, name_mission, ability) 
values(\'1\', \'ACQUARIUS\', \'1\')

thanks!! :)

 

   


		
__ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/ 

 

Re: [sqlite] error query???

[SKORPIO-INFO]

ah!! opsss  .  this is the query
   # Esecuzione delle modifiche selezionate
   def ExecuteMixChange(self, event):
   # Effettuo la connessione al database
   DATABASE = sqlite.connect('CF_BSS.db')
   # Assegnazione del cursore
   DB_BSS = DATABASE.cursor()
   for x in self.QUERY_MIX:
   query_command = self.QUERY_MIX[x]   <<<===  questo è un 
dizionario che contiene le query che ho raccolto e che faccio fare tutte 
insieme cliccando il pulsante di applicazuione modifiche :):)

   DB_BSS.execute( query_command )
   print query_command
   # Effettuo la conferma delle query eseguite
   DB_BSS.execute('commit')  ###<<<===  questo è il commit che 
do io .è sbagliato???  ... non mi sembra però ??
   # Effettuo la chiusura della connessione al database
   DB_BSS.close()
   # Messaggio di avviso per il riavvio del programma
   all_function.WindowMessageInfo("info", FILE_LINGUA, 1002, self)


hi!!
SKORPIO-INFO ha scritto:
hi!! sorry fo my english.
UPDATE mission_name SET ability = '0' WHERE id_mission = '1'
why if I make this query me it goes to good aim but it gives back this
error to me?
---
Exception _sqlite.DatabaseError: 'cannot rollback - no transaction is 
active' in > ignored
---

the table is this:
create table mission_name(id_mission integer(11) primary key, 
name_mission varchar(40), ability varchar(2))

an insertion:
insert into mission_name(id_mission, name_mission, ability) 
values(\'1\', \'ACQUARIUS\', \'1\')

thanks!! :)

[sqlite] error query???

[SKORPIO-INFO]

hi!! sorry fo my english.
UPDATE mission_name SET ability = '0' WHERE id_mission = '1'
why if I make this query me it goes to good aim but it gives back this
error to me?
---
Exception _sqlite.DatabaseError: 'cannot rollback - no transaction is 
active' in > ignored
---

the table is this: 

create table mission_name(id_mission integer(11) primary key, 
name_mission varchar(40), ability varchar(2))

an insertion:
insert into mission_name(id_mission, name_mission, ability) 
values(\'1\', \'ACQUARIUS\', \'1\')

thanks!! :)

Re: [sqlite] Compression

[info]

Well, actually that's exactly what I need - compression of large fields, not 
the whole database.

  Dennis
// MCP, MCSD
// ASP Developer Member
// Software for animal shelters!
// www.smartpethealth.com
// www.amazingfiles.com
- Original Message - 
From: <[EMAIL PROTECTED]>
To: 
Sent: Sunday, January 02, 2005 12:42 PM
Subject: Re: [sqlite] Compression


Compression in the DB is interesting I think the commercial prod mentioned
just does a field compress and that is all. In general this only works on
larger blob like fiels as the overhead of the compressor is usually
somewhat high and lets not forget extra overhead of comp/decomp. The idea
I was playing with a while back (zlib) was a global db dictionary for
compression, but as memory got cheep and larger I dropped the project. The
simple token compression (like the old days of faircom's btree package,
sybase IQ, Monet, etc are much nicer). It would be a neat feature.
Sandy
My question is (and I've raised this topic back in September, but
didn't get back to it since), does anyone have a free/commercial
add-on for SQLite v3 to perform on-the-fly compression/decompression
of data, preferably on a field level (compress just one of the fields,
not the whole table)?
Related to this I would love to see reference counting of values.
For example if I add the string "foobar" in 27 different places,
it only gets stored once with a reference count of 27.
There are various places that have done compression:
  http://www.sqliteplus.com/
There is also mention of compression at
  http://www.hwaci.com/sw/sqlite/prosupport.html
If you are working on a commercial product and SQLite has made your
product better and/or improved your development process then it is
fair and worthwhile to pay for that.
Roger

Re: [sqlite] Compression

[info]

Thank you Roger,
I'm not against paying (that's why I said "commercial").
Have you (or anyone) used SQLite++? What are your thoughts on it?
Thank you,
  Dennis
// MCP, MCSD
// ASP Developer Member
// Software for animal shelters!
// www.smartpethealth.com
// www.amazingfiles.com
- Original Message - 
From: "Roger Binns" <[EMAIL PROTECTED]>
To: 
Sent: Sunday, January 02, 2005 11:18 AM
Subject: Re: [sqlite] Compression


My question is (and I've raised this topic back in September, but 
didn't get back to it since), does anyone have a free/commercial 
add-on for SQLite v3 to perform on-the-fly compression/decompression 
of data, preferably on a field level (compress just one of the fields, 
not the whole table)?
Related to this I would love to see reference counting of values.
For example if I add the string "foobar" in 27 different places,
it only gets stored once with a reference count of 27.
There are various places that have done compression:
 http://www.sqliteplus.com/
There is also mention of compression at
 http://www.hwaci.com/sw/sqlite/prosupport.html
If you are working on a commercial product and SQLite has made your
product better and/or improved your development process then it is
fair and worthwhile to pay for that. 

Roger

[sqlite] Compression

[info]

Hello all,

First of all, allow me to wish everyone a Happy New Year and I hope it'll be a 
good one for all.

My question is (and I've raised this topic back in September, but didn't get 
back to it since), does anyone have a free/commercial add-on for SQLite v3 to 
perform on-the-fly compression/decompression of data, preferably on a field 
level (compress just one of the fields, not the whole table)?

Thank you,

   Dennis

// MCP, MCSD
// ASP Developer Member
// Software for animal shelters!
// www.smartpethealth.com
// www.amazingfiles.com

Re: [sqlite] [ANN] SQLcrypt 1.0

[info]

Hi,
Thank you for your reply. Do you have a list of customers (at least a 
couple?) that use your encryption mechanism in a commercial software? Since 
it's quite new, I'd like to know about other users before I commit myself.

For any further discussion, I think it's best to go off this list, you can 
contact me at dennis (at) psunrise (dot) com

Regards,
  Dennis
// MCP, MCSD
// ASP Developer Member
// Software for animal shelters!
// www.smartpethealth.com
// www.amazingfiles.com
- Original Message - 
From: "Ng Pheng Siong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 26, 2004 4:43 PM
Subject: Re: [sqlite] [ANN] SQLcrypt 1.0


On Mon, Nov 22, 2004 at 09:24:36AM +1100, Dennis Volodomanov wrote:
Is anyone using the mentioned library? Is it stable and fast?
(First one didn't get thru. Trying again...)
Hi,
I suggest you download and test the trial version, which works just like
the retail version, apart from (a) being limited to a passphrase of 
exactly
8 bytes, and (b) have the passphrase stored in the clear in the first 8
bytes of the database file.

Check out this script that does timing tests for SQLcrypt, SQLite v3, 
MySQL
and PostgreSQL. The numbers posted on the SQLcrypt website are based on my
puny test machine. I'd be interested to see your numbers.

 http://www.sqlcrypt.com/speedtest-sqlcrypt.tcl
Just comment out the MySQL or PostgreSQL tests if you don't have them. 
Also
see this page for discussions about the timing tests and the use of 
crypto.

 http://www.sqlcrypt.com/versus.html
Are there any other similar products for SQLite v3?
drh has a source-code add-in. His uses RC4; SQLcrypt uses AES.  His is
available for both SQLite v2 and v3; SQLcrypt is SQLite v3 only.
HTH. Cheers.
--
Ng Pheng Siong <[EMAIL PROTECTED]>
http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog
http://www.sqlcrypt.com -+- Database Engine with Transparent AES 
Encryption

Re: [sqlite] (Fwd) Re: [sqlite] Testing the new SQLite mailing list

[info]

When I hit List-reply (L) in Mutt, it tells me No List Found

I don't know what you are doing, it is that sqlite really is a good product, but 
list-management is really stupid, it makes no sense at all, I cannot find an 
emailclient which handles this list smooth.

Must I reconfigure my Linuxbox and make all kind of configuration files, to use an 
exotic emailclient to handle this list?

Really, English is my second language, or maybe third, that is why I cannot discuss 
this well, and all th eothers (are there any) or did they all leave.

Maybe that is the purpose, now I understand, make it hard to read this list, and send 
answers, so that all people who do not wnat to make the effort leave, leaving only the 
very motivated people.

Good idea, I like it. Thank you for you enlighhted ideas.

OK, it is the list of DRH, the vote cannot change the list, but maybe, he wants to 
listen when a vast majority oif the people feel another way.

For my concern, this discussion is closed

Kind regards
Bert Verhees

On Mon, Oct 20, 2003 at 12:23:40PM -0400, Bernie Cosell wrote:
> On 20 Oct 2003 at 17:52, Bert Verhees wrote:
> 
> > Bernie Cosell wrote:
> > >As I said, it is a *LONGSTANDING* debate that has been discussed for 
> > >*YEARS* (decades!) off and on, here and there.  And as I said, the 
> > >general way it works out is that newcomers to the Internet usually like 
> > >"reply-to-list" while the folks with more experience generally prefer 
> > >"don't mess with the reply-to". ...
> > >
> > >Did you follow the URL in my post?
> > >
> > >  
> > >
> > No, I do not have time for reading all kinds of links.
> 
> At least we know some of the  reasons for your not "understanding" the 
> issues involved [as per your previous note].  A different view is that if 
> you don't have time to really consider the problem and learn something 
> about it, perhaps you shouldn't espouse such a strong opinion on it. It 
> isn't like a new issue and that you're nearly the very first person to 
> make the observation about 'reply-to'.
> 
> 
> > I am just trying to comfort people which are using very regular MUA's 
> > (emailclients), and which are interested in SQLite and maybe less in all 
> > kind of longstanding debates only interesting for grey haired oldies 
> > which call everybody who is using the Internet less then ten years a 
> > newcomer.
> 
> Better to 'comfort', I guess, than presume that over the thirty years 
> that folks have been doing email others have already pondered some of 
> these issues and that folk might actually try to learn from their 
> experience and advice.
> 
> sigh -- 
> 
> 
> > I thought, this mailing list was about SQLite and communicating about it.
> > This discussion about longlasting debates is really not very interesting 
> > to me, nor to most people, most people want to have easy acces to a 
> > mailinglist, 
> 
> Just so -- that's why some of us have just suggested that the list be set 
> up using the 'best practices' that have been honed over the [many] years 
> and be done with it.  I believe it was *YOU* who were banging this drum, 
> rather than just leaving the issue alone.
> 
> > OK, let's vote, there is no other way.
> 
> Not true: this isn't a democracy. This is Dr. Hipp's list and he can run 
> it as he pleases...
> 
>   /Bernie\
> 
> -- 
> Bernie Cosell Fantasy Farm Fibers
> mailto:[EMAIL PROTECTED] Pearisburg, VA
> -->  Too many people, too few sheep  <--   
> 
> 
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]