Re: [sqlite] PRAGMA journal_mode=WAL;

[Guy Terreault]

Hi, Simon.

I have been reading your back and forth answers like the next 4 responce.

And I am still waiting for the example that works in c code like the one 
that Bill McCormick that is wrong.


Why do you not include in your answer a working correction of the c code 
so that followers can

learn also and try it our selves.

Thanks Guy
On 12-01-31 09:34 AM, Simon Slavin wrote:

On 31 Jan 2012, at 2:32pm, Bill McCormick wrote:


Where exactly to I put the PRAGMA journal_mode=WAL; line?

You execute it as a SQL command, the same way you'd execute an INSERT command.

You only need to do it once for the database file.  The setting is stored with 
the database and next time SQLite opens the database file it will still be in 
WAL mode.

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




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

Re: [sqlite] SQLite on Visual Studio 2010

[Alok Singh]

Don't know which connection provider you are going to use, but ADO.net
guideline is here:

1. Download Sqlite for windows, install it.
2.  Download  ADO.NET 2.0 Provider for SQLite from here and install it :
http://sourceforge.net/projects/sqlite-dotnet2/
3.  Added a reference to the System.Data.SQLite dll in the project on
VS2010.

optional::  you can also use FireFox AddsON and search for Sqlite -> add it
--> use as viewer page to play with Sqlite db or you can use others.

thanks, Alok

On 1 February 2012 04:22, Agrawal, Manish  wrote:

> Hello
>
>I am a newbie to both Visual Studio and SQLite, but have a few
> years of Java/ Netbeans/ Glassfish/ MySQL experience.
>
>I am trying to get started with using SQLite on Visual Studio 2010
> (VS10) but am unable to get a SQLite Data Source type in my project. I
> created a WPF project in VS10 and as suggested in the SQLite FAQ:
>
> 1. Downloaded the pre-compiled binary from the SQLite website and unzipped
> it.
> 2. Created an Externals folder in the project
> 3. Copied the contents of the unzipped folder into Externals
> 4. Added a reference to the System.Data.SQLite dll in the project
>
>At this point I should get a SQLite DatSource type in VS10, but I
> do not. I was wondering if someone would know what I am missing.
>
> Windows 7/ x64/ Visual Studio 2010 Ultimate.
>
>For reference, the required information is at the screenshot below:
>
> http://www.ismlab.usf.edu/sqlite_vs10.jpg
>
> Thanks in anticipation
> --
> Manish Agrawal
> Assoc. Prof., College of Business, Univ. of South Florida
> CIS 1040, 4202 E. Fowler Ave., Tampa, Fl 33620 - 7800, U.S.A.
> (813)-974-6716 (W) 974-6749 (FAX) magra...@coba.usf.edu
> http://business.usf.edu/faculty/isds/agrawal/index.asp
> --
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



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

Re: [sqlite] SQLite on Visual Studio 2010

[Taleeb Anwar]

Hi Manish,

Try the following (it may work)

1. In Data Source Select ""
2. In Data Provider Select "..Provider for Ole Db"
3. Click Continue
4. In Ole Db Provider Select "SqlLite"

If this does not work (that is if there is no option for sqlLite in step 4)
then you will have to go for some third party tools...

Thanks & Regards
Taleeb bin Waquar

*Hum Mashriq Ke "Miskeenon" Ka Dil Maghrib men Ja Atka Hai!!*




On Wed, Feb 1, 2012 at 5:26 AM, Agrawal, Manish  wrote:

> Thanks very much. I tested the first application at the site and it worked!
>
> How can I get the designer support though? I added a reference to
> SQLite.Designer.dll but that was not enough. I am a relative newbie to
> database design and the designer would greatly improve productivity.
>
> Thanks
> Manish
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:
> sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin
> Sent: Tuesday, January 31, 2012 6:01 PM
> To: 'General Discussion of SQLite Database'
> Subject: Re: [sqlite] SQLite on Visual Studio 2010
>
>
> Agrawal, Manish wrote:
> >
> > At this point I should get a SQLite DatSource type in VS10, but I do not.
> > I was wondering if someone would know what I am missing.
> >
>
> It sounds like you want the Visual Studio Designer support; however, the
> steps you mention are for simply setting up System.Data.SQLite so that it
> can be referenced by (C# or VB) code in your project.
>
> Personally, I would recommend that you start out by learning the classes
> exposed by System.Data.SQLite (e.g. SQLiteConnection) and coding to them
> rather than using the designer.
>
> Here is a link to some tutorials to get you started:
>
> http://sqlite.phxsoftware.com/forums/p/76/266.aspx
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Delete data base.

[Taleeb Anwar]

No!

Try deleting the database file instead (right click - delete)

Thanks & Regards
Taleeb bin Waquar

*Hum Mashriq Ke "Miskeenon" Ka Dil Maghrib men Ja Atka Hai!!*




On Wed, Feb 1, 2012 at 11:41 AM, bhaskarReddy  wrote:

>
> Hi Friends,
>
> is it possible to delete a database with DROP command.
>
>   ex: DROP DATABASE dbName;
>
>
> Regards,
> Baskar Reddy.
> --
> View this message in context:
> http://old.nabble.com/Delete-data-base.-tp33241353p33241353.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Delete data base.

[bhaskarReddy]

Hi Friends,
 
 is it possible to delete a database with DROP command.

   ex: DROP DATABASE dbName;


Regards,
Baskar Reddy.
-- 
View this message in context: 
http://old.nabble.com/Delete-data-base.-tp33241353p33241353.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] SQLite on Visual Studio 2010

[Agrawal, Manish]

Thanks very much. I tested the first application at the site and it worked!

How can I get the designer support though? I added a reference to 
SQLite.Designer.dll but that was not enough. I am a relative newbie to database 
design and the designer would greatly improve productivity.

Thanks
Manish

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Joe Mistachkin
Sent: Tuesday, January 31, 2012 6:01 PM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] SQLite on Visual Studio 2010


