subject:"SQLite"

On Thu, Nov 16, 2017 at 9:39 AM, Paul H. Tarver <p...@tpcqpc.com> wrote:
> Ok, I formally nominate Ted Roche to be VFP King and SQLite Guru! All those
> in favor? :)

Aw, shucks.

"If nominated, I shall not run. If elected, I shall not serve." -- LBJ

"It's good to be king." -- Mel Brooks, The 2000 Year Old Man.

I'm just the editor of the SQLite book doing a little CYA to make sure
I hadn't lead anyone astray.

> Around
> here they say, "If it had been a snake, it would have bit me."

It's been my experience fixing my own and other's stuff that we're
really good at getting the complicated stuff right, and really bad at
finding the misplaced semi-colon or mistyped command.

> One weird thing remains:

"Have you tried turning it off and back on again" -- The IT Group

It's almost impossible to guess. Perhaps you had an ON ERROR * in code
you ran two days ago.  It's always helpful to turn the machine off and
on, and to try to reproduce with as few lines of code as possible, and
on a different machine if possible.

> Thank you Ed for providing the ProFox list. Without this place I don't know
> how long it would have taken me to figure this issue out if ever.

Hear, hear!

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4tft2e=+1pouynfp8dyj2uwtfju3ncrbm4lyg7oxvs...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-16 Thread Richard Kaye

Ted is, and always has been, a King amongst VFP men and women. 

In the wondrous world of computer programming, not only do words have meaning 
but so do individual letters. And let's not get started on case sensitivity... 
I've been bitten by something like this before as I'm sure most of us have. The 
efficient brain takes shortcuts whenever possible so if you expected to see a 
particular thing in a particular context, it shows that to you.

--

rk

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H. 
Tarver
Sent: Thursday, November 16, 2017 9:40 AM
To: profoxt...@leafe.com
Subject: RE: SQLite Problem - DSN-less Connection Doesn't Create A File

Ok, I formally nominate Ted Roche to be VFP King and SQLite Guru! All those
in favor? :)

I changed "DBNAME" in the connection string to "Database" and it worked
perfectly the first time. 

I knew it was going to be something stupid, but I didn't realize it was THAT
stupid. I can only claim programming blindness. I looked at the string in
Whil's book a thousand times and compared it to my code and never saw it.
I've been doing a lot of work lately connecting Foxpro to MySQL for another
project and DBNAME came over from that connection string. Of all the changes
I made to the connection string, I never changed, deleted or replaced the
Driver & DBAME key words. I changed everything else from the other key pairs
to the location and name of the database, but I am embarrassed to say I
never looked to the left of the equal sign to see the bad key word. Around
here they say, "If it had been a snake, it would have bit me."

One weird thing remains: As I mentioned in the original post, prior to
rebooting my computer, I NEVER got an error message and I always got a valid
handle back when I tried to make a connection and I was able to create
tables, insert data and select results. I can only assume it was because
SQLite allows you to create an in-memory database with a blank name, maybe
that was how I got a valid handle, but why did it fail to repeat that
behavior after the reboot? Was it because I established a valid DSN earlier
in testing and somehow it was piggy-backing on that connection? As I say,
weird. 

Thank you Ed for providing the ProFox list. Without this place I don't know
how long it would have taken me to figure this issue out if ever.

Paul H. Tarver
Tarver Program Consultants, Inc.
Tel: 601-483-4404
Email: p...@tpcqpc.com 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Thursday, November 16, 2017 7:58 AM
To: profoxt...@leafe.com
Subject: Re: SQLite Problem - DSN-less Connection Doesn't Create A File

On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche <tedro...@gmail.com> wrote:
> On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:
>> Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to 
>> Bypass The 2GB .DBF Filesize Limit" for a project I'm trying to 
>> develop and I have some weird behavior going on.
>

Having worked with Whil on a half-dozen books now, I have to say, weird
behavior is par for the course. ;)

Here's what I did. I called up a DSN I had previously created and like you,
copied the ConnectString when it opened. The only big difference I notice is
that my string is using "Database" rather than DBNAME.

? SQLStringConnect("Driver={SQLite3 ODBC
Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPr
agma=;NoTXN=0;Timeout=;ShortNames=0;")
? SQLExec(4, "Create table Example2 (key int, description text)") ?
SQLExec(4, "insert into Example2 (key, description) values (1,'The first')")
? SQLExec(4, "insert into Example2 (key, description) values (2,'The
second')")

the "newexample.sqlite" database did not exist before I started. It's on
disk now, at 8 kb.

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/mwhpr10mb17747b5f3c97ab8dfd131343d2...@mwhpr10mb1774.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-16 Thread Paul H. Tarver

Ok, I formally nominate Ted Roche to be VFP King and SQLite Guru! All those
in favor? :)

I changed "DBNAME" in the connection string to "Database" and it worked
perfectly the first time. 

I knew it was going to be something stupid, but I didn't realize it was THAT
stupid. I can only claim programming blindness. I looked at the string in
Whil's book a thousand times and compared it to my code and never saw it.
I've been doing a lot of work lately connecting Foxpro to MySQL for another
project and DBNAME came over from that connection string. Of all the changes
I made to the connection string, I never changed, deleted or replaced the
Driver & DBAME key words. I changed everything else from the other key pairs
to the location and name of the database, but I am embarrassed to say I
never looked to the left of the equal sign to see the bad key word. Around
here they say, "If it had been a snake, it would have bit me."

One weird thing remains: As I mentioned in the original post, prior to
rebooting my computer, I NEVER got an error message and I always got a valid
handle back when I tried to make a connection and I was able to create
tables, insert data and select results. I can only assume it was because
SQLite allows you to create an in-memory database with a blank name, maybe
that was how I got a valid handle, but why did it fail to repeat that
behavior after the reboot? Was it because I established a valid DSN earlier
in testing and somehow it was piggy-backing on that connection? As I say,
weird. 

Thank you Ed for providing the ProFox list. Without this place I don't know
how long it would have taken me to figure this issue out if ever.

Paul H. Tarver
Tarver Program Consultants, Inc.
Tel: 601-483-4404
Email: p...@tpcqpc.com 

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted
Roche
Sent: Thursday, November 16, 2017 7:58 AM
To: profoxt...@leafe.com
Subject: Re: SQLite Problem - DSN-less Connection Doesn't Create A File

On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche <tedro...@gmail.com> wrote:
> On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:
>> Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to 
>> Bypass The 2GB .DBF Filesize Limit" for a project I'm trying to 
>> develop and I have some weird behavior going on.
>

Having worked with Whil on a half-dozen books now, I have to say, weird
behavior is par for the course. ;)

Here's what I did. I called up a DSN I had previously created and like you,
copied the ConnectString when it opened. The only big difference I notice is
that my string is using "Database" rather than DBNAME.

