Thanks, Richard and Keith for your very helpful information. I suspected that
programmers could "hide" custom collations away from prying eyes using the API.
I've scanned all files in the software's Program folder using a content search
for those collation names (Super Finder XT) and found not
On Tuesday, 1 October, 2019 11:22, Jim and Carol Ingram
wrote:
>I'm trying to use SQLite3.exe (the command-line executable) to do some
>data mining of a database generated by a commercial software product that
>incorporates the .dll version (I can see sqlite3.dll in its Program Files
>folder).
On 10/1/19, Jim and Carol Ingram wrote:
> QUESTION
> ONE: Are these "LOCALE_..." collations custom collations developed by the
> software programmers,
Yes. The application is using the sqlite3_create_collation() API
(https://www.sqlite.org/c3ref/create_collation.html) to create a new
collating
(System environment: Windows 10 using sqlite-tools-win32-x86-329.zip,
running SQLite3.exe as administrator)
I'm a newbie to SQLite but not to SQL. Apologies in advance if this has
been covered in the Archives and I just haven't found it after two days of
searching.
I'm trying to use SQ
r fail data loss in embedded use
- SQLite newbie
On Tue, Mar 12, 2019 at 12:17 PM Simon Slavin wrote:
> Other posters have taken care of very important aspects of your
> circumstances, but I wanted to mention one I didn't see anyone mention.
> Settings.
>
> If you compile
> SQLite is built from (the combined) source as part of the project build.
> [...]
If you want extra safety, I would recommend you consider using
SQLITE_DEFAULT_SYNCHRONOUS=3 which is the equivalent to using PRAGMA
synchronous=EXTRA.
Quick references:
* https://www.sqlite.org/pragma.html#pragma_s
Hi
On Tue, Mar 12, 2019 at 5:03 PM Ted Goldblatt wrote:
>
> On Tue, Mar 12, 2019 at 12:29 PM Simon Slavin wrote:
>
> > I may have missed this already being discussed.
> >
> > Will you have access to a copy of the database as it was before corruption
> > testing ? Can you use SQLite to see wheth
On Tue, Mar 12, 2019 at 12:29 PM Simon Slavin wrote:
> I may have missed this already being discussed.
>
> Will you have access to a copy of the database as it was before corruption
> testing ? Can you use SQLite to see whether it is already corrupt ? Or
> can the test run on a brand new, fresh
On Tue, Mar 12, 2019 at 1:55 PM Jim Morris wrote:
> What is the journal mode?
>
> That is a very interesting question, as a journal file certainly seems
relevant to power fail issues. Unfortunately, you have exceeded the limits
of my knowledge of either SQLite or of the underlying software on th
On 12 Mar 2019, at 9:41pm, Ted Goldblatt wrote:
> SQLITE_OMIT_xxx, SQLITE_DEFAULT_CACHE_SIZE,
> SQLITE_THREADSAFE
None of these are a problem, assuming your embedded app does not do
multi-threading.
> One of these is SQLITE_TEMP_STORE, which is set to
> "Always use memory" which strikes me a s
On Tue, Mar 12, 2019 at 12:17 PM Simon Slavin wrote:
> Other posters have taken care of very important aspects of your
> circumstances, but I wanted to mention one I didn't see anyone mention.
> Settings.
>
> If you compile SQLite without changing compilation settings, and use it
> without changi
On Mar 12, 2019, at 11:30 AM, Ted Goldblatt wrote:
>
> I have been writing software for too many decades to casually dismiss the
> possibilities of software bugs. If there couldn't be bugs in SQLite, there
> would have been no bug fixes since the version being used here, and having
> briefly per
On Tue, Mar 12, 2019 at 11:47 AM Hick Gunter wrote:
> Without gaining SQLite shell access to the actual file (e.g. copy from
> flash to PC/Linux/whatever) or some other possibility to run integrity
> checks, this is going to be hard.
>
I do have this - the firmware is able to upload a copy of the
e.org] On
Behalf Of ted.goldbl...@gmail.com
Sent: Tuesday, March 12, 2019 10:37 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] Apparent power fail data loss in embedded use - SQLite newbie
...
SQLite is configured to use “temp files always in memory”, which is suspicious
for a power
What is the journal mode?
On 3/12/2019 10:30 AM, Ted Goldblatt wrote:
On Tue, Mar 12, 2019 at 11:45 AM James K. Lowden
wrote:
On Tue, 12 Mar 2019 10:36:37 -0400
ted.goldbl...@gmail.com wrote:
The problem is basically that as part of a test, the customer wants
to power fail the device, and t
On Tue, Mar 12, 2019 at 11:45 AM James K. Lowden
wrote:
> On Tue, 12 Mar 2019 10:36:37 -0400
> ted.goldbl...@gmail.com wrote:
>
> > The problem is basically that as part of a test, the customer wants
> > to power fail the device, and then to be able to recover (after the
> > device restarts) data
I may have missed this already being discussed.
Will you have access to a copy of the database as it was before corruption
testing ? Can you use SQLite to see whether it is already corrupt ? Or can
the test run on a brand new, freshly-created database ? If neither of those,
your test won't b
Other posters have taken care of very important aspects of your circumstances,
but I wanted to mention one I didn't see anyone mention. Settings.
If you compile SQLite without changing compilation settings, and use it without
changing defaults, SQLite is extremely good at avoiding corruption, a
for staying on an old version.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von ted.goldbl...@gmail.com
Gesendet: Dienstag, 12. März 2019 15:37
An: sqlite-users@mailinglists.sqlite.org
Betreff: [EXTERNAL] [sqlite] Apparent power
On Tue, 12 Mar 2019 10:36:37 -0400
ted.goldbl...@gmail.com wrote:
> The problem is basically that as part of a test, the customer wants
> to power fail the device, and then to be able to recover (after the
> device restarts) data that was generated/stored as close to the power
> failure as possibl
I apologize in advance for the length of the following…
I have recently been handed a customer-reported problem against a legacy
embedded device (an industrial process monitor) that makes use of SQLite over
flash for storing the monitored info (it uses this internally to respond to
remote info
You can use this quick&dirty piece of software listed below to
redirect std i/o of a program to a tcp connection.
Assuming the executable file is named tcpcmd.exe. Following command line
tcpcmd 12345 "sqlite3 -batch"
will run "sqlite3 -batch" and listen on tcp port 12345 (for security
reasons i
> the monitoring program is constantly launching sqlite3.exe with new
commands or files of commands
So the monitoring program has the ability to interact with the outside
world when something changes? Can you write a service that listens for
activity from our monitoring program, and the service
SQLite is a library that is built into applications. Other than
sqlite3.exe, its not a standalone 'thing', if you will. If your
application can't be rebuilt to directly write to a SQLite database, then
the only alternatives I can think of are
- to keep doing what you're doing, or,
- look at your
Hello -
I've been following for a while, a lot of very intelligent
people here, and not a lot of fuss!!! Very nice, my compliments to
all!!
I'm just learning SQLite and using it to collect alarm values from a
monitoring system. The monitoring system can't access the SQLite file
directly, so I'v
On Sat, Aug 6, 2016 at 2:49 PM, Kevin O'Gorman
wrote:
> On Sat, Aug 6, 2016 at 2:09 AM, Dan Kennedy wrote:
>
>> On 08/06/2016 09:52 AM, Kevin O'Gorman wrote:
>>
>>> On Fri, Aug 5, 2016 at 2:03 PM, Dan Kennedy
>>> wrote:
>>>
>>> On 08/06/2016 03:28 AM, Kevin O'Gorman wrote:
On Fri, Aug
On Sat, Aug 6, 2016 at 2:09 AM, Dan Kennedy wrote:
> On 08/06/2016 09:52 AM, Kevin O'Gorman wrote:
>
>> On Fri, Aug 5, 2016 at 2:03 PM, Dan Kennedy
>> wrote:
>>
>> On 08/06/2016 03:28 AM, Kevin O'Gorman wrote:
>>>
>>> On Fri, Aug 5, 2016 at 1:08 PM, David Raymond
wrote:
..
>>
On 08/06/2016 09:52 AM, Kevin O'Gorman wrote:
On Fri, Aug 5, 2016 at 2:03 PM, Dan Kennedy wrote:
On 08/06/2016 03:28 AM, Kevin O'Gorman wrote:
On Fri, Aug 5, 2016 at 1:08 PM, David Raymond
wrote:
..
Apart from the default location of the files, it reads like your next main
concern is
On Fri, Aug 5, 2016 at 2:03 PM, Dan Kennedy wrote:
> On 08/06/2016 03:28 AM, Kevin O'Gorman wrote:
>
>> On Fri, Aug 5, 2016 at 1:08 PM, David Raymond
>> wrote:
>>
>> ..
>>
>> Apart from the default location of the files, it reads like your next main
>>> concern is how many temp files get ope
On Fri, Aug 5, 2016 at 3:03 PM, Darren Duncan
wrote:
> On 2016-08-04 7:27 AM, Jim Callahan wrote:
>
>> Steps
>> Agree with Darren Duncan and Dr. Hipp you may want to have at least 3
>> separate steps
>> (each step should be a separate transaction):
>>
>> 1. Simple load
>> 2. Create additional col
On 2016-08-04 7:27 AM, Jim Callahan wrote:
Steps
Agree with Darren Duncan and Dr. Hipp you may want to have at least 3
separate steps
(each step should be a separate transaction):
1. Simple load
2. Create additional column
3. Create index
Have you pre-defined the table you are loading data into
ed poorly.
You could verify this by checking the number of open handles in
"/proc//fd" after your process is wedged.
-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
On Behalf Of Kevin O'Gorman
Sent: Friday, August 05, 2
untested error, handled poorly.
>
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Kevin O'Gorman
> Sent: Friday, August 05, 2016 3:41 PM
> To: SQLite mailing list
> Subject: Re: [sqlite] newbie has w
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Kevin O'Gorman
Sent: Friday, August 05, 2016 3:41 PM
To: SQLite mailing list
Subject: Re: [sqlite] newbie has waited days for a DB build to complete. what's
up with this.
On Fri, Aug 5, 2016 at 12:30 PM
On Fri, Aug 5, 2016 at 12:30 PM, Igor Korot wrote:
> Hi, Kevin,
>
> On Fri, Aug 5, 2016 at 3:18 PM, Kevin O'Gorman
> wrote:
> > Okay, I followed some of the advice y'all gave and got some results.
> >
> > 1. The original problem was compromised by malformed input. However, it
> > appears that d
Hi, Kevin,
On Fri, Aug 5, 2016 at 3:18 PM, Kevin O'Gorman wrote:
> Okay, I followed some of the advice y'all gave and got some results.
>
> 1. The original problem was compromised by malformed input. However, it
> appears that did not cause the wedging of the process. See (3) below.
Where are
Okay, I followed some of the advice y'all gave and got some results.
1. The original problem was compromised by malformed input. However, it
appears that did not cause the wedging of the process. See (3) below.
2. I separated the steps, and started small. Time increased slightly
sub-linearly w
The metric for feasability is coding ease, not runtime. I'm the
bottleneck, not the machine, at least at this point.
As for adding rows, it will be about like this time: a billion or so at a
time. But there's no need to save the old data. Each round can be
separate except for a persistent "solu
On 2016/08/04 5:56 PM, Kevin O'Gorman wrote:
On Thu, Aug 4, 2016 at 8:29 AM, Dominique Devienne
wrote:
It's even less dense than that. Each character has only 3 possible values,
and thus it's pretty easy to compress down to 2 bits each, for a 16 byte
blob.
It's just hard to do that without
On Thu, Aug 4, 2016 at 8:29 AM, Dominique Devienne
wrote:
> On Thu, Aug 4, 2016 at 5:05 PM, Kevin O'Gorman
> wrote:
>
> > 3. Positions are 64 bytes always, so your size guesses are right. They
> are
> > in no particular order. I like the suggestion of a separate position
> > table, because the
On 2016/08/04 5:05 PM, Kevin O'Gorman wrote:
Lots of answers, so thanks all around. Some more info:
1. All partitions have at least 3 GB free, and it's not changing. /tmp is
3 TiB and empty.
2. I have a RAID partition, for size, but no RAID controller. As a hobby
project, I don't have spare
On Thu, Aug 4, 2016 at 5:29 PM, Dominique Devienne
wrote:
> [...] you also force SQLite's SQL parser to parse a huge amount of text.
> [...]
>
OK, maybe not the SQL parser, depends what you write out and the .import
mode
(I guess, didn't look into the details). But for sure "some" parser (CSV,
S
On Thu, Aug 4, 2016 at 5:05 PM, Kevin O'Gorman
wrote:
> 3. Positions are 64 bytes always, so your size guesses are right. They are
> in no particular order. I like the suggestion of a separate position
> table, because they're going to appear in multiple qmove records, with an
> average of abou
Lots of answers, so thanks all around. Some more info:
1. All partitions have at least 3 GB free, and it's not changing. /tmp is
3 TiB and empty.
2. I have a RAID partition, for size, but no RAID controller. As a hobby
project, I don't have spare parts, and I fear the results of a failure of a
Temp Files
Have you checked how much storage is available to the temporary file
locations?
The temporary file locations are different depending on the OS, build, VFS
and PRAGMA settings.
See the last section "5.0 Temporary File Storage Locations" of:
https://www.sqlite.org/tempfiles.html
The data
On 8/4/16, Wade, William wrote:
>
> I believe that with SQLite, if you don't specify WITHOUT ROWID your "real"
> record order is based on rowid,
Correct
>
> In principle, indices can be created by writing the needed information
> (index key, record position) in the original order, and then sorti
ugust 03, 2016 10:00 PM
To: sqlite-users
Subject: [sqlite] newbie has waited days for a DB build to complete. what's up
with this.
I'm working on a hobby project, but the data has gotten a bit out of hand.
I thought I'd put it in a real database rather than flat ASCII files.
I've g
Hello Kevin,
I'd write a utility to do it instead of using the command
line tool then add logging to the program in order to note
progress.
I like the idea of chopping it into smaller parts too.
"ON CONFLICT ROLLBACK"
You're doing one large transaction and if it rolls back
it'll have
On 4 Aug 2016, at 4:00am, Kevin O'Gorman wrote:
> I've got a problem set of about 1 billion game positions and 187GB to work
> on (no, I won't have to solve them all) that took about 4 hours for a
> generator program just to write. I wrote code to turn them into something
> SQLite could import.
One way to get a clue is to try doing this in stages. First start over and
import a much smaller amount of data, say just a 1GB fraction say, see if that
completes, and if it does, how long it takes and other factors like disk and
memory etc. If 1GB doesn't work, start smaller yet, until you h
I'm working on a hobby project, but the data has gotten a bit out of hand.
I thought I'd put it in a real database rather than flat ASCII files.
I've got a problem set of about 1 billion game positions and 187GB to work
on (no, I won't have to solve them all) that took about 4 hours for a
generato
On Sun, 7 Jun 2015 21:36:51 +0200
George wrote:
> On Sat, 06 Jun 2015 21:14:46 +0700
> Dan Kennedy wrote:
>
> > On 06/06/2015 03:19 AM, George wrote:
> > > Hello everyone,
> > >
> > > I am new to the list. I am working on an application in which I
> > > will be embedding SQLite as the database
On Sat, 06 Jun 2015 21:14:46 +0700
Dan Kennedy wrote:
> On 06/06/2015 03:19 AM, George wrote:
> > Hello everyone,
> >
> > I am new to the list. I am working on an application in which I
> > will be embedding SQLite as the database engine. The application is
> > written in C.
> >
> > I am currentl
On 06/06/2015 03:19 AM, George wrote:
> Hello everyone,
>
> I am new to the list. I am working on an application in which I will be
> embedding SQLite as the database engine. The application is written in
> C.
>
> I am currently having an issue which I am not able to resolve at the
> moment so I th
On 5 Jun 2015, at 9:19pm, George wrote:
> 1) I open a database via:
> sqlite3_initialize()
> sqlite3_open_v2
> 2) I do some work on getting metadata from the database like table
> names and their fields and then
> 3) I close the connection via:
> sqlite3_close_v2
> sqlite
5 14:19
> To: sqlite-users at mailinglists.sqlite.org
> Subject: [sqlite] Newbie issue - Linux error malloc.c:2372: sysmalloc:
> Assertion `(old_top == (((mbinptr) (((char *)
>
> Hello everyone,
>
> I am new to the list. I am working on an application in which I will be
> emb
Hello everyone,
I am new to the list. I am working on an application in which I will be
embedding SQLite as the database engine. The application is written in
C.
I am currently having an issue which I am not able to resolve at the
moment so I thought I would ask here since I am just starting out
Wenda,
Clearly, in spite of you affirming having included the SQLite assembly in
your references, the IDE isn't finding the SQLite package. If you say it's
not a problem of "using ;" directive, then the reference must be pointing
to a bad location (in this case it would get the standard
exclamati
I am trying to learn SQLite due to attempting to code my first Windows 8
app, which seems to use no other database but SQLite.. Also due to W8 apps
needing to use async in a somewhat new style of async, the only tutorial I
found on it was from Channel 9..
http://channel9.msdn.com/Shows/Visual-Studi
On Mon, 25 Mar 2013 17:46:17 -0400,
wrote:
>I installed slqite, its sqlite3 command line interface, and a GUI admin
>console. Have built and populated a couple of databases. But what I really
>want to do is to connect to sqlite databases from Visual Studio 2012 using
>Visual Basic.
>
>Downloade
larrygauthier at charter.net writes:
I installed slqite, its sqlite3 command line interface, and a GUI admin
console. Have built and populated a couple of databases. But what I really
want to do is to connect to sqlite databases from Visual Studio 2012 using
Visual Basic.
Downloaded and installe
I installed slqite, its sqlite3 command line interface, and a GUI admin
console. Have built and populated a couple of databases. But what I really
want to do is to connect to sqlite databases from Visual Studio 2012 using
Visual Basic.
Downloaded and installed the SourceForge System.Data.SQLit
Hi Joe,
Thanks for the excellent reply. Putting SQLite.Interop.dll
in my bin\Debug folder solved the problem.
I did read the download page and the faq page, but most of
that stuff is gibberish to me and not beginner friendly at
all. But all's well that ends well. I created some tables
with
William Drago wrote:
>
> 1) I'm not really sure how to install SQLite. I downloaded
> sqlite-netFx40-setup-x86-2010-1.0.82.0.exe and ran setup.
Installing System.Data.SQLite is only necessary if you need the
Visual Studio design-time components.
>
> Is that all it takes?
>
That depends on how
All,
This is my first post to this group... I'm hoping someone
can help me.
I've just wasted nearly 8 hours trying to get SQLite to work
with a C# program in Visual Studio 10 (32bit WinXP, .NET 4.0).
Here are the issues:
1) I'm not really sure how to install SQLite. I downloaded
sqlite-ne
Igor Tandetnik wrote:
On 3/21/2012 9:33 PM, Yan Seiner wrote:
I need to write some C code to interface with sqlite API. I"ve been
through the docs, and I'm hoping someone can point me to some very basic
example code that I could build on.
http://www.sqlite.org/quickstart.html
Thanks! Perfec
On 3/21/2012 9:33 PM, Yan Seiner wrote:
I need to write some C code to interface with sqlite API. I"ve been
through the docs, and I'm hoping someone can point me to some very basic
example code that I could build on.
http://www.sqlite.org/quickstart.html
--
Igor Tandetnik
_
I just started playing around with sqlite3 in earnest. I have a fairly
large database (several hundred thousand records) on an embedded box and
sqlite does an incredible job of finding what i need very fast.
My database is as simple as it gets:
CREATE VIRTUAL TABLE latlong USING rtree( id, la
>> select typeof(max(id)) from categories -- returns 'null'
>> select case max(id) when null then 1 end as NextID from categories
>
> Matching with "null" does not work the same as matching with other values.
> "null" means "I don't know." so every value matches with it.
Just the opposite - every
On Jan 27, 2012, at 8:43 PM, K Peters wrote:
> Why would the second statement still return null if the first statements
> returns 'null'?
>
>
> select typeof(max(id)) from categories -- returns 'null'
> select case max(id) when null then 1 end as NextID from categories
As mentioned, null is,
On Fri, Jan 27, 2012 at 11:43:00AM -0800, K Peters scratched on the wall:
> Hi,
>
> when my categories table is empty:
>
> Why would the second statement still return null if the first statements
> returns 'null'?
Three value logic.NULL != NULL
-j
--
Jay A. Kreibich < J A Y @ K R
On 27 Jan 2012, at 7:43pm, K Peters wrote:
> Why would the second statement still return null if the first statements
> returns 'null'?
>
>
> select typeof(max(id)) from categories -- returns 'null'
> select case max(id) when null then 1 end as NextID from categories
Matching with "null" does
Hi,
when my categories table is empty:
Why would the second statement still return null if the first statements
returns 'null'?
select typeof(max(id)) from categories -- returns 'null'
select case max(id) when null then 1 end as NextID from categories
Thanks for all help,
Kai
___
Michael,
#1 Thanks for the comments. I have the book, The Definitive Guide to
SQLite from Apress by Michael Owens, but it is the 2006 first edition.
Do you, or anyone, know if the new or 2nd edition is worth buying or
does it just cover 1 new item? I am not afraid to buy books. You should
se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/29/2011 12:17 PM, Black, Michael (IS) wrote:
> I'll note a few things here...
[snip]
Much good advice. Seconded!
ABS
- --
Alaric Snell-Pym
http://www.snell-pym.org.uk/alaric/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)
Co
e...@cox.net]
Sent: Monday, November 28, 2011 5:24 PM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Newbie question on Data Source
On 11/28/2011 4:59 PM, Simon Slavin wrote:
> On 28 Nov 2011, at 10:44pm, Dave wrote:
>
>> On 11/28/2011 4:37 PM, Simon Slavin wrote:
On 11/28/2011 4:59 PM, Simon Slavin wrote:
On 28 Nov 2011, at 10:44pm, Dave wrote:
On 11/28/2011 4:37 PM, Simon Slavin wrote:
Just to stress that the filename includes the bit after the '.'. You can have
any number of files with the same part before the '.' but different extensions.
To t
On 28 Nov 2011, at 10:44pm, Dave wrote:
> On 11/28/2011 4:37 PM, Simon Slavin wrote:
>> Just to stress that the filename includes the bit after the '.'. You can
>> have any number of files with the same part before the '.' but different
>> extensions. To tell the operating system which one you
Thanks Simon,
Actually, I knew that. Just having a bit of a multiple crash
course...all at once. I just recently built this pc and have been on XP
until recently too. I do some graphic stuff and have many same named
pics with the various .jpg, .bmp, .gif extensions.
Dave
On 11/28/2011 4:37
Thanks Igor,
I am just getting started so I am bound to get tripped up a little.
:-) That was going to be my next question anyhow, about the database
name. I was thinking we *had* to have the extension .db3 but you have
answered that. I just have been using VB.Net less than 30 days and that
On 28 Nov 2011, at 10:32pm, Igor Tandetnik wrote:
> On 11/28/2011 5:23 PM, Dave wrote:
>> Ok, I switched that and now my original database file has a .db added
>> whereas the one created by my app stays the same.
>
> It doesn't have .db added. It had it all along, you just couldn't see it.
>
>
On 11/28/2011 5:23 PM, Dave wrote:
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
It doesn't have .db added. It had it all along, you just couldn't see it.
Anyway, now you can name your file however you want. Make sure th
Thanks John.
On 11/28/2011 4:18 PM, John Drescher wrote:
You probably have "Hide extensions for known types enabled in windows"
When this is enabled windows does not display the extension for known
types so that if you have more than 1 file with the same base name they
will appear as the same
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
Thanks,
Dave
On 11/28/2011 4:14 PM, Igor Tandetnik wrote:
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3 to
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3 to it and it remains in the same folder as the other file with
one exception. The properties for my database shows:
type: Data Base File
Where the one generated at 0K with the same n
Yes, that is what I am trying to connect to. The problem is that it
apparently doesn't connect to it as it cannot see the tables in it. So
it creates another database file that has 0K in size. My database file
has the correct icon next to it's name with a little key in the pic
where the one tha
On Mon, Nov 28, 2011 at 5:13 PM, Dave wrote:
>
>
> On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
>>
>> On 11/28/2011 4:52 PM, Dave wrote:
>>>
>>> I am trying to learn VB.Net and SQLite at the same time. I have used VB6
>>> Classic in the past. I have VB Studio 2010 Pro and am just trying to
>>> ope
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
probl
On 11/28/2011 5:08 PM, Dave wrote:
I just checked and the 0K file that is created is the same name except
it has .db3 added to it's name.
Why is this suprising? Your connection string requests a file named
MyDatabase.db3. Is this not the file you want to connect to?
--
Igor Tandetnik
___
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
probl
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
problem I cannot figure out after plenty of trying. I
...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dave
Sent: Monday, November 28, 2011 4:53 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Newbie question on Data Source
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit a
problem I cannot figure out after plenty of trying. I keep getting the
error message:
On Fri, Sep 23, 2011 at 12:02 PM, Simon Slavin wrote:
> Not a problem. If your platform allows it, and your compiler can make it
> happen, do it. Problems related to that stuff come down to multi-process
> and multi-thread oversights, not using the same library from many apps.
>
A tiny expansi
On 23 Sep 2011, at 10:17am, david wrote:
> It is an embedded system so I have full control of everything. Due to memory
> size constraints the ideal thing for me would be to use a shared library.
> According to the first post, sharing a library between cgi modules and an
> application should n
Thanks guys
It is an embedded system so I have full control of everything. Due to
memory size constraints the ideal thing for me would be to use a shared
library. According to the first post, sharing a library between cgi
modules and an application should not be a problem?
David
On Thu, Sep 22, 2011 at 4:39 PM, Pavel Ivanov wrote:
> ...> might be a stupid question -- I am not sure ) Or perhaps one library
> for CGI
> > and one for the application? Or perhaps even a library for the cgi and
> the
> > application have the api as part of it?
>
If you're developing a CGI, i
> What would be the best way> to communicate with the DB? Would it make sense
> just to have one linux> shared library containing the DB API ? (I am a Linux
> newbie too -- so this> might be a stupid question -- I am not sure ) Or
> perhaps one library for CGI> and one for the application? Or p
Hi All
I am developing an embedded system based around Linux. It consists of an
application collecting small amounts of data from the USB port. I wish
to write this to SQLite. This application also needs to read small
amounts of data from the DB. The client interface is via html/cgi on a
web
On 20/06/2011 6:59 AM, Richard Hipp wrote:
> On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson wrote:
>> IIRC sqlite does *not* do any join ordering optimizations and simply
>> runs them in whatever order the query specifies. This can have
>> unfortunate effects on runtime for some queries. Can anyone
1 - 100 of 315 matches
Mail list logo