Agrawal, Manish wrote:
>
> At this point I should get a SQLite DatSource type in VS10, but I do not.
> I was wondering if someone would know what I am missing.  
>

It sounds like you want the Visual Studio Designer support; however, the steps 
you mention are for simply setting up System.Data.SQLite so that it can be 
referenced by (C# or VB) code in your project.

Personally, I would recommend that you start out by learning the classes 
exposed by System.Data.SQLite (e.g. SQLiteConnection) and coding to them rather 
than using the designer.

Here is a link to some tutorials to get you started:

http://sqlite.phxsoftware.com/forums/p/76/266.aspx

--
Joe Mistachkin

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

[sqlite] SQLite not processing triggers on ALTER TABLE RENAME when table name case mismatches

[Peter Aronson]

This had me scratching my head for a while.  Normally, when you rename a table 
with triggers on it using ALTER TABLE old_name RENAME TO new_name, it will fix 
the table association in sqlite_master to indicate the relationship with the 
new 
table. However, it turns out, if the table name is specified with different 
case 
in the create table statement and the create trigger statement, the triggers 
are 
not actually fixed.

I ran the following script in SQLite 3.7.10 on Solaris 9 in the shell program, 
using a brand-new UTF-8 database:

.echo 1
.width 36
 
create table Old_table (c1 integer);
 
create trigger old_table_insert_trigger after insert on old_table for each row 
begin select 1; end;
 
select name,tbl_name from sqlite_master;
 
alter table old_table rename to new_table;
 
select name,tbl_name from sqlite_master;
 
And the second select showed old_table_insert_trigger as belonging to 
old_table.  Given there wasn't an old table at that point, this is a bit of a 
problem.  Also, once in this state, the .tables command fails.  Also, drop 
trigger doesn't work on a trigger in this state.  However, if you change the 
create trigger statement slightly to:
 
create trigger old_table_insert_trigger after insert on Old_table for each row 
begin select 1; end;
 
And then everything works fine.  Now, I can see what's going wrong in 
sqlite3AlterRenameTable -- the where clauses in the SQL used to detect triggers 
to fix are case sensitive.  But what strikes me as the most obvious fix -- 
using 
lower() or upper() to make the comparison case-insensitive -- might be 
problematic on non-ASCII table names if ICU isn't being used.  I'm not sure how 
much of an issue that is.
 
Best regards,
 
Peter
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite on Visual Studio 2010

[Joe Mistachkin]

Agrawal, Manish wrote:
>
> At this point I should get a SQLite DatSource type in VS10, but I do not.
> I was wondering if someone would know what I am missing.  
>

It sounds like you want the Visual Studio Designer support; however, the
steps
you mention are for simply setting up System.Data.SQLite so that it can be
referenced by (C# or VB) code in your project.

Personally, I would recommend that you start out by learning the classes
exposed
by System.Data.SQLite (e.g. SQLiteConnection) and coding to them rather than
using the designer.

Here is a link to some tutorials to get you started:

http://sqlite.phxsoftware.com/forums/p/76/266.aspx

--
Joe Mistachkin

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

[sqlite] SQLite on Visual Studio 2010

[Agrawal, Manish]

Hello

I am a newbie to both Visual Studio and SQLite, but have a few years of 
Java/ Netbeans/ Glassfish/ MySQL experience.

I am trying to get started with using SQLite on Visual Studio 2010 
(VS10) but am unable to get a SQLite Data Source type in my project. I created 
a WPF project in VS10 and as suggested in the SQLite FAQ:

1. Downloaded the pre-compiled binary from the SQLite website and unzipped it.
2. Created an Externals folder in the project
3. Copied the contents of the unzipped folder into Externals
4. Added a reference to the System.Data.SQLite dll in the project

At this point I should get a SQLite DatSource type in VS10, but I do 
not. I was wondering if someone would know what I am missing. 

Windows 7/ x64/ Visual Studio 2010 Ultimate.

For reference, the required information is at the screenshot below:

http://www.ismlab.usf.edu/sqlite_vs10.jpg

Thanks in anticipation
-- 
Manish Agrawal
Assoc. Prof., College of Business, Univ. of South Florida
CIS 1040, 4202 E. Fowler Ave., Tampa, Fl 33620 - 7800, U.S.A.
(813)-974-6716 (W) 974-6749 (FAX) magra...@coba.usf.edu
http://business.usf.edu/faculty/isds/agrawal/index.asp
--
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there any API for counting number of rows in a particular table.

[John Elrick]

On Tue, Jan 31, 2012 at 6:01 AM, Fabio Spadaro wrote:

> Hi
>
> 2012/1/30 Bart Smissaert 
>
> > How do you make it open database files that have an extension other than
> > .slt?
> >
> > RBS
>
>
> Tonight I will see to create a new version with bug fixes.
> Meanwhile you could give me some feedback such as opening a file with any
> extension by entering *.* in the filename of the FileDialog.
>

Common extensions I've seen used for SQLite:

.sqlite
.db
.db3


Cheers,


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

Re: [sqlite] PRAGMA journal_mode=WAL;

[Petite Abeille]

On Jan 31, 2012, at 6:45 PM, Bill McCormick wrote:

>  Funny how SQL works; it really can't figure out what you REALLY want to do 
> :) Maybe somebody who is really smart could figure out how to add a feature 
> to do this? :)