? SQLStringConnect("Driver={SQLite3 ODBC
Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPr
agma=;NoTXN=0;Timeout=;ShortNames=0;")
? SQLExec(4, "Create table Example2 (key int, description text)") ?
SQLExec(4, "insert into Example2 (key, description) values (1,'The first')")
? SQLExec(4, "insert into Example2 (key, description) values (2,'The
second')")

the "newexample.sqlite" database did not exist before I started. It's on
disk now, at 8 kb.

--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/002f01d35ee8$b9366610$2ba33230$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite Problem - DSN-less Connection Doesn't Create A File

>From https://sqlite.org/cli.html :

"If no database file is specified on the command-line, a temporary
database is created, then deleted when the "sqlite3" program exits."

I'll bet that's what you are seeing, only using the ODBC driver rather
than the command line: a temporary database created and deleted, like
a cursor.

On Thu, Nov 16, 2017 at 9:21 AM, Ted Roche <tedro...@gmail.com> wrote:
> And:
>
> ? SQLDisconnect(0)
> ? SQLStringConnect("Driver={SQLite3 ODBC
> Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;")
> ? SQLExec(1,"Select * from Example2")
> brow norm
>
> disconnects all ODBC connections, reconnects, and shows the two
> records in the table, so that's working.
>
>
>
> On Thu, Nov 16, 2017 at 8:57 AM, Ted Roche <tedro...@gmail.com> wrote:
>> On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche <tedro...@gmail.com> wrote:
>>> On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:
>>>> Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
>>>> The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
>>>> some weird behavior going on.
>>>
>>
>> Having worked with Whil on a half-dozen books now, I have to say,
>> weird behavior is par for the course. ;)
>>
>> Here's what I did. I called up a DSN I had previously created and like
>> you, copied the ConnectString when it opened. The only big difference
>> I notice is that my string is using "Database" rather than DBNAME.
>>
>> ? SQLStringConnect("Driver={SQLite3 ODBC
>> Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;")
>> ? SQLExec(4, "Create table Example2 (key int, description text)")
>> ? SQLExec(4, "insert into Example2 (key, description) values (1,'The 
>> first')")
>> ? SQLExec(4, "insert into Example2 (key, description) values (2,'The 
>> second')")
>>
>>
>> the "newexample.sqlite" database did not exist before I started. It's
>> on disk now, at 8 kb.
>>
>> --
>> Ted Roche
>> Ted Roche & Associates, LLC
>> http://www.tedroche.com
>
>
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com



-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4tx1+yn7iv32ayhun08c5mhkmgh3+fusj-kdvnlrju...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite Problem - DSN-less Connection Doesn't Create A File

And:

? SQLDisconnect(0)
? SQLStringConnect("Driver={SQLite3 ODBC
Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;")
? SQLExec(1,"Select * from Example2")
brow norm

disconnects all ODBC connections, reconnects, and shows the two
records in the table, so that's working.

On Thu, Nov 16, 2017 at 8:57 AM, Ted Roche <tedro...@gmail.com> wrote:
> On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche <tedro...@gmail.com> wrote:
>> On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:
>>> Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
>>> The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
>>> some weird behavior going on.
>>
>
> Having worked with Whil on a half-dozen books now, I have to say,
> weird behavior is par for the course. ;)
>
> Here's what I did. I called up a DSN I had previously created and like
> you, copied the ConnectString when it opened. The only big difference
> I notice is that my string is using "Database" rather than DBNAME.
>
> ? SQLStringConnect("Driver={SQLite3 ODBC
> Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;")
> ? SQLExec(4, "Create table Example2 (key int, description text)")
> ? SQLExec(4, "insert into Example2 (key, description) values (1,'The first')")
> ? SQLExec(4, "insert into Example2 (key, description) values (2,'The 
> second')")
>
>
> the "newexample.sqlite" database did not exist before I started. It's
> on disk now, at 8 kb.
>
> --
> Ted Roche
> Ted Roche & Associates, LLC
> http://www.tedroche.com

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4smOyLqNoqhkrbFr=rmfuk7gooao87fv2rmcnuxnnk...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite Problem - DSN-less Connection Doesn't Create A File

On Thu, Nov 16, 2017 at 6:25 AM, Ted Roche <tedro...@gmail.com> wrote:
> On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:
>> Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
>> The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
>> some weird behavior going on.
>

Having worked with Whil on a half-dozen books now, I have to say,
weird behavior is par for the course. ;)

Here's what I did. I called up a DSN I had previously created and like
you, copied the ConnectString when it opened. The only big difference
I notice is that my string is using "Database" rather than DBNAME.

? SQLStringConnect("Driver={SQLite3 ODBC
Driver};Database=C:\Users\tedro\Documents\newexample.sqlite;StepAPI=0;SyncPragma=;NoTXN=0;Timeout=;ShortNames=0;")
? SQLExec(4, "Create table Example2 (key int, description text)")
? SQLExec(4, "insert into Example2 (key, description) values (1,'The first')")
? SQLExec(4, "insert into Example2 (key, description) values (2,'The second')")

the "newexample.sqlite" database did not exist before I started. It's
on disk now, at 8 kb.

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4vCogaC5bt69+H3zG=h1afohbxtvbxaydjk76rbz1j...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-16 Thread AndyHC


+1
On 16-Nov-2017 4:56 PM, Dave Crozier wrote:

Paul,
Have you tried forcing a Commit on the SQLite data. That may help

Dave



---




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/52e2eca5-c282-e40e-82cf-ed7541e74...@hawthorncottage.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-16 Thread Dave Crozier

Paul,
Have you tried forcing a Commit on the SQLite data. That may help

Dave



---
This communication and the information it contains is intended for the person 
or organisation to whom it is addressed. Its contents are confidential and may 
be protected in law. If you have received this e-mail in error you must not 
copy, distribute or take any action in reliance on it. Unauthorised use, 
copying or disclosure of any of it may be unlawful. If you have received this 
message in error, please notify us immediately by telephone or email.

Flexipol Packaging Ltd. has taken every reasonable precaution to minimise the 
risk of virus transmission through email and therefore any files sent via 
e-mail will have been checked for known viruses. However, you are advised to 
run your own virus check before opening any
attachments received as Flexipol Packaging Ltd will not in any event accept any 
liability whatsoever once an e-mail and/or any attachment is received.

It is the responsibility of the recipient to ensure that they have adequate 
virus protection.

Flexipol Packaging Ltd.
Unit 14 Bentwood Road
Carrs
Industrial Estate
Haslingden
Rossendale
Lancashire
BB4 5HH

Tel:01706-222792
Fax: 01706-224683
www.Flexipol.co.uk
---

Terms & Conditions:

Notwithstanding delivery and the passing of risk in the goods, the property in 
the goods shall not pass to the buyer until the seller
Flexipol Packaging Ltd. ("The Company") has received in cash or cleared funds 
payment in full of the price of the goods and all other goods agreed to be sold 
by the seller to the buyer for which payment is then due. Until such time as 
the property in the goods passes to the buyer, the buyer shall hold the goods 
as the seller's fiduciary agent and bailee and keep the goods separate from 
those of the buyer and third parties and properly stored protected and insured 
and identified as the seller's property but shall be entitled to resell or use 
the goods in the ordinary course of its business. Until such time as the 
property in the goods passes to the buyer the seller shall be entitled at any 
time

-Original Message-
From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul H. Tarver
Sent: 16 November 2017 04:58
To: profox@leafe.com
Subject: RE: SQLite Problem - DSN-less Connection Doesn't Create A File

New details.

I rebooted my computer and tried to use SQLSTRINGCONNECT again and this time, a 
window opened which is the same window you would see if you try to create a 
DSN. So I have no idea why I got a valid handle no matter what I tried earlier 
because after the reboot, nothing I try will give me anything other than the 
SQLite3 ODBC Driver Connect window.

I simplified the connection string command to this:

liH = SQLSTRINGCONNECT("DRIVER={SQLite3 ODBC
Driver};DBNAME=T:\f1;SyncPragma=NORMAL;Timeout=10;")

Executing this line immediately opens the SQLite3 ODBC Driver Connect window. 
The Data Source Name is blank and the Database Name is blank. The timeout and 
the Synch Mode fields are populated with 10 and NORMAL but I have no idea 
if those are defaults or coming from the connection string.

If it helps, I'm using the 32-bit ODBC driver on a 64-bit Windows 7 development 
box.

PS: T:\ is a valid volume and I have also tried c:\temp\f1.

Paul H. Tarver
Email: p...@tpcqpc.com


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Wednesday, November 15, 2017 6:14 PM
To: profoxt...@leafe.com
Subject: SQLite Problem - DSN-less Connection Doesn't Create A File

Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass The 
2GB .DBF Filesize Limit" for a project I'm trying to develop and I have some 
weird behavior going on.



I'm trying to use SQLite3 to deal with an import file that will have 350+ 
columns. I've been using the the examples and doing everything via the 
SQLite3.exe command prompt works as documented. I've also worked out a SQL 
script using SQLite Expert to drop a table if it exists, create an empty table 
and the corresponding indexes. Up to this point everything worked as expected.



However, now I'm trying to migrate this code into VFP9 using SQL Pass-Through, 
but here's what I'm running into:



If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'), the 
connection is made and if the database file "trnslate.db" doesn't already exist 
it is created in the folder I designated in the Database Name field of the DSN.



However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the 
connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I get 
a handle, but it is to a "trnslate.db" database that doesn't contain the table 
I previously created and if the "trnslate.db"

Re: SQLite Problem - DSN-less Connection Doesn't Create A File

On Wed, Nov 15, 2017 at 7:14 PM, Paul H. Tarver <p...@tpcqpc.com> wrote:
> Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
> The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
> some weird behavior going on.

I read that book, too! 

> If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'),
> the connection is made and if the database file "trnslate.db" doesn't
> already exist it is created in the folder I designated in the Database Name
> field of the DSN.

That's good.

> However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the
> connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I
> get a handle, but it is to a "trnslate.db" database that doesn't contain the
> table I previously created and if the "trnslate.db" table doesn't already
> exist in the designated folder, it is NOT created on the hard drive.
> However, it apparently IS created in memory. I can create a table and issue
> a select command and get back the results I expect, but a database file is
> NEVER physically created on the hard drive which I need to do for my
> purposes.

 /*snip*/

> HELP!

I'm away from Windows machines right now. Let me check into this later
in the day.

-- 
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4u_hhaezzslhdj3icvek3ii5lxh+olkvoe3xkw8asq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-16 Thread AndyHC



Have you checked:
https://www.connectionstrings.com/sqlite/
https://www.connectionstrings.com/sqlite3-odbc-driver/

On 16-Nov-2017 5:44 AM, Paul H. Tarver wrote:

Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
some weird behavior going on.

  


I'm trying to use SQLite3 to deal with an import file that will have 350+
columns. I've been using the the examples and doing everything via the
SQLite3.exe command prompt works as documented. I've also worked out a SQL
script using SQLite Expert to drop a table if it exists, create an empty
table and the corresponding indexes. Up to this point everything worked as
expected.

  


However, now I'm trying to migrate this code into VFP9 using SQL
Pass-Through, but here's what I'm running into:

  


If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'),
the connection is made and if the database file "trnslate.db" doesn't
already exist it is created in the folder I designated in the Database Name
field of the DSN.

  


However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the
connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I
get a handle, but it is to a "trnslate.db" database that doesn't contain the
table I previously created and if the "trnslate.db" table doesn't already
exist in the designated folder, it is NOT created on the hard drive.
However, it apparently IS created in memory. I can create a table and issue
a select command and get back the results I expect, but a database file is
NEVER physically created on the hard drive which I need to do for my
purposes.

  


Here is some sample code to see if you can tell me where I'm going wrong:

  


liH = SQLSTRINGCONNECT("DRIVER=SQLite3 ODBC Driver;" + ;

 "DBNAME=T:\trnslate.db;" + ;

 "PWD=;" + ;

 "StepAPI=0;" + ;

 "SyncPragma=;" + ;

 "NoTXN=0;" + ;

 "Timeout=;" + ;

 "ShortNames=0;" + ;

 "LongNames=0;" + ;

 "NoCreat=0;" + ;

 "NoWCHAR=0;" + ;

 "FKSupport=0;" + ;

 "JournalMode=;" + ;

 "OEMCP=0;" + ;

 "BigInt=0;" + ;

 "JDConv=0;" + ;

 "TraceFile=;")

  


SQLExec(m.liH, "create table EmplImport (id int primary key, dummy
varchar(50));")

SQLExec(m.liH, "insert into EmplImport (id, dummy) values (1,'testing');")

SQLExec(m.liH, "select * from EmplImport;",'dbtest')

  


SQLDISCONNECT(liH)

  


I've tried this process about hundred differ ways with different
combinations of paired keys in the connection string without success. I've
used a DSN-less connection program that I wrote which works perfectly with
SQL, MySQL and others and though I never fail to get a handle; the database
file never physically exists in any path on the hard drive. Complete
searches of my hard drive for the database name yield no results

  


The code above gives me a value for m.liH which is greater than zero, I
never get errors thrown, I always get a valid handle, the table can be
created, the data inserted and I get a cursor back from the select named
'dbtest' with the exact data inserted on the previous line.

  


I've been on this for about six hours and I'm no closer to making this work
as a DSN-less project even though Whil seemed to imply in the book that this
was his preferred method of doing things.

  


HELP!

  


Paul H. Tarver
Email:  <mailto:p...@tpcqpc.com> p...@tpcqpc.com

  

  




--- StripMime Report -- processed MIME parts ---
multipart/alternative
   text/plain (text body -- kept)
   text/html
---


[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/b1dbf046-cf35-f3bc-809b-e28150882...@hawthorncottage.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-15 Thread Paul H. Tarver

New details.

I rebooted my computer and tried to use SQLSTRINGCONNECT again and this
time, a window opened which is the same window you would see if you try to
create a DSN. So I have no idea why I got a valid handle no matter what I
tried earlier because after the reboot, nothing I try will give me anything
other than the SQLite3 ODBC Driver Connect window. 

I simplified the connection string command to this:

liH = SQLSTRINGCONNECT("DRIVER={SQLite3 ODBC
Driver};DBNAME=T:\f1;SyncPragma=NORMAL;Timeout=10;")

Executing this line immediately opens the SQLite3 ODBC Driver Connect
window. The Data Source Name is blank and the Database Name is blank. The
timeout and the Synch Mode fields are populated with 10 and NORMAL but I
have no idea if those are defaults or coming from the connection string.  

If it helps, I'm using the 32-bit ODBC driver on a 64-bit Windows 7
development box.  

PS: T:\ is a valid volume and I have also tried c:\temp\f1.

Paul H. Tarver
Email: p...@tpcqpc.com 


-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul H.
Tarver
Sent: Wednesday, November 15, 2017 6:14 PM
To: profoxt...@leafe.com
Subject: SQLite Problem - DSN-less Connection Doesn't Create A File

Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
some weird behavior going on. 

 

I'm trying to use SQLite3 to deal with an import file that will have 350+
columns. I've been using the the examples and doing everything via the
SQLite3.exe command prompt works as documented. I've also worked out a SQL
script using SQLite Expert to drop a table if it exists, create an empty
table and the corresponding indexes. Up to this point everything worked as
expected. 

 

However, now I'm trying to migrate this code into VFP9 using SQL
Pass-Through, but here's what I'm running into:

 

If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'),
the connection is made and if the database file "trnslate.db" doesn't
already exist it is created in the folder I designated in the Database Name
field of the DSN. 

 

However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the
connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I
get a handle, but it is to a "trnslate.db" database that doesn't contain the
table I previously created and if the "trnslate.db" table doesn't already
exist in the designated folder, it is NOT created on the hard drive.
However, it apparently IS created in memory. I can create a table and issue
a select command and get back the results I expect, but a database file is
NEVER physically created on the hard drive which I need to do for my
purposes. 

 

Here is some sample code to see if you can tell me where I'm going wrong:

 

liH = SQLSTRINGCONNECT("DRIVER=SQLite3 ODBC Driver;" + ;

"DBNAME=T:\trnslate.db;" + ;

"PWD=;" + ;

"StepAPI=0;" + ;

"SyncPragma=;" + ;

"NoTXN=0;" + ;

"Timeout=;" + ;

"ShortNames=0;" + ;

"LongNames=0;" + ;

"NoCreat=0;" + ;

"NoWCHAR=0;" + ;

"FKSupport=0;" + ;

"JournalMode=;" + ;

"OEMCP=0;" + ;

"BigInt=0;" + ;

"JDConv=0;" + ;

"TraceFile=;")

 

SQLExec(m.liH, "create table EmplImport (id int primary key, dummy
varchar(50));")

SQLExec(m.liH, "insert into EmplImport (id, dummy) values (1,'testing');")

SQLExec(m.liH, "select * from EmplImport;",'dbtest')

 

SQLDISCONNECT(liH)

 

I've tried this process about hundred differ ways with different
combinations of paired keys in the connection string without success. I've
used a DSN-less connection program that I wrote which works perfectly with
SQL, MySQL and others and though I never fail to get a handle; the database
file never physically exists in any path on the hard drive. Complete
searches of my hard drive for the database name yield no results

 

The code above gives me a value for m.liH which is greater than ze

SQLite Problem - DSN-less Connection Doesn't Create A File

2017-11-15 Thread Paul H. Tarver

Ok, I give up. I've been using Whil Hentzen's book "Using SQLite to Bypass
The 2GB .DBF Filesize Limit" for a project I'm trying to develop and I have
some weird behavior going on. 

 

I'm trying to use SQLite3 to deal with an import file that will have 350+
columns. I've been using the the examples and doing everything via the
SQLite3.exe command prompt works as documented. I've also worked out a SQL
script using SQLite Expert to drop a table if it exists, create an empty
table and the corresponding indexes. Up to this point everything worked as
expected. 

 

However, now I'm trying to migrate this code into VFP9 using SQL
Pass-Through, but here's what I'm running into:

 

If I create a DSN using the ODBC drive and then use SQLCONNECT('dsn-name'),
the connection is made and if the database file "trnslate.db" doesn't
already exist it is created in the folder I designated in the Database Name
field of the DSN. 

 

However, if I create DSN-Less connection (SQLSTRINGCONNECT) using the
connection string I get back using SQLGETPROP(lnhandle,"ConnectString") , I
get a handle, but it is to a "trnslate.db" database that doesn't contain the
table I previously created and if the "trnslate.db" table doesn't already
exist in the designated folder, it is NOT created on the hard drive.
However, it apparently IS created in memory. I can create a table and issue
a select command and get back the results I expect, but a database file is
NEVER physically created on the hard drive which I need to do for my
purposes. 

 

Here is some sample code to see if you can tell me where I'm going wrong:

 

liH = SQLSTRINGCONNECT("DRIVER=SQLite3 ODBC Driver;" + ;

"DBNAME=T:\trnslate.db;" + ;

"PWD=;" + ;

"StepAPI=0;" + ;

"SyncPragma=;" + ;

"NoTXN=0;" + ;

"Timeout=;" + ;

"ShortNames=0;" + ;

"LongNames=0;" + ;

"NoCreat=0;" + ;

"NoWCHAR=0;" + ;

"FKSupport=0;" + ;

"JournalMode=;" + ;

"OEMCP=0;" + ;

"BigInt=0;" + ;

"JDConv=0;" + ;

"TraceFile=;")

 

SQLExec(m.liH, "create table EmplImport (id int primary key, dummy
varchar(50));")

SQLExec(m.liH, "insert into EmplImport (id, dummy) values (1,'testing');")

SQLExec(m.liH, "select * from EmplImport;",'dbtest')

 

SQLDISCONNECT(liH)

 

I've tried this process about hundred differ ways with different
combinations of paired keys in the connection string without success. I've
used a DSN-less connection program that I wrote which works perfectly with
SQL, MySQL and others and though I never fail to get a handle; the database
file never physically exists in any path on the hard drive. Complete
searches of my hard drive for the database name yield no results

 

The code above gives me a value for m.liH which is greater than zero, I
never get errors thrown, I always get a valid handle, the table can be
created, the data inserted and I get a cursor back from the select named
'dbtest' with the exact data inserted on the previous line. 

 

I've been on this for about six hours and I'm no closer to making this work
as a DSN-less project even though Whil seemed to imply in the book that this
was his preferred method of doing things. 

 

HELP!

 

Paul H. Tarver 
Email:  <mailto:p...@tpcqpc.com> p...@tpcqpc.com

 

 



--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/05cd01d35e6f$d017d540$70477fc0$@tpcqpc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Reading from SQLite

2017-04-27 Thread Ted Roche

So, what's your theory? You have the data, you'll need to make the
hypotheses and test them out. Perhaps they are storing the dates as a
offset in seconds since June of 2003, or perhaps there's something
else going on. If you know the correct date for a couple of records,
you should be able to match them against these 9-digit elements and
work out the pattern.

In SQLite3, if you issued a "SELECT * FROM " do you see the
same values you see in VFP?

I don't know why they would be coming back as memo fields.

So, I just installed SQLite3 and the ODBC driver, created a test
database and table with a date and datetime, populated it, created a
DSN for VFP to connect to, queried the database table and got back a
date and a datetime.

You'll need to supply more information, or work it out for yourself.

On Thu, Apr 27, 2017 at 2:36 PM, José Olavo Cerávolo
<jocerav...@yahoo.com> wrote:
> Ok, here's the information I get with SQLite3, the Dates are stored with 9 
> characters.
>
> database page size:  4096
> write format:2
> read format: 2
> reserved bytes:  0
> file change counter: 347
> database page count: 532
> freelist page count: 0
> schema cookie:   45
> schema format:   4
> default cache size:  0
> autovacuum top root: 39
> incremental vacuum:  1
> text encoding:   1 (utf8)
> user version:0
> application id:  0
> software version:3014000
> number of tables:23
> number of indexes:   14
> number of triggers:  0
> number of views: 0
> schema size: 8265
> Subject: Re: Reading from SQLite
> Message-ID:
>

Re: Reading from SQLite

2017-04-27 Thread Stephen Russell

Try this page as well:

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

Time Strings

A time string can be in any of the following formats:

   1. *-MM-DD*
   2. *-MM-DD HH:MM*
   3. *-MM-DD HH:MM:SS*
   4. *-MM-DD HH:MM:SS.SSS*
   5. *-MM-DD**T**HH:MM*
   6. *-MM-DD**T**HH:MM:SS*
   7. *-MM-DD**T**HH:MM:SS.SSS*
   8. *HH:MM*
   9. *HH:MM:SS*
   10. *HH:MM:SS.SSS*
   11. *now*
   12. *DD*

On Thu, Apr 27, 2017 at 1:04 PM, Ted Roche <tedro...@gmail.com> wrote:

> On Thu, Apr 27, 2017 at 12:17 PM, José Olavo Cerávolo
> <jocerav...@yahoo.com> wrote:
> > Hi Ted,
> > The dates on the existing table are not .NULL..When I get the date using
> what you suggested, datetime(yourfield,'unixepoch','localtime'), I get
> this date on an MEMO field 1984-10-05 23:00:00. This date is not the actual
> date on the other application. The date should be in 2017.The actual value
> stored on the actual SQLite table is 459316800.
>
> Well, that's weird. THE SQLite function datetime() is expecting a
> number of 10 digits, so that's not the encoding scheme. Can you use a
> tool like SQLite3 to look at the actual data in the SQLite table and
> confirm this isn't a problem with ODBC or Fox's intepretation of the
> data?
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAJidMYLCMF8cnUsoXAAGAuaDkrEuTNS-vXwdLGJQ9efy=cw...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Reading from SQLite

2017-04-27 Thread José Olavo Cerávolo

Ok, here's the information I get with SQLite3, the Dates are stored with 9 
characters.

database page size:  4096
write format:    2
read format: 2
reserved bytes:  0
file change counter: 347
database page count: 532
freelist page count: 0
schema cookie:   45
schema format:   4
default cache size:  0
autovacuum top root: 39
incremental vacuum:  1
text encoding:   1 (utf8)
user version:    0
application id:  0
software version:    3014000
number of tables:    23
number of indexes:   14
number of triggers:  0
number of views: 0
schema size: 8265
Subject: Re: Reading from SQLite
Message-ID:

Re: Reading from SQLite

2017-04-27 Thread Ted Roche

On Thu, Apr 27, 2017 at 12:17 PM, José Olavo Cerávolo
<jocerav...@yahoo.com> wrote:
> Hi Ted,
> The dates on the existing table are not .NULL..When I get the date using what 
> you suggested, datetime(yourfield,'unixepoch','localtime'), I get this date 
> on an MEMO field 1984-10-05 23:00:00. This date is not the actual date on the 
> other application. The date should be in 2017.The actual value stored on the 
> actual SQLite table is 459316800.

Well, that's weird. THE SQLite function datetime() is expecting a
number of 10 digits, so that's not the encoding scheme. Can you use a
tool like SQLite3 to look at the actual data in the SQLite table and
confirm this isn't a problem with ODBC or Fox's intepretation of the
data?

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4sokfifY57-mWO4ZGW1wv=o_j0mnkk5dxmmjwekryh...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Reading from SQLite

2017-04-27 Thread José Olavo Cerávolo

Hi Ted,
The dates on the existing table are not .NULL..When I get the date using what 
you suggested, datetime(yourfield,'unixepoch','localtime'), I get this date on 
an MEMO field 1984-10-05 23:00:00. This date is not the actual date on the 
other application. The date should be in 2017.The actual value stored on the 
actual SQLite table is 459316800. 
There's a disconnect from what the other application is saving to what I am 
able to read. I am not able to talk to the other application programmer. I've 
read a lot of documentation about SQLite, but nothing that could actually help 
me.
Thanks,
Jose.

Message: 7
Date: Wed, 26 Apr 2017 16:58:56 -0400
From: Ted Roche <tedro...@gmail.com>
To: profoxt...@leafe.com
Subject: Re: Reading from SQLite
Message-ID:
    <cacw6n4ted4w_w0ik59nd+c30yh+tnqhn6gfdq+zgesxuymt...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

.NULL. is a perfectly valid date.

If you're getting numbers, you're likely getting dates stored as days
since some arbitrary date. Try:

select datetime(yourfield,'unixepoch','localtime') from yourtable;

José Olavo Cerávolo
http://www.ceravoloconsulting.com/

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/547081955.12729827.1493309867...@mail.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Reading from SQLite

2017-04-27 Thread Ted Roche

On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo
<jocerav...@yahoo.com> wrote:
> Hi Guys,
> I sent a message but it guess it was misplaced.I am trying to read a SQLite 
> database, but I have problems with the data.I can connect to it, read the 
> tables, but the values are messed up.I can't get the Dates, it comes out as 
> .NULL or with weird numbers.I've looked at the documentation, but nothing is 
> working.I am using the SQLite ODBC for SQLite version 3.
> Thanks in advance,
> Jose.

Locate and run the SQLite3.exe to give us some more info:

SQLite3 

List the tables in the database with:
.tables

List the schema for the table of interest with:
.schema 

Then you can show us the SQL you're running from VFP and what results look like.

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CACW6n4t2AVRWA8bwyO+Ti9JPOU3qzNDfE7pH5n_FMXx90=m...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Reading from SQLite

2017-04-26 Thread Ted Roche

.NULL. is a perfectly valid date.

If you're getting numbers, you're likely getting dates stored as days
since some arbitrary date. Try:

select datetime(yourfield,'unixepoch','localtime') from yourtable;

On Wed, Apr 26, 2017 at 4:23 PM, José Olavo Cerávolo
<jocerav...@yahoo.com> wrote:
> Hi Guys,
> I sent a message but it guess it was misplaced.I am trying to read a SQLite 
> database, but I have problems with the data.I can connect to it, read the 
> tables, but the values are messed up.I can't get the Dates, it comes out as 
> .NULL or with weird numbers.I've looked at the documentation, but nothing is 
> working.I am using the SQLite ODBC for SQLite version 3.
> Thanks in advance,
> Jose.
>  José Olavo Cerávolohttp://www.ceravoloconsulting.com/
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cacw6n4ted4w_w0ik59nd+c30yh+tnqhn6gfdq+zgesxuymt...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: Reading from SQLite

2017-04-26 Thread Stephen Russell

You may have the difficulty of a VFP date is not a SQL date.

getdate() is the system datetime.

-- convert a date to String

SELECT convert(varchar(25), getdate(), 120)

-- date part only

SELECT CONVERT(date, getdate())

On Wed, Apr 26, 2017 at 3:33 PM, Richard Kaye <rk...@invaluable.com> wrote:

> Whil Hentzen wrote an eBook on working with SQLLite.
>
> http://www.hentzenwerke.com/catalog/sqlite2gb.htm
>
>
> --
>
> rk
> -Original Message-
> From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of José
> Olavo Cerávolo
> Sent: Wednesday, April 26, 2017 4:24 PM
> To: profoxt...@leafe.com
> Subject: Reading from SQLite
>
> Hi Guys,
> I sent a message but it guess it was misplaced.I am trying to read a
> SQLite database, but I have problems with the data.I can connect to it,
> read the tables, but the values are messed up.I can't get the Dates, it
> comes out as .NULL or with weird numbers.I've looked at the documentation,
> but nothing is working.I am using the SQLite ODBC for SQLite version 3.
> Thanks in advance,
> Jose.
>  José Olavo Cerávolohttp://www.ceravoloconsulting.com/
>
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/cajidmyjnqutisyb+-ta__yjqjtjf9cwvx+fn8tg46a3u+ri...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: Reading from SQLite

2017-04-26 Thread Richard Kaye

Whil Hentzen wrote an eBook on working with SQLLite.

http://www.hentzenwerke.com/catalog/sqlite2gb.htm


--

rk
-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of José Olavo 
Cerávolo
Sent: Wednesday, April 26, 2017 4:24 PM
To: profoxt...@leafe.com
Subject: Reading from SQLite

Hi Guys,
I sent a message but it guess it was misplaced.I am trying to read a SQLite 
database, but I have problems with the data.I can connect to it, read the 
tables, but the values are messed up.I can't get the Dates, it comes out as 
.NULL or with weird numbers.I've looked at the documentation, but nothing is 
working.I am using the SQLite ODBC for SQLite version 3.
Thanks in advance,
Jose.
 José Olavo Cerávolohttp://www.ceravoloconsulting.com/

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/bn4pr10mb09136f1044bff4c70fa800a6d2...@bn4pr10mb0913.namprd10.prod.outlook.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reading from SQLite

2017-04-26 Thread José Olavo Cerávolo

Hi Guys,
I sent a message but it guess it was misplaced.I am trying to read a SQLite 
database, but I have problems with the data.I can connect to it, read the 
tables, but the values are messed up.I can't get the Dates, it comes out as 
.NULL or with weird numbers.I've looked at the documentation, but nothing is 
working.I am using the SQLite ODBC for SQLite version 3.
Thanks in advance,
Jose.
 José Olavo Cerávolohttp://www.ceravoloconsulting.com/

--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/520223282.7828411.1493238211...@mail.yahoo.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

2016-10-29 Thread Man-wai Chang

You may also consider creating another new account to test everything.
Good luck! ;)

On Sat, Oct 29, 2016 at 11:01 PM, Kurt @ VR-FX  wrote:
> Nope re/retent - newly sent also don't show up.
> Am sure acct settings R fine - but will Chk tonight!
> Thx,

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGv=mjaiufh17tz+hz01lu7wz+ckttdf_oa_0msnbdbwp6o...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

2016-10-29 Thread Kurt @ VR-FX

Nope re/retent - newly sent also don't show up.

Am sure acct settings R fine - but will Chk tonight!

Thx,
-K-

Sent from my iPhone

> On Oct 29, 2016, at 10:01 AM, Man-wai Chang <chan...@gmail.com> wrote:
> 
> Were those messages marked expired and got deleted automatically?
> Check account and server settings (Retention Policy)!
> 
> Or were they saved in a different Sent folder? Again, check account
> and server settings.
> 
>> On Sat, Oct 29, 2016 at 1:08 AM, Kurt Wendt <kurt_we...@globetax.com> wrote:
>> Hate to pull this TOO Far off topic. But, since SQLite was brought up. 
>> Wasn't it mentioned here that it was used as the data for Mozilla 
>> Thunderbird - the e-mail reader? I'm still having a problem in Thunderbird - 
>> but only on my laptop - where NO Emails show up in the Sent folder. I even 
>> did some research on Google - but, could not seem to find a real answer to 
>> my problem.
> 
> -- 
> .~. Might, Courage, Vision. SINCERITY!
> / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
> /( _ )\ http://sites.google.com/site/changmw
> ^ ^ May the Force and farces be with you!
> 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/0f0dcdc4-a5de-4a75-9dcd-152b4562e...@optonline.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

2016-10-29 Thread Man-wai Chang

 Were those messages marked expired and got deleted automatically?
Check account and server settings (Retention Policy)!

Or were they saved in a different Sent folder? Again, check account
and server settings.

On Sat, Oct 29, 2016 at 1:08 AM, Kurt Wendt <kurt_we...@globetax.com> wrote:
> Hate to pull this TOO Far off topic. But, since SQLite was brought up. Wasn't 
> it mentioned here that it was used as the data for Mozilla Thunderbird - the 
> e-mail reader? I'm still having a problem in Thunderbird - but only on my 
> laptop - where NO Emails show up in the Sent folder. I even did some research 
> on Google - but, could not seem to find a real answer to my problem.
>

-- 
 .~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3)
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/CAGv=mja-rtso5nzubf1p5yb4gnveq2we3z_hkjdyvpfkncf...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SQLite & Thunderbird - (Was - RE: Friday Poll (while dl'ing MS Flash Patch))

2016-10-28 Thread Kurt Wendt

Hate to pull this TOO Far off topic. But, since SQLite was brought up. Wasn't 
it mentioned here that it was used as the data for Mozilla Thunderbird - the 
e-mail reader? I'm still having a problem in Thunderbird - but only on my 
laptop - where NO Emails show up in the Sent folder. I even did some research 
on Google - but, could not seem to find a real answer to my problem. 

Regards,
Kurt Wendt
Senior Systems Analyst 

Tel. +1-212-747-9100
www.GlobeTax.com

-Original Message-
From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Vince 
Teachout
Sent: Friday, October 28, 2016 12:50 PM
To: profoxt...@leafe.com
Subject: Re: Friday Poll (while dl'ing MS Flash Patch)

On 10/28/2016 9:54 AM, Dave Crozier wrote:
> M$SQL 2012
> VFP Databases
> SQLite

How do you like SQLite, Dave?  I've downloaded it and planning to start playing 
with it so I can start Android programming.

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f2f9...@drexch02.corp.globetax.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite vs MariaDB

2013-06-17 Thread MB Software Solutions, LLC


On 6/15/2013 2:04 PM, Mike Copeland wrote:

I might be comparing apples to rutabagas, but I'm wondering what
advantages or disadvantages SQLite would have over MariaDB on a
single-workstation application setup?

In other words, I have an app. I need to store data locally, only
locally. But, I plan to take the app up a step to be multi-user, so i am
hesitant to use DBF files for data storage.

Why not use MariaDB, installed locally and accessed through 127.0.0.1,
instead of SQLite (installed locally.)

That way, if I need to install the same app in a mult-user environment,
I just install MariaDB on whatever box will be the server, and configure
each workstation to access MariaDB. If I go with SQLite, I don't have
that same expansion/growth option, do I?

Thanks for any enlightenment!

Mike Copeland



Hi Mike,

I always try to use MariaDB instead of DBFs so that I can easily upsize 
it to multi-user or use the web to make the app work for multiple offices.


--Mike



--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51bf18ad.1020...@mbsoftwaresolutions.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite vs MariaDB

2013-06-17 Thread Mike Copeland

Thanks Mike. Good advice is always appreciated!

Mike

 Original Message 
Subject: Re: SQLite vs MariaDB
From: MB Software Solutions, LLC 
mbsoftwaresoluti...@mbsoftwaresolutions.com

To: profoxt...@leafe.com
Date: 6/17/2013 9:09 AM

On 6/15/2013 2:04 PM, Mike Copeland wrote:

I might be comparing apples to rutabagas, but I'm wondering what
advantages or disadvantages SQLite would have over MariaDB on a
single-workstation application setup?

In other words, I have an app. I need to store data locally, only
locally. But, I plan to take the app up a step to be multi-user, so i am
hesitant to use DBF files for data storage.

Why not use MariaDB, installed locally and accessed through 127.0.0.1,
instead of SQLite (installed locally.)

That way, if I need to install the same app in a mult-user environment,
I just install MariaDB on whatever box will be the server, and configure
each workstation to access MariaDB. If I go with SQLite, I don't have
that same expansion/growth option, do I?

Thanks for any enlightenment!

Mike Copeland

Hi Mike,

I always try to use MariaDB instead of DBFs so that I can easily 
upsize it to multi-user or use the web to make the app work for 
multiple offices.

--Mike

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51bf3106.6020...@ggisoft.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

SQLite vs MariaDB

2013-06-15 Thread Mike Copeland

I might be comparing apples to rutabagas, but I'm wondering what 
advantages or disadvantages SQLite would have over MariaDB on a 
single-workstation application setup?


In other words, I have an app. I need to store data locally, only 
locally. But, I plan to take the app up a step to be multi-user, so i am 
hesitant to use DBF files for data storage.


Why not use MariaDB, installed locally and accessed through 127.0.0.1, 
instead of SQLite (installed locally.)


That way, if I need to install the same app in a mult-user environment, 
I just install MariaDB on whatever box will be the server, and configure 
each workstation to access MariaDB. If I go with SQLite, I don't have 
that same expansion/growth option, do I?


Thanks for any enlightenment!

Mike Copeland


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51bcacc3.2000...@ggisoft.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite vs MariaDB

2013-06-15 Thread Ed Leafe

On Jun 15, 2013, at 1:04 PM, Mike Copeland m...@ggisoft.com wrote:

 I might be comparing apples to rutabagas, but I'm wondering what advantages 
 or disadvantages SQLite would have over MariaDB on a single-workstation 
 application setup?
 
 In other words, I have an app. I need to store data locally, only locally. 
 But, I plan to take the app up a step to be multi-user, so i am hesitant to 
 use DBF files for data storage.
 
 Why not use MariaDB, installed locally and accessed through 127.0.0.1, 
 instead of SQLite (installed locally.)
 
 That way, if I need to install the same app in a mult-user environment, I 
 just install MariaDB on whatever box will be the server, and configure each 
 workstation to access MariaDB. If I go with SQLite, I don't have that same 
 expansion/growth option, do I?

File-based stores: SQLite and DBF
Server-based store: MariaDB

I would only recommend a file-based store for something that is 
*always* going to be single-user: stuff like storing preferences for an app.

For everything else, you are always better off with a database server. 
MariaDB or PostgreSQL are excellent choices here.


-- Ed Leafe






___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/a163031b-e66b-4745-8ec8-a2809009a...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: SQLite vs MariaDB

2013-06-15 Thread Mike Copeland

Okay, that clarifies my misunderstanding about SQLite...it's not in the 
same category as MariaDB because it's ONLY local whereas MariaDB can be 
used only local, but it can also be used non-local...i.e., Server-based.


Thanks Ed!

Mike

 Original Message 
Subject: Re: SQLite vs MariaDB
From: Ed Leafe e...@leafe.com
To: profoxt...@leafe.com
Date: 6/15/2013 1:41 PM

On Jun 15, 2013, at 1:04 PM, Mike Copeland m...@ggisoft.com wrote:


I might be comparing apples to rutabagas, but I'm wondering what advantages or 
disadvantages SQLite would have over MariaDB on a single-workstation 
application setup?

In other words, I have an app. I need to store data locally, only locally. But, 
I plan to take the app up a step to be multi-user, so i am hesitant to use DBF 
files for data storage.

Why not use MariaDB, installed locally and accessed through 127.0.0.1, instead 
of SQLite (installed locally.)

That way, if I need to install the same app in a mult-user environment, I just 
install MariaDB on whatever box will be the server, and configure each 
workstation to access MariaDB. If I go with SQLite, I don't have that same 
expansion/growth option, do I?

File-based stores: SQLite and DBF
Server-based store: MariaDB

I would only recommend a file-based store for something that is 
*always* going to be single-user: stuff like storing preferences for an app.

For everything else, you are always better off with a database server. 
MariaDB or PostgreSQL are excellent choices here.


-- Ed Leafe







[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/51bcbca8.3000...@ggisoft.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Malcolm Greene

Thought the following product annoucement might be of some
interest to those of you thinking about SQLite as a database
option.

Malcolm


quote
SQLiteConverter
http://www.sqlabs.com/sqliteconverter.php
Developer: Marco Bambini ma...@sqlabs.net
SQLabs today is pleased to announce SQLiteConverter, the fastest
and easiest way to convert your mySQL, PostgreSQL, Oracle
(natively) and a wide range of ODBC compliant databases (like
Microsoft SQL Server, Access, FoxPro and many others) to sqlite.
It combines a very intuitive interface with powerful features so
you can convert an existing remotely hosted database to sqlite in
few steps.
Thanks to a very intuitive wizard you'll be guide step by step to
5 easy operations in order to completely convert your remote
databases. The entire process depends on how much data you need
to convert but most of the time you'll be able to complete it in
few seconds.
SQLiteConverter is the ideal tool not only to complete a
conversion between different databases to sqlite but it is also
the ideal solution to backup your remote data to another disk
based relational sql database. You always have full control over
the conversion process, you can decide to convert the entire
database or just select the individual tables you want to backup.
/quote


--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1294925186.8131.1415104...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Alan Bourke

Since SQLite isn't really good in multiuser environments you'd have to
wonder why someone using Oracle or SQL Server would want to move to it.

-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1294925978.11028.1415105...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Malcolm Greene

 Since SQLite isn't really good in multiuser environments you'd have to wonder 
 why someone using Oracle or SQL Server would want to move to it.

ETL work.

Malcolm

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1294927765.18966.1415111...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On Thu, Jan 13, 2011 at 7:39 AM, Alan Bourke alanpbou...@fastmail.fm wrote:
 Since SQLite isn't really good in multiuser environments you'd have to
 wonder why someone using Oracle or SQL Server would want to move to it.
---

Not sure why anyone would use SQLite when developing software for others.


-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktinueqzqv2-lh-4tqiepghpp2cgqmcxth3exb...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Kevin Cully

When I'm developing utility programs in REAL Studio, the native built in 
cross-platform database is SQLite.  It's fast and easy to deploy.  Great 
for settings for a program.

For multi-user heavy-lifting database stuff, then I turn to PostgreSQL.

-Kevin


On 01/13/2011 09:27 AM, Stephen Russell wrote:
 Not sure why anyone would use SQLite when developing software for others.


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4d2f0d38.4000...@cullytechnologies.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On Thu, Jan 13, 2011 at 8:33 AM, Kevin Cully
kcu...@cullytechnologies.com wrote:
 When I'm developing utility programs in REAL Studio, the native built in
 cross-platform database is SQLite.  It's fast and easy to deploy.  Great
 for settings for a program.

 For multi-user heavy-lifting database stuff, then I turn to PostgreSQL.
---

What is the conversion time for changing the connection to PostgreSQL?
 Do you have to change any syntax in statements for fit the new
engine?  I know that oracle would be harder in joins depending on
version.

-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/AANLkTimFHOF4xVgTv9BCqy5U9Qz94nhQhO=lvwyq3...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Kevin Cully

There is a lot of difference between SQLite and PostgreSQL, for sure. 
PostgreSQL is pretty much on par with Oracle as far as abilities go and 
SQLite much more like Foxpro tables.  I wouldn't think it very feasible 
to write a complex system that could switch between the two databases.

I think my point is that SQLite has it's place in the world: Utility 
programs; light weight, low transaction programs; programs where easy 
deployment and server setup wouldn't be feasible.

-K

On 01/13/2011 09:39 AM, Stephen Russell wrote:
 What is the conversion time for changing the connection to PostgreSQL?
   Do you have to change any syntax in statements for fit the new
 engine?  I know that oracle would be harder in joins depending on
 version.



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4d2f1161.4000...@cullytechnologies.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Ed Leafe

On Jan 13, 2011, at 9:33 AM, Kevin Cully wrote:

 When I'm developing utility programs in REAL Studio, the native built in 
 cross-platform database is SQLite.  It's fast and easy to deploy.  Great 
 for settings for a program.
 
 For multi-user heavy-lifting database stuff, then I turn to PostgreSQL.

Since SQLite is built into Python, we use it for the settings and 
preferences in Dabo. It Just Works.

Developers have the option of using SQLite for their database, but they 
should only do so if they are developing single-user, local apps. We strongly 
recommend PostgreSQL, MySQL or Firebird for most use cases.



-- Ed Leafe




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/29b1e387-38a9-43a4-9084-42e2da344...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On 1/13/11 6:51 AM, Kevin Cully wrote:
 I think my point is that SQLite has it's place in the world: Utility
 programs; light weight, low transaction programs; programs where easy
 deployment and server setup wouldn't be feasible.

I use SQLite as the database for my big commercial app. This app just happens 
to be 
deployed to off-line single users around the world. The local SQLite database 
instances get and set some data on the MySQL mothership periodically, though 
(when 
online).

It would have been heavyweight to require a local database server to be 
installed on 
all these remote machines just to get the application working.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4d2f189b.2030...@ulmcnett.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On Thu, Jan 13, 2011 at 9:22 AM, Paul McNett p...@ulmcnett.com wrote:

 I use SQLite as the database for my big commercial app. This app just happens 
 to be
 deployed to off-line single users around the world. The local SQLite database
 instances get and set some data on the MySQL mothership periodically, though 
 (when
 online).

 It would have been heavyweight to require a local database server to be 
 installed on
 all these remote machines just to get the application working.
--

That sounds appropriate and at the same time not the norm for any of us.


-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/AANLkTi=xqfg+1kp4kafjgw17pynrcnxddwzxnqsfm...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Ted Roche

On Thu, Jan 13, 2011 at 8:39 AM, Alan Bourke alanpbou...@fastmail.fm wrote:

 Since SQLite isn't really good in multiuser environments you'd have to
 wonder why someone using Oracle or SQL Server would want to move to it.

SQLite is a great lightweight, small-footprint database to use on a
developer workstation. It makes it easy to right-size the client's
database schema and data onto your laptop and take it with you to work
on it.


-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktimk7mapsd0tdfpk9t6z03v7xm0r9g3cvyrnx...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On 1/13/11 8:04 AM, Stephen Russell wrote:
 On Thu, Jan 13, 2011 at 9:22 AM, Paul McNettp...@ulmcnett.com  wrote:

 I use SQLite as the database for my big commercial app. This app just 
 happens to be
 deployed to off-line single users around the world. The local SQLite database
 instances get and set some data on the MySQL mothership periodically, though 
 (when
 online).

 It would have been heavyweight to require a local database server to be 
 installed on
 all these remote machines just to get the application working.
 --

 That sounds appropriate and at the same time not the norm for any of us.

Oh, and just a sidenote: while we don't officially support it, I know of a 
handful of 
these users that have networked their sqlite database. Multiple workstations on 
their 
network successfully read/write to the single shared sqlite database. There 
haven't 
been any issues with this, which does surprise me a little. I'd imagine there 
will be 
scaling problems if they try to get dozens of computers connected to the same 
database at the same time though.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4d2f3f03.6080...@ulmcnett.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Ed Leafe

On Jan 13, 2011, at 1:05 PM, Paul McNett wrote:

 Oh, and just a sidenote: while we don't officially support it, I know of a 
 handful of 
 these users that have networked their sqlite database. Multiple workstations 
 on their 
 network successfully read/write to the single shared sqlite database. There 
 haven't 
 been any issues with this, which does surprise me a little. I'd imagine there 
 will be 
 scaling problems if they try to get dozens of computers connected to the same 
 database at the same time though.


The networking/scaling possibilities/limitations of sqlite are no 
different than for VFP using DBFs. Before I learned how to use VFP with 
database servers, I created several large networked multi-user apps that worked 
just fine. The highest concurrent usage was 400 users.


-- Ed Leafe




___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/53f2f6b3-6e54-4447-b151-058f5b07e...@leafe.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On 1/13/11 10:11 AM, Ed Leafe wrote:
 On Jan 13, 2011, at 1:05 PM, Paul McNett wrote:

 Oh, and just a sidenote: while we don't officially support it, I know of a 
 handful of
 these users that have networked their sqlite database. Multiple workstations 
 on their
 network successfully read/write to the single shared sqlite database. There 
 haven't
 been any issues with this, which does surprise me a little. I'd imagine 
 there will be
 scaling problems if they try to get dozens of computers connected to the same
 database at the same time though.


   The networking/scaling possibilities/limitations of sqlite are no 
 different than for VFP using DBFs. Before I learned how to use VFP with 
 database servers, I created several large networked multi-user apps that 
 worked just fine. The highest concurrent usage was 400 users.

True. I guess I was thinking that the transactional capabilities could cause 
some 
conflicts, since they would be handled on each client individually since 
there's no 
central server. But it seems to work just fine.

I still have an app in the field that uses DBF's on a network share, it it 
works just 
fine too, and uses transactions, so I'm not sure in retrospect exactly why I 
was 
surprised WRT sqlite!

Paul

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4d2f5486.7010...@ulmcnett.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Paul Hill

On Thu, Jan 13, 2011 at 4:19 PM, Ted Roche tedro...@gmail.com wrote:
 On Thu, Jan 13, 2011 at 8:39 AM, Alan Bourke alanpbou...@fastmail.fm wrote:

 Since SQLite isn't really good in multiuser environments you'd have to
 wonder why someone using Oracle or SQL Server would want to move to it.

 SQLite is a great lightweight, small-footprint database to use on a
 developer workstation. It makes it easy to right-size the client's
 database schema and data onto your laptop and take it with you to work
 on it.

It's also useful in embedded situations.  I think the Kindle uses it.

-- 
Paul

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktikhop9vzypafjqziw1_-8072c5cgoj7phjw9...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Alan Bourke



On Thu, 13 Jan 2011 19:55 +, Paul Hill paulroberth...@gmail.com
wrote:

 
 It's also useful in embedded situations.  I think the Kindle uses it.
 

As does Android.
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1294953483.20918.1415186...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Alan Bourke

On Thu, 13 Jan 2011 11:37 -0800, Paul McNett p...@ulmcnett.com wrote:

I still have an app in the field that uses DBF's on a network share, it
it works just
fine too, and uses transactions, so I'm not sure in retrospect exactly
why I was
surprised WRT sqlite!

Paul

Possibly because you read this beforehand
(http://www.sqlite.org/faq.html#q5):

SQLite uses reader/writer locks to control access to the database.
(Under Win95/98/ME which lacks support for reader/writer locks, a
probabilistic simulation is used instead.) But use caution: this locking
mechanism might not work correctly if the database file is kept on an
NFS filesystem. This is because fcntl() file locking is broken on many
NFS implementations. You should avoid putting SQLite database files on
NFS if multiple processes might try to access the file at the same time.
On Windows, Microsoft's documentation says that locking may not work
under FAT filesystems if you are not running the Share.exe daemon.
People who have a lot of experience with Windows tell me that file
locking of network files is very buggy and is not dependable. If what
they say is true, sharing an SQLite database between two or more Windows
machines might cause unexpected problems.

We are aware of no other embedded SQL database engine that supports as
much concurrency as SQLite. SQLite allows multiple processes to have the
database file open at once, and for multiple processes to read the
database at once. When any process wants to write, it must lock the
entire database file for the duration of its update. But that normally
only takes a few milliseconds. Other processes just wait on the writer
to finish then continue about their business. Other embedded SQL
database engines typically only allow a single process to connect to the
database at once.

However, client/server database engines (such as PostgreSQL, MySQL, or
Oracle) usually support a higher level of concurrency and allow multiple
processes to be writing to the same database at the same time. This is
possible in a client/server database because there is always a single
well-controlled server process available to coordinate access. If your
application has a need for a lot of concurrency, then you should
consider using a client/server database. But experience suggests that
most applications need much less concurrency than their designers
imagine.
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/1294953541.21064.1415186...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On Thu, Jan 13, 2011 at 1:55 PM, Paul Hill paulroberth...@gmail.com wrote:
 On Thu, Jan 13, 2011 at 4:19 PM, Ted Roche tedro...@gmail.com wrote:
 On Thu, Jan 13, 2011 at 8:39 AM, Alan Bourke alanpbou...@fastmail.fm wrote:

 Since SQLite isn't really good in multiuser environments you'd have to
 wonder why someone using Oracle or SQL Server would want to move to it.

 SQLite is a great lightweight, small-footprint database to use on a
 developer workstation. It makes it easy to right-size the client's
 database schema and data onto your laptop and take it with you to work
 on it.

 It's also useful in embedded situations.  I think the Kindle uses it.



For the one off app like the Kindle or a phone it fits great.  For
apps that the population of this list write it seems out of place.


-- 
Stephen Russell

Sr. Production Systems Programmer
CIMSgts

901.246-0159 cell

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/AANLkTi=fNkyH+gw+tiezonuhycieVO=vragrqn69s...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

2011-01-13 Thread Ted Roche

On Thu, Jan 13, 2011 at 2:55 PM, Paul Hill paulroberth...@gmail.com wrote:

 It's also useful in embedded situations.  I think the Kindle uses it.

Embedded in other applications as well as hardware. FireFox uses it to
store bookmarks, history and other stuff.

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/AANLkTi=sbd0sc5cmrbmajyc5zi5vsjbd6buv_bdmo...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Convert variety of databases (including Access, FoxPro) to SQLite

On 1/13/11 2:24 PM, Ted Roche wrote:
 On Thu, Jan 13, 2011 at 2:55 PM, Paul Hillpaulroberth...@gmail.com  wrote:

 It's also useful in embedded situations.  I think the Kindle uses it.

 Embedded in other applications as well as hardware. FireFox uses it to
 store bookmarks, history and other stuff.

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

I thought that Apple also used it in Time Machine and Spotlight, but it isn't 
mentioned there so I was probably mistaken.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4d2f7ed0.5070...@ulmcnett.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-11 Thread A Bain

I use a little utility called DB Browser Portable. Very small
footprint. It is designed to run from a pen drive however just copy
it to a computer if logged in remotely and run it. It even has export
capability. MSSql Express 2005 didn't have export capability and I
found this little tool to be a gem for that purpose. After finished
just delete the folder and you are done!

http://www.pendriveapps.com/database-browser-portable/

On Tue, Nov 9, 2010 at 6:34 PM, Ted Roche tedro...@gmail.com wrote:
Recently, I was troubleshooting a problem with Google Chromium's
profile - it got corrupted in a crash. The file browser was displaying
a whole bunch of SQLite databases, and I was curious what was stored
in them. There isn't a tool on my machine to browse these files
graphically, although I could always dump the schema and data with the
command-line tool.

Is anyone working with a GUI SQLite tool? Any recommendations?

I've found SQLite Studio
(http://sqlitestudio.one.pl/index.rvt?act=about) and SQLiteMan
(http://sqliteman.com/page/2.html) and there's a table of tools on the
SQLite site (http://www.sqlite.org/cvstrac/wiki?p=ManagementTools)

--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/aanlktik7s7fdt3fz75boiakh7yvt=fz6ihr76n2de...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-10 Thread Alan Bourke

I use the SQLite Manager Firefox add-on. Lots of great features.

Or the prompt ;)
-- 
  Alan Bourke
  alanpbourke (at) fastmail (dot) fm


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/1289386718.11575.1404554...@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-10 Thread Ted Roche

On Tue, Nov 9, 2010 at 7:46 PM, Kevin Cully
kcu...@cullytechnologies.com wrote:

 I've just started using SQLiteMan to manipulate the SQLite database
 schemas.  Much more robust for manipulating structures but a little
 clunky on browsing data.


Kevin (and Dan):

Thanks for the recommendation. There wasn't a pre-packaged binary for
my distro (Fedora 14), so I downloaded the source and built it. (Open
Source Rocks!). Took a couple of tries to work out all of the
dependences (blogged here:
http://blog.tedroche.com/2010/11/09/installing-sqliteman-on-fedora-14/)
and I was up and running.

It's not FoxPro, but it can be invoked from the Nautilus file manager
and looks like it has a lot of pretty nice features. Mostly I just
wanted to browse and perhaps do a SELECT or two. It seems to be
working out pretty well. Thanks!


-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktikiwkf7tq5d+lhgn-x6sjr6+wtowhe6bwole...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-10 Thread casey mcg

I have just recently installed this, so I have not used it much. But
it gets the job done.

https://addons.mozilla.org/en-US/firefox/addon/5817/

Is anyone working with a GUI SQLite tool? Any recommendations?

--
Ted Roche
Ted Roche Associates, LLC
http://www.tedroche.com

[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/aanlktikbmlx9ornemkjrg3=f2r06gt0mfxa9egcjq...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.

[NF] Experience/recommendations for a GUI SQLite tool

2010-11-09 Thread Ted Roche

Recently, I was troubleshooting a problem with Google Chromium's
profile - it got corrupted in a crash. The file browser was displaying
a whole bunch of SQLite databases, and I was curious what was stored
in them. There isn't a tool on my machine to browse these files
graphically, although I could always dump the schema and data with the
command-line tool.

Is anyone working with a GUI SQLite tool? Any recommendations?

I've found SQLite Studio
(http://sqlitestudio.one.pl/index.rvt?act=about) and SQLiteMan
(http://sqliteman.com/page/2.html) and there's a table of tools on the
SQLite site (http://www.sqlite.org/cvstrac/wiki?p=ManagementTools)

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/aanlktimnbjs_8b0vyekcjy5grujwsmu=tlhbmbccx...@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-09 Thread Kevin Cully

I use the SQLite database browser as a very light weight querying 
tool.  Very basic but fast.

I've just started using SQLiteMan to manipulate the SQLite database 
schemas.  Much more robust for manipulating structures but a little 
clunky on browsing data.

HTH.


On 11/09/2010 07:34 PM, Ted Roche wrote:
 Recently, I was troubleshooting a problem with Google Chromium's
 profile - it got corrupted in a crash. The file browser was displaying
 a whole bunch of SQLite databases, and I was curious what was stored
 in them. There isn't a tool on my machine to browse these files
 graphically, although I could always dump the schema and data with the
 command-line tool.

 Is anyone working with a GUI SQLite tool? Any recommendations?

 I've found SQLite Studio
 (http://sqlitestudio.one.pl/index.rvt?act=about) and SQLiteMan
 (http://sqliteman.com/page/2.html) and there's a table of tools on the
 SQLite site (http://www.sqlite.org/cvstrac/wiki?p=ManagementTools)



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/4cd9eb7c.6020...@cullytechnologies.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-09 Thread Jeff Johnson

Firefox has a plug in that is basically an enterprise manager  Works 
great for me.

Jeff

---

Jeff Johnson
j...@san-dc.com
(623) 582-0323

www.san-dc.com


On 11/09/2010 05:34 PM, Ted Roche wrote:
 Recently, I was troubleshooting a problem with Google Chromium's
 profile - it got corrupted in a crash. The file browser was displaying
 a whole bunch of SQLite databases, and I was curious what was stored
 in them. There isn't a tool on my machine to browse these files
 graphically, although I could always dump the schema and data with the
 command-line tool.

 Is anyone working with a GUI SQLite tool? Any recommendations?

 I've found SQLite Studio
 (http://sqlitestudio.one.pl/index.rvt?act=about) and SQLiteMan
 (http://sqliteman.com/page/2.html) and there's a table of tools on the
 SQLite site (http://www.sqlite.org/cvstrac/wiki?p=ManagementTools)



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4cd9f885.20...@san-dc.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: [NF] Experience/recommendations for a GUI SQLite tool

2010-11-09 Thread Dan Covill

Was playing with SQLite a year or so ago, and used SQLiteMan.  It worked 
fine and did what I needed - no problems with it.

Dan Covill
San Diego

On 11/9/2010 4:34 PM, Ted Roche wrote:
 Recently, I was troubleshooting a problem with Google Chromium's
 profile - it got corrupted in a crash. The file browser was displaying
 a whole bunch of SQLite databases, and I was curious what was stored
 in them. There isn't a tool on my machine to browse these files
 graphically, although I could always dump the schema and data with the
 command-line tool.

 I

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/4cda132d.8000...@san.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: anyone with experience with SQLite ?

2008-07-16 Thread Stephen Russell

On Sat, Jul 12, 2008 at 4:44 AM, Allen [EMAIL PROTECTED] wrote:
 SQL server express creates 2 files it seems. One database and a transaction
 table. Well at least its supposed to but I have seem problems where it makes
 2 temp files, changes one and deletes the transaction table. Then moans
 about it not being there. Silly bloody thing. Yes Ed I,m tending toward
 another choice. Maybe even VFP tables for membership :)
 M$ sql server express is a pain. Great when it works but crap when it
 doesn't.
 BTW for anyone playing with SQL express and asp.net for memberships, when
 you go in and alter something in the web config, it errors with Network
 Service does not have rights for a while after. That bit me and I don't know
 why it does it. Maybe the server is too slow.
-

Or it is a developer error?  hahahaha

SQL Express is just a semi dumbed down version of SQL Server, in that
you don't get the pretty GUI for design of schema or querys.

you can do those in VS200x



-- 
Stephen Russell
Sr. Production Systems Programmer
Mimeo.com
Memphis TN

901.246-0159


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

anyone with experience with SQLite ?

Does anyone on the list have experience with SQLite?
  http://sqlite.org/ 

... their home page says it is a self-contained, serverless, 
zero-configuration, transactional SQL database engine

I'm told it creates one file rather than multiple tables, which I don't 
understand, as other SQL implementations use a DBC and tables ??

This looks great -- no separate server, etc.  Is there a connector for VFP?

thanks,
Tom



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?

2008-07-12 Thread Allen

SQL server express creates 2 files it seems. One database and a transaction
table. Well at least its supposed to but I have seem problems where it makes
2 temp files, changes one and deletes the transaction table. Then moans
about it not being there. Silly bloody thing. Yes Ed I,m tending toward
another choice. Maybe even VFP tables for membership :)
M$ sql server express is a pain. Great when it works but crap when it
doesn't.
BTW for anyone playing with SQL express and asp.net for memberships, when
you go in and alter something in the web config, it errors with Network
Service does not have rights for a while after. That bit me and I don't know
why it does it. Maybe the server is too slow.
Allen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tom Cloud
Sent: 12 July 2008 11:32
To: [EMAIL PROTECTED]
Subject: anyone with experience with SQLite ?

Does anyone on the list have experience with SQLite?
  http://sqlite.org/ 

... their home page says it is a self-contained, serverless,
zero-configuration, transactional SQL database engine

I'm told it creates one file rather than multiple tables, which I don't
understand, as other SQL implementations use a DBC and tables ??

This looks great -- no separate server, etc.  Is there a connector for VFP?

thanks,
Tom



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?

Is SQL server express the same as SQLite ?


At 04:44 AM 7/12/2008, you wrote:
SQL server express creates 2 files it seems. One database and a transaction
table. Well at least its supposed to but I have seem problems where it makes
2 temp files, changes one and deletes the transaction table. Then moans
about it not being there. Silly bloody thing. Yes Ed I,m tending toward
another choice. Maybe even VFP tables for membership :)
M$ sql server express is a pain. Great when it works but crap when it
doesn't.
BTW for anyone playing with SQL express and asp.net for memberships, when
you go in and alter something in the web config, it errors with Network
Service does not have rights for a while after. That bit me and I don't know
why it does it. Maybe the server is too slow.
Allen

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tom Cloud
Sent: 12 July 2008 11:32
To: [EMAIL PROTECTED]
Subject: anyone with experience with SQLite ?

Does anyone on the list have experience with SQLite?
  http://sqlite.org/ 

... their home page says it is a self-contained, serverless,
zero-configuration, transactional SQL database engine

I'm told it creates one file rather than multiple tables, which I don't
understand, as other SQL implementations use a DBC and tables ??

This looks great -- no separate server, etc.  Is there a connector for VFP?

thanks,
Tom



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: anyone with experience with SQLite ?

2008-07-12 Thread Eugene Vital

Tom Cloud wrote:
 Is SQL server express the same as SQLite ?

   
No it isn't - It is much better. :)

I used SQL Lite a few years back in a C# project and it worked extremely 
well though I haven't used it extensively in a VFP app.


There is an ODBC Driver here that may help.
http://www.ch-werner.de/sqliteodbc/


I have used PostgreSQL extensively in several apps, VFP as well as C#.

Seems like a logical choice to me.

http://www.postgresql.org/
http://www.pgadmin.org/
http://pgfoundry.org/
http://pgfoundry.org/projects/psqlodbc/

 At 04:44 AM 7/12/2008, you wrote:
   
 SQL server express creates 2 files it seems. One database and a transaction
 table. Well at least its supposed to but I have seem problems where it makes
 2 temp files, changes one and deletes the transaction table. Then moans
 about it not being there. Silly bloody thing. Yes Ed I,m tending toward
 another choice. Maybe even VFP tables for membership :)
 M$ sql server express is a pain. Great when it works but crap when it
 doesn't.
 BTW for anyone playing with SQL express and asp.net for memberships, when
 you go in and alter something in the web config, it errors with Network
 Service does not have rights for a while after. That bit me and I don't know
 why it does it. Maybe the server is too slow.
 Allen

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of Tom Cloud
 Sent: 12 July 2008 11:32
 To: [EMAIL PROTECTED]
 Subject: anyone with experience with SQLite ?

 Does anyone on the list have experience with SQLite?
  http://sqlite.org/ 

 ... their home page says it is a self-contained, serverless,
 zero-configuration, transactional SQL database engine

 I'm told it creates one file rather than multiple tables, which I don't
 understand, as other SQL implementations use a DBC and tables ??

 This looks great -- no separate server, etc.  Is there a connector for VFP?

 thanks,
 Tom
 



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: anyone with experience with SQLite ?

I don't have a choice in this -- it's been selected by another developer and 
now I have to work with it.

Is it true it stores all tables, everything in one file?

Tom

At 06:53 AM 7/12/2008, you wrote:
Tom Cloud wrote:
 Is SQL server express the same as SQLite ?

   
No it isn't - It is much better. :)

I used SQL Lite a few years back in a C# project and it worked extremely 
well though I haven't used it extensively in a VFP app.


There is an ODBC Driver here that may help.
http://www.ch-werner.de/sqliteodbc/


I have used PostgreSQL extensively in several apps, VFP as well as C#.

Seems like a logical choice to me.

http://www.postgresql.org/
http://www.pgadmin.org/
http://pgfoundry.org/
http://pgfoundry.org/projects/psqlodbc/



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?

2008-07-12 Thread Bob Calco

SQLite is most definitely NOT SQL Server Express.

SQLite is a small C library that implements a self-contained, embeddable,
zero-configuration SQL database engine. Features include:

* Transactions are atomic, consistent, isolated, and durable (ACID) even
after system crashes and power failures.
* Zero-configuration - no setup or administration needed.
* Implements most of SQL92. (some features not supported)
* A complete database is stored in a single disk file.
* Database files can be freely shared between machines with different
byte orders.
* Supports databases up to 2 terabytes (241 bytes) in size.
* Sizes of strings and BLOBs limited only by available memory.
* Small code footprint: less than 30K lines of C code, less than 250KB
code space (gcc on i486)
* Faster than popular client/server database engines for most common
operations.
* Simple, easy to use API.
* Bindings for many other languages available.
* Well-commented source code with over 95% test coverage.
* Self-contained: no external dependencies.
* Sources are in the public domain. Use for any purpose.

I am using it for caching and local/disconnected storage in an application
I'm developing in .NET using a very excellent .NET binding, available here:

http://sqlite.phxsoftware.com/

It's an extremely fast database and I've grown rather fond of it for the
uses to which I am putting it. Way simpler, faster and more reliable than
Access, for those of you thinking about life after 2014. 

If you wanted to interface to it directly in FoxPro you could write an FLL
that interfaces to it through its C API, or through its DLL on Windows in
the same way you can interface to the Windows API DLLs etc. At least, I
hypothesize that the latter approach is possible. I know for sure if you
drop down to C you can use it because that's what it was built for
originally.

To make it behave like a client server database, you can write the server
piece and have clients connect to it via some protocol. For example, you
could put it behind a Windows Service and design your own wire protocol for
client apps to talk to it. You could write an ASP.NET Web Service that uses
it via ADO.NET with the binding I pointed to above, or write your own HTTP
server RESTful interface using SQLite for the backend storage, then any
client that can make HTTP requests and consume XML or JSON or whatever you
like as a transport can connect to it. You have to be careful about
threading but for the most part it's quite safe to use in multithreaded
scenarios when you know what you're doing.

SQLite is public domain which means it's free for any kind of use. It's
not viral like the GPL, so I consider it safe for commercial use. 

Overall, I highly recommend it. With a little creativity it can be used to
power a variety of applications over different architectures. And another
nice feature is the database files are completely cross platform, so it
makes the data layer easy to move around as required.

- Bob

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
 Behalf Of Tom Cloud
 Sent: Saturday, July 12, 2008 7:19 AM
 To: profox@leafe.com
 Subject: RE: anyone with experience with SQLite ?
 
 Is SQL server express the same as SQLite ?
 
 
 At 04:44 AM 7/12/2008, you wrote:
 SQL server express creates 2 files it seems. One database and a
 transaction
 table. Well at least its supposed to but I have seem problems where it
 makes
 2 temp files, changes one and deletes the transaction table. Then
 moans
 about it not being there. Silly bloody thing. Yes Ed I,m tending
 toward
 another choice. Maybe even VFP tables for membership :)
 M$ sql server express is a pain. Great when it works but crap when it
 doesn't.
 BTW for anyone playing with SQL express and asp.net for memberships,
 when
 you go in and alter something in the web config, it errors with
 Network
 Service does not have rights for a while after. That bit me and I
 don't know
 why it does it. Maybe the server is too slow.
 Allen
 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:profoxtech-
 [EMAIL PROTECTED] On
 Behalf Of Tom Cloud
 Sent: 12 July 2008 11:32
 To: [EMAIL PROTECTED]
 Subject: anyone with experience with SQLite ?
 
 Does anyone on the list have experience with SQLite?
   http://sqlite.org/
 
 ... their home page says it is a self-contained, serverless,
 zero-configuration, transactional SQL database engine
 
 I'm told it creates one file rather than multiple tables, which I
 don't
 understand, as other SQL implementations use a DBC and tables ??
 
 This looks great -- no separate server, etc.  Is there a connector for
 VFP?
 
 thanks,
 Tom
 
 
 
[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive

RE: anyone with experience with SQLite ?

The thing that bothered me when told about it was the single file part.  Isn't 
that more susceptible to corruption than the traditional multi-file approach?

Tom

At 07:35 AM 7/12/2008, Bob Calco [EMAIL PROTECTED] wrote:
SQLite is most definitely NOT SQL Server Express.

SQLite is a small C library that implements a self-contained, embeddable,
zero-configuration SQL database engine. Features include:

...

* A complete database is stored in a single disk file.





___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?

2008-07-12 Thread Allen

Don't think so, I was just telling what I did know. I don't think so as SQL
Express is a M$ product
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tom Cloud
Sent: 12 July 2008 13:19
To: [EMAIL PROTECTED]
Subject: RE: anyone with experience with SQLite ?

Is SQL server express the same as SQLite ?

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?

2008-07-12 Thread Allen

I likle others have seen problems with dbf and cdx where the index gets
currupted. However the dbf is often intact so maybe two files are better
IMHO.
Allen 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Tom Cloud
Sent: 12 July 2008 14:48
To: [EMAIL PROTECTED]
Subject: RE: anyone with experience with SQLite ?

The thing that bothered me when told about it was the single file part.
Isn't that more susceptible to corruption than the traditional multi-file
approach?

Tom

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: anyone with experience with SQLite ?

2008-07-12 Thread Paul McNett

Tom Cloud wrote:
 Does anyone on the list have experience with SQLite?
   http://sqlite.org/ 

Yes, I'm using it in my main commercial project. And, Dabo uses it to 
store preferences. It is great for what it is: simple and lightweight.


 ... their home page says it is a self-contained, serverless, 
 zero-configuration, transactional SQL database engine

Yep.


 I'm told it creates one file rather than multiple tables, which I don't 
 understand, as other SQL implementations use a DBC and tables ??

There's only one file (or, no files at all if you just keep it alive in 
memory). The file will grow in size as needed, but never shrink unless 
you explicitly tell it to 'vacuum'.


 This looks great -- no separate server, etc.  Is there a connector for VFP?

It is great for *single user* applications running locally on the same 
machine as the app. I wouldn't consider it for multi-user, ever.

I don't know about the VFP connector, sorry. I'm using it from Python 
for which there is a db-api module.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: anyone with experience with SQLite ?

2008-07-12 Thread Paul McNett

Tom Cloud wrote:
 Is SQL server express the same as SQLite ?

No.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?

2008-07-12 Thread Bob Calco

 The thing that bothered me when told about it was the single file part.
 Isn't that more susceptible to corruption than the traditional multi-
 file approach?
 
 Tom

Methinks you're letting MS Access color your assumptions about the realm of
the possible. ;)

Don't forget this bullet point:

* Transactions are atomic, consistent, isolated, and durable (ACID) even
after system crashes and power failures.

SQLite is very well engineered. Also, you can attach to more than one
database at a time in a single connection, so if you feel better
partitioning your data in separate files, you can do that too. For instance,
I have a config database, a common database (for data I want to control and
make uniform across all instances), and 1..N instance databases in my
application. I use the config database for user preferences and I can make
that work however I want, not just the way MS thinks I should be able to
configure a .NET app using app.config/machine.config schemes.

I have yet to encounter any major corruption of a SQLite database. As a
programmer you're responsible for more admin-like functions, like
backup/restore and if you need it replication. But to me that's a plus, not
a minus. I like the control and it makes the database work the way I want,
without any bells and whistles I don't need.

Again, my primary use of the tool is for .NET apps. But technologies like
Adobe AIR support SQLite out-of-the-box, so the same use of it that I make
for .NET apps -- local/disconnected databases -- works equally well with AIR
applications.

The model for most apps I write at the moment include a highly scalable
RESTful web data service built top Erlang and its Mnesia DBMS on the back
end, with SQLite providing the client-side caching/disconnected capability.
If I ever do want to go cross platform with my .NET client, I can switch
to AIR at some point, and everything else can stay the same about my
architecture. The reason I stick with it for now is that a major piece of
the app I'm building leverages integration with Lexis-Nexus HotDocs for
document assembly and the only way to integrate with it is through its COM
interface, which is an order of magnitude easier to do in .NET. HotDocs is
strictly windows so until I have a cross platform alternative to HotDocs,
I'll stick with the .NET front end. It's not like Windows isn't the
operating system of 99% of all my target market's computers anyway.

I have a separate project that doesn't need Windows COM integration with
anything and I've been building that in Adobe AIR, and it's a private-use
app that runs on Mac but could easily run on Windows or Linux too. Aside
from the usual learning curve of any new framework, AIR's quite fun to work
with as well. Though I must confess I really like .NET's new LINQ
capability. I've written my own LINQ provider that's smart enough to get my
data in connected vs. disconnected mode such that it's transparent to my
application. That's killer. I can write a similar abstraction library in
ActionScript I suppose but it's not as sexy or seamless.

Bottom line: SQLite hasn't let me down in either project yet, despite their
radically different end-user requirements. 

- Bob



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Re: anyone with experience with SQLite ?

2008-07-12 Thread Paul McNett

Tom Cloud wrote:
 Is it true it stores all tables, everything in one file?

Yes.

Paul


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

RE: anyone with experience with SQLite ?