Try: pragma dwim = yes;

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

Re: [sqlite] PRAGMA journal_mode=WAL;

[Simon Slavin]

On 31 Jan 2012, at 5:16pm, Bill McCormick wrote:

> So when I run an update command (to update some arbitrary record) from the 
> sqlite3 command line, do I need to do something to do a checkpoint?

Iff you fail to open a transaction before you do a SQL command, SQLite will 
automatically wrap it in its own transaction, as follows:

BEGIN;

END;

This takes care of automatic checkpointing for you.  If you want to do 
checkpointing, rollback, or other such SQL commands yourself, go ahead and do 
them.  They'll work.

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

Re: [sqlite] PRAGMA journal_mode=WAL;

[Bill McCormick]

Larry Brasfield wrote, On 1/31/2012 11:36 AM:

Bill McCormick wrote:

> <  PRAGMA journal_mode=WAL;

 ...

So when I run an update command (to update some arbitrary record) from
the sqlite3 command line, do I need to do something to do a checkpoint?


By "checkpoint", I presume you mean some previous state of the 
database to which you can revert.  Since the database is a file, you 
can keep a copy of it, as another file.  Or you could put your update 
in a transaction.  However, for a single-record update, there is no 
point. SQLite is pretty robust once you've set journal_mode=WAL.


Best regards,
Sorry. I was running some UPDATE commands that were doing nothing 
because I'm stupid and don't pay attention to the field name I'm using 
in my WHERE clause. Funny how SQL works; it really can't figure out what 
you REALLY want to do :) Maybe somebody who is really smart could figure 
out how to add a feature to do this? :)

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

Re: [sqlite] A simple calculation, complex SQL Statement

[Black, Michael (IS)]

CREATE TABLE tblMainInventory(id,q);
INSERT INTO "tblMainInventory" VALUES(1,40);
INSERT INTO "tblMainInventory" VALUES(2,50);
CREATE TABLE tblSales(id,q);
INSERT INTO "tblSales" VALUES(1,30);
INSERT INTO "tblSales" VALUES(2,20);
CREATE TABLE tblReceives(id,q);
INSERT INTO "tblReceives" VALUES(1,20);
INSERT INTO "tblReceives" VALUES(2,20);

select *,t1.q-t2.q+t3.q from tblMainInventory as t1,tblSales as t2,tblReceives 
as t3 where t1.id=t2.id and t1.id=t3.id group by id;
id|q|id|q|id|q|t1.q-t2.q+t3.q
1|40|1|30|1|20|30
2|50|2|20|2|20|50



Michael D. Black

Senior Scientist

Advanced Analytics Directorate

Advanced GEOINT Solutions Operating Unit

Northrop Grumman Information Systems


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Fredrick Ughimi [fugh...@yahoo.com]
Sent: Tuesday, January 31, 2012 11:20 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] A simple calculation, complex SQL Statement

Hello,

I have this scenario. Its an inventory Software I am updating. Finding better 
ways to do things. I have a main table (tblMainInventory), Sales table 
(tblSales) and a Receives table (tblReceives).  The tblMainInventory is the 
base table while tblSales and tblReceives interacts with tblMainInventory to 
always arrive at the quantity in stock at any given time.

Lets say I have:

tblMainInventory  (ProductNo1) =  40
tblSales (ProductNo1) = 30
tblReceives (ProductNo1) = 20
Balance (ProductNo1) = 30

Now, I want to be able to use the SQL statement to do the above calculation for 
all the products available (Not just ProductNo1 alone) in one SQL Statement. Is 
it possible?

Best regards,




Fredrick Ughimi, President
Mega-Net Computers
(Software Development Company)
www.ughimisoft.com
supp...@ughimisoft.com
fugh...@yahoo.com
Phone Nos: 07035682478, 07055630187
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

[Larry Brasfield]

Bill McCormick wrote:

> <  PRAGMA journal_mode=WAL;

 ...

So when I run an update command (to update some arbitrary record) from
the sqlite3 command line, do I need to do something to do a checkpoint?


By "checkpoint", I presume you mean some previous state of the database 
to which you can revert.  Since the database is a file, you can keep a 
copy of it, as another file.  Or you could put your update in a 
transaction.  However, for a single-record update, there is no point. 
SQLite is pretty robust once you've set journal_mode=WAL.


Best regards,
--
Larry Brasfield
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A simple calculation, complex SQL Statement

[Petite Abeille]

On Jan 31, 2012, at 6:20 PM, Fredrick Ughimi wrote:

> Now, I want to be able to use the SQL statement to do the above calculation 
> for all the products available (Not just ProductNo1 alone) in one SQL 
> Statement. Is it possible?

Sure. Join your various tables and group the result set by product, counting 
the various measurement along the way.

E.g.

selectproduct.product_id,
  sum( inventory.??? ) as inventory,
  sum( sale.??? ) as sale,
  sum( receive.??? ) as receive,
  sum( balance.??? ) as balance
from  product

left join inventory
oninventory.product_id = product.product_id

left join sale
onsale.product_id = product.product_id

left join receive
onreceive.product_id = product.product_id

left join balance
onbalance.product_id = product.product_id

group by  product.product_id

order by  product.product_id


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

[sqlite] A simple calculation, complex SQL Statement

[Fredrick Ughimi]

Hello,

I have this scenario. Its an inventory Software I am updating. Finding better 
ways to do things. I have a main table (tblMainInventory), Sales table 
(tblSales) and a Receives table (tblReceives).  The tblMainInventory is the 
base table while tblSales and tblReceives interacts with tblMainInventory to 
always arrive at the quantity in stock at any given time.

Lets say I have:

tblMainInventory  (ProductNo1) =  40
tblSales (ProductNo1) = 30
tblReceives (ProductNo1) = 20
Balance (ProductNo1) = 30

Now, I want to be able to use the SQL statement to do the above calculation for 
all the products available (Not just ProductNo1 alone) in one SQL Statement. Is 
it possible?

Best regards, 


 

Fredrick Ughimi, President
Mega-Net Computers
(Software Development Company)
www.ughimisoft.com
supp...@ughimisoft.com
fugh...@yahoo.com
Phone Nos: 07035682478, 07055630187
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

[Bill McCormick]

Larry Brasfield wrote, On 1/31/2012 8:40 AM:
< Either I have some incorrect version or don't understand how to use 
this:

<
< #include 
<
< int main(int argc, char** argv)
< {
<  sqlite3 *db;
<
<  PRAGMA journal_mode=WAL;
<
<   ...
<
< gcc
[various errors]

The PRAGMA is something you pass to the statement preparation API as 
if it was SQL.

It is not C.

So when I run an update command (to update some arbitrary record) from 
the sqlite3 command line, do I need to do something to do a checkpoint?

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

Re: [sqlite] sqlite3 question

[Pete]

Thanks Larry.  I had always been under the impression that forward slashes
weren't acceptable in Windows path names so I'm glad to hear they are. The
project I'm working on has to run on Macs as well as Windows and the
forward slash is acceptable on both platforms.
Pete

On Tue, Jan 31, 2012 at 9:00 AM,  wrote:

> Message: 16
> Date: Mon, 30 Jan 2012 21:12:59 -0800
> From: Larry Brasfield 
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] sqlite3 question
> Message-ID: <4f27785b.7030...@iinet.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> If you look at shell.c in the code implementing
> sqlite3.exe, you will find a procedure named
> resolve_backslashes(char *z) which performs a
> substitution of '\'-escaped characters that is
> similar to the C/C++ interpretation of string
> literals.  That is what has sucked up those
> backslashes.
>
> Getting to what you should do: I advise using
> plain '/' as the path separator, unless you are
> fond of using '\\'. The OS is perfectly willing
> to accept '/'. (I curse IBM's insistence that
> the backwards convention started in CPM had to
> be prolonged into MS-DOS. There are fewer and
> fewer contexts where programs are silly enough
> to insist on seeing '\' rather than the '/' the
> rest of the world has settled upon.
>
> Cheers,
> --
> Larry Brasfield
>



-- 
Pete
Molly's Revenge 
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

[Larry Brasfield]

< Either I have some incorrect version or don't understand how to use this:
<
< #include 
<
< int main(int argc, char** argv)
< {
<  sqlite3 *db;
<
<  PRAGMA journal_mode=WAL;
<
<   ...
<
< gcc
[various errors]

The PRAGMA is something you pass to the statement preparation API as if 
it was SQL.

It is not C.

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

Re: [sqlite] PRAGMA journal_mode=WAL;

[Bill McCormick]

Simon Slavin wrote, On 1/31/2012 8:34 AM:

On 31 Jan 2012, at 2:32pm, Bill McCormick wrote:


Where exactly to I put the PRAGMA journal_mode=WAL; line?

You execute it as a SQL command, the same way you'd execute an INSERT command.

You only need to do it once for the database file.  The setting is stored with 
the database and next time SQLite opens the database file it will still be in 
WAL mode.


OK. That's neat!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA journal_mode=WAL;

[Igor Tandetnik]

Bill McCormick  wrote:
> Where exactly to I put the PRAGMA journal_mode=WAL; line?

It's a statement. You execute it, just like you would, say, INSERT or UPDATE.
-- 
Igor Tandetnik

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

Re: [sqlite] PRAGMA journal_mode=WAL;

[Simon Slavin]

On 31 Jan 2012, at 2:32pm, Bill McCormick wrote:

> Where exactly to I put the PRAGMA journal_mode=WAL; line?

You execute it as a SQL command, the same way you'd execute an INSERT command.

You only need to do it once for the database file.  The setting is stored with 
the database and next time SQLite opens the database file it will still be in 
WAL mode.

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

[sqlite] PRAGMA journal_mode=WAL;

[Bill McCormick]

Where exactly to I put the PRAGMA journal_mode=WAL; line?

Either I have some incorrect version or don't understand how to use this:

#include 

int main(int argc, char** argv)
{
sqlite3 *db;

PRAGMA journal_mode=WAL;

 ...

gcc -g -Wall -lrt -I.. -I../../include -I../ini-parse -o prodd prodd.c 
-lsqlite3 ../ini-parse/ini.o ../plccommd/ocxclient.o ../util/util.o

prodd.c: In function 'main':
prodd.c:200: error: 'PRAGMA' undeclared (first use in this function)
prodd.c:200: error: (Each undeclared identifier is reported only once
prodd.c:200: error: for each function it appears in.)
prodd.c:200: error: expected ';' before 'journal_mode'

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

Re: [sqlite] Delegates with linq

[Joe Mistachkin]

Truls Haaland wrote:
> 
> Does this have something with the first being C# 2 and the second C# 3?
> 

Without a more complete example, it's hard to say exactly.  However, I
suspect
it may have something to do with the type(s) of "Id" and "firstId".  Also,
since
the underlying storage is of the "Id" column is text, it could be related to
case
sensitivity.

Also, did you get the results you expect with a previous version of
System.Data.SQLite?

--
Joe Mistachkin

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

[sqlite] Delegates with linq

[Truls Haaland]

Given a table (SqLite) with an Id that is defined as a UNIQUEIDENTIFIER (stored 
as TEXT) I get the following results (firstId is a Guid matching the first 
entry):


This fails (returns zero rows):

  connection.SqLite.FirstOrDefault(s => s.Id == firstId )


This works (returns one row):

  connection.SqLite.FirstOrDefault(delegate(SqLite s) { return s.Id == firstId; 
});

There is one entry matching the Id in the table. I am using the latest version 
of system.data.sqlite (1.0.79.0), .NET 4, windows 7.

Does this have something with the first being C# 2 and the second C# 3?

Truls.

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

Re: [sqlite] How to find number of columns and types in a table.

[Igor Tandetnik]

bhaskarReddy  wrote:
>Is there any way to find the number of columns and column
> types in a table.

pragma table_info
-- 
Igor Tandetnik

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

Re: [sqlite] How to find number of columns and types in a table.

[Kees Nuyt]

On Tue, 31 Jan 2012 10:34:20 +, Bart Smissaert
 wrote:

>http://www.sqlite.org/faq.html#q7
>
>RBS

And this:

PRAGMA table_info(sometablename); -- returns metadata in a result set

A few coding samples:

http://icculus.org/~chunky/stuff/sqlite3_example/sqlite3_example_bind.c

http://www.sqlite.org/cvstrac/wiki?p=SimpleCode


>On 1/31/12, bhaskarReddy  wrote:
>>
>> Hi Friends,
>>
>> Is there any way to find the number of columns and column
>> types in a table.
>>
>>I tried with "select count(*) from tablename". But it is
>> showing number of records.
>>
>>  Regards,
>> Bhaskar.
>> --
>> View this message in context:
>> http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html
>> Sent from the SQLite mailing list archive at Nabble.com.
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>___
>sqlite-users mailing list
>sqlite-users@sqlite.org
>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
Regards,

Kees Nuyt

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

Re: [sqlite] SQLite port to Stellaris ARM processor

[Richard Hipp]

On Mon, Jan 30, 2012 at 9:20 AM, David Henry  wrote:

> This mail describes how I implemented SQLite3 on a resource limited
> processor. The attached zip file contains sources and the IAR project
> files.
>

Attachments are stripped from the mailing list.  Please send me the ZIP
file by private email and I'll make it available on the SQLite website.


>
> Any missing sources e.g. fatfs are part of the IAR IDE and are freely
> available.
>
>
>
> Enjoy.
>
>
>
> Development Environment
>
> ===
>
> 1) Stellaris LM3S9B96 ARM processor, 256KB ROM, 96KB RAM, Stellaris
> Peripheral Library in ROM
>
> 2) IAR IDE (you must use the licensed version because of code size. The
> free
> KickStart version is limited to 32 KB code)
>
> 3) SQlite3 Version 3.7.9 source
>
> 4) The file system is on a 4GB microSD controlled via the thirdparty/fatfs
> code supplied with the IAR IDE. This allows
>
> file sizes up to 4GB and 8.3 filenames.
>
>
>
> SQLite Compilation Options
>
> ==
>
> SQLITE_THREADSAFE 0  // single thread
>
> SQLITE_DISABLE_LFS  // no large file system
>
> SQLITE_OMIT_WAL
>
> SQLITE_OMIT_LOAD_EXTENSION
>
> SQLITE_DISABLE_DIRSYNC
>
> SQLITE_OMIT_VACUUM
>
> SQLITE_ENABLE_MEMSYS5
>
> SQLITE_ENABLE_8_3_NAMES 2 // only 8.3 names
>
>
>
> SQLITE_DEFAULT_CACHE_SIZE 10
>
> SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT 100
>
> SQLITE_DEFAULT_PAGE_SIZE 1024
>
> SQLITE_MAX_PAGE_COUNT 102400 // 1K  = max database size 100M
>
> SQLITE_MAX_SQL_LENGTH 1000// set by trial and error to avoid
> corruptSchema messages
>
> YYSTACKDEPTH 20
>
>
>
> Linker Options
>
> ==
>
> Reserve 83KB RAM for SQLite MALLOC as shown by this excerpt from the linker
> configuration file
>
>
>
> //
>
> // Define a region for the on-chip SRAM.
>
> // also reserve top 83K for sqlite malloc
>
> //
>
> // default is 96KB for application, this split gives 13K for app
>
> // and 83K for SQLite. Adjust as necessary
>
> //
>
> //define region SRAM =   mem:[from 0x2000 to 0x20017fff];
>
> define region SRAM = mem:[from 0x2000 to 0x200033ff];
>
> define region SQLITEMALLOC = mem:[from 0x20003400 to 0x20017fff];
>
>
>
> Stack size is set to 4K. Less than this caused processor FAULT interrupts.
>
>
>
> Implementation
>
> ==
>
> My main program simply opens up a UART which connect to Hyperterminal on a
> PC.
>
> An endless loop receives a line of SQL from hyperterminal and does an
> sqlite3_exec on it.
>
> An empty line signals no more SQL and the database is closed by
> sqlite3_close().
>
>
>
> Before calling sqlite3_open(), prepare malloc as follows
>
>
>
> #define END_RAM   0x20017fff  -- match these to SQLITEMALLOC above
>
> #define START_SQL 0x20003400
>
> sqlite3_config(SQLITE_CONFIG_HEAP,START_SQL,END_RAM-START_SQL+1,32);
>
> // Also do the following to avoid "Out Of Memory" errors.
>
> sqlite3_config(SQLITE_CONFIG_LOOKASIDE,0,0);
>
>
>
> Posix Interface
>
> ===
>
> A wrapper between Posix API e.g. open, close, fstat etc and the fatfs API
> was written.
>
> The version I have is a work in progress. See apimap.c in the zip file.
>
>
>
> MSD.c does the file system initialize/mount stuff for the microSD card.
>
> SQLite3 Source Changes
>
> ==
>
> function sqlite3PagerOpen() tries to create a journal file by appending
> "-journal" to the database name, in spite of the SQLITE_ENABLE_8_3_NAMES
> option. I changed it to append "_j" and make sure that my database names
> are
> 6 characters or less.
>
>
>
> Performance
>
> ===
>
> The compilation was optimized for balance between speed and size. Code and
> RO data occupies 248KB of ROM.
>
> Two tables were created, table A having a primary key and table B having a
> foreign key referencing the primary key in table A.
>
> An index was created for the foreign key in table B.
>
>
>
> 1000 rows were inserted into table A and 1 rows to table B.
>
>
>
> Typical time to insert a row to table B, 160 millisec.
>
> Typical time to select a row from table B, selected by its indexed column,
> 35msec.
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>


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

[sqlite] SQLite port to Stellaris ARM processor

[David Henry]

This mail describes how I implemented SQLite3 on a resource limited
processor. The attached zip file contains sources and the IAR project files.

Any missing sources e.g. fatfs are part of the IAR IDE and are freely
available.

 

Enjoy.

 

Development Environment

===

1) Stellaris LM3S9B96 ARM processor, 256KB ROM, 96KB RAM, Stellaris
Peripheral Library in ROM

2) IAR IDE (you must use the licensed version because of code size. The free
KickStart version is limited to 32 KB code)

3) SQlite3 Version 3.7.9 source

4) The file system is on a 4GB microSD controlled via the thirdparty/fatfs
code supplied with the IAR IDE. This allows

file sizes up to 4GB and 8.3 filenames.

 

SQLite Compilation Options

==

SQLITE_THREADSAFE 0  // single thread

SQLITE_DISABLE_LFS  // no large file system

SQLITE_OMIT_WAL

SQLITE_OMIT_LOAD_EXTENSION

SQLITE_DISABLE_DIRSYNC

SQLITE_OMIT_VACUUM

SQLITE_ENABLE_MEMSYS5

SQLITE_ENABLE_8_3_NAMES 2 // only 8.3 names

 

SQLITE_DEFAULT_CACHE_SIZE 10

SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT 100

SQLITE_DEFAULT_PAGE_SIZE 1024

SQLITE_MAX_PAGE_COUNT 102400 // 1K  = max database size 100M

SQLITE_MAX_SQL_LENGTH 1000// set by trial and error to avoid
corruptSchema messages

YYSTACKDEPTH 20

 

Linker Options

==

Reserve 83KB RAM for SQLite MALLOC as shown by this excerpt from the linker
configuration file

 

//

// Define a region for the on-chip SRAM.

// also reserve top 83K for sqlite malloc

//

// default is 96KB for application, this split gives 13K for app

// and 83K for SQLite. Adjust as necessary

//

//define region SRAM =   mem:[from 0x2000 to 0x20017fff];  

define region SRAM = mem:[from 0x2000 to 0x200033ff];

define region SQLITEMALLOC = mem:[from 0x20003400 to 0x20017fff];

 

Stack size is set to 4K. Less than this caused processor FAULT interrupts.

 

Implementation

==

My main program simply opens up a UART which connect to Hyperterminal on a
PC.

An endless loop receives a line of SQL from hyperterminal and does an
sqlite3_exec on it.

An empty line signals no more SQL and the database is closed by
sqlite3_close().

 

Before calling sqlite3_open(), prepare malloc as follows

 

#define END_RAM   0x20017fff  -- match these to SQLITEMALLOC above

#define START_SQL 0x20003400

sqlite3_config(SQLITE_CONFIG_HEAP,START_SQL,END_RAM-START_SQL+1,32);

// Also do the following to avoid "Out Of Memory" errors.

sqlite3_config(SQLITE_CONFIG_LOOKASIDE,0,0);

 

Posix Interface

===

A wrapper between Posix API e.g. open, close, fstat etc and the fatfs API
was written.

The version I have is a work in progress. See apimap.c in the zip file.

 

MSD.c does the file system initialize/mount stuff for the microSD card.

SQLite3 Source Changes

==

function sqlite3PagerOpen() tries to create a journal file by appending
"-journal" to the database name, in spite of the SQLITE_ENABLE_8_3_NAMES
option. I changed it to append "_j" and make sure that my database names are
6 characters or less.

 

Performance

===

The compilation was optimized for balance between speed and size. Code and
RO data occupies 248KB of ROM.

Two tables were created, table A having a primary key and table B having a
foreign key referencing the primary key in table A.

An index was created for the foreign key in table B.

 

1000 rows were inserted into table A and 1 rows to table B.

 

Typical time to insert a row to table B, 160 millisec.

Typical time to select a row from table B, selected by its indexed column,
35msec.

 

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

Re: [sqlite] How to access values of a columns with specific row id.

[David Bicking]

On 01/31/2012 04:05 AM, bhaskarReddy wrote:


Hi Friends,


Can any one tell me how to access values of a table column
with its particular row id.

  I tried with "select * from ontTable where rowid=2;"

  I am getting the output as 1|2|3|XYZ234|4|ABCD123|5.

 Here i want the values of column should store in separate
variables.


Can any one tell me how to access column by column.


Regards,
Bhaskar Reddy.


How are you calling sqlite?  What operating system are you using, what 
programming language?


I'm guessing you are getting that output from the command line program. 
While you can do useful things using cmd.exe on windows or bash on 
unix-like systems, it is difficult and not really recommended.


To really give you a meaningful answer, we really need to know what you 
are trying to accomplish and what limits you have in what you can do.


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

Re: [sqlite] sqlite mobile size capacity

[Simon Slavin]

On 31 Jan 2012, at 12:08pm, Live Happy wrote:

> yeh i did ask but get no answer so may u answer me now

Not getting an answer does not mean you should post the question again.  It 
means nobody knows, or nobody who knows can be bothered to answer your 
question.  Posting the same question a second time isn't going to help, it's 
just going to annoy us

Nevertheless, I posted an answer when you asked the first time as you can 
clearly see here:



and here



and in other archives of this list.  If you don't read a list, don't post to it.

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

Re: [sqlite] sqlite mobile size capacity

[Live Happy]

yeh i did ask but get no answer so may u answer me now

On Tue, Jan 31, 2012 at 1:58 PM, Petite Abeille wrote:

>
> On Jan 31, 2012, at 12:33 PM, Live Happy wrote:
>
> > thx for answer
>
> You asked the very same on January the 28th. Are you a bot?
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite mobile size capacity

[Petite Abeille]

On Jan 31, 2012, at 12:33 PM, Live Happy wrote:

> thx for answer

You asked the very same on January the 28th. Are you a bot?

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

[sqlite] sqlite mobile size capacity

[Live Happy]

what is the maximum size of sqlite on the mobiles phone (android, iPhone,
blackberry, windows mobile)
 its the same on all of them ?
and in wish of them sqlite more compatibility and the performance of it is
high
thx for answer
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there any API for counting number of rows in a particular table.

[Fabio Spadaro]

Hi

2012/1/30 Bart Smissaert 

> How do you make it open database files that have an extension other than
> .slt?
>
> RBS


Tonight I will see to create a new version with bug fixes.
Meanwhile you could give me some feedback such as opening a file with any
extension by entering *.* in the filename of the FileDialog.
Thanks.

-- 
Fabio Spadaro

Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
www.sqliteroot.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to find number of columns and types in a table.

[Bart Smissaert]

http://www.sqlite.org/faq.html#q7

RBS


On 1/31/12, bhaskarReddy  wrote:
>
> Hi Friends,
>
> Is there any way to find the number of columns and column
> types in a table.
>
>I tried with "select count(*) from tablename". But it is
> showing number of records.
>
>  Regards,
> Bhaskar.
> --
> View this message in context:
> http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to find number of columns and types in a table.

[bhaskarReddy]

Hi Friends, 

Is there any way to find the number of columns and column
types in a table.   

   I tried with "select count(*) from tablename". But it is
showing number of records.

 Regards, 
Bhaskar.
-- 
View this message in context: 
http://old.nabble.com/How-to-find-number-of-columns-and-types-in-a-table.-tp33235184p33235184.html
Sent from the SQLite mailing list archive at Nabble.com.

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

Re: [sqlite] Is there any API for counting number of rows in a particular table.

[Bart Smissaert]

SQLiteRoot is a free SQLite manager managed in this thread.
I downloaded and tried it, but couldn't figure out how to open databases
with an extension other than the default for that app, which I think was .slt
Nil to do with SQLite really.

RBS

On 1/31/12, Tim Streater  wrote:
> On 30 Jan 2012 at 21:58, Bart Smissaert  wrote:
>
>> OK, so how you open those then with SQLiteRoot?
>
> I use PHP, thus:
>
>  $dbh = new PDO ("sqlite:" . $db);
>
> where $db is a string like "/path/to/database".
>
> I don't know what SQLiteRoot is although possibly I should do.
>
> --
> Cheers  --  Tim
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there any API for counting number of rows in a particular table.

[Tim Streater]

On 30 Jan 2012 at 21:58, Bart Smissaert  wrote: 

> OK, so how you open those then with SQLiteRoot?

I use PHP, thus:

 $dbh = new PDO ("sqlite:" . $db);

where $db is a string like "/path/to/database".

I don't know what SQLiteRoot is although possibly I should do.

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

Re: [sqlite] How to access values of a columns with specific row id.

[Petite Abeille]

On Jan 31, 2012, at 10:05 AM, bhaskarReddy wrote:

> Can any one tell me how to access values of a table column with its 
> particular row id.

In general, I would suggest that you get the basics straight:

http://www.sqlite.org/books.html

> I tried with "select * from ontTable where rowid=2;"

http://www.sqlite.org/lang_select.html

> Can any one tell me how to access column by column.

http://www.sqlite.org/c3ref/column_name.html


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

Re: [sqlite] How to access values of a columns with specific row id.

[Larry Knibb]

select columnName from ontTable where rowid = 2;

select * gets you all of the columns for the row. select columnName
will just get one column.

Cheers,
Larry

On 31 January 2012 17:05, bhaskarReddy  wrote:
>
> Hi Friends,
>
>
>               Can any one tell me how to access values of a table column
> with its particular row id.
>
>             I tried with "select * from ontTable where rowid=2;"
>
>             I am getting the output as 1|2|3|XYZ234|4|ABCD123|5.
>
>            Here i want the values of column should store in separate
> variables.
>
>
>           Can any one tell me how to access column by column.
>
>
> Regards,
> Bhaskar Reddy.
>
>
>
>
> --
> View this message in context: 
> http://old.nabble.com/How-to-access-values-of-a-columns-with-specific-row-id.-tp33234692p33234692.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to access values of a columns with specific row id.

[bhaskarReddy]

Hi Friends,


   Can any one tell me how to access values of a table column
with its particular row id.

 I tried with "select * from ontTable where rowid=2;"
  
 I am getting the output as 1|2|3|XYZ234|4|ABCD123|5.

Here i want the values of column should store in separate
variables.


   Can any one tell me how to access column by column.


Regards,
Bhaskar Reddy.




-- 
View this message in context: 
http://old.nabble.com/How-to-access-values-of-a-columns-with-specific-row-id.-tp33234692p33234692.html
Sent from the SQLite mailing list archive at Nabble.com.

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