Re: [sqlite] FW: Bug in division?

[John Drescher]

> Any reason I haven't heard back about this bug?

You did not get the rest of the discussion on your post? It is not a
bug but an implementation allowed behavior and has to do with integer
division.

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

Re: [sqlite] FW: Bug in division?

[John Drescher]

> Interesting.  It makes NO sense to return 0 when dividing two integers.
>

Never took a C/C++ class?

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

Re: [sqlite] Importing ~1000 CSV files faster

[John Drescher]

> I'm running the following script on more than 1000 2MB CSV files and I'd
> like to speed it up if possible. I noticed that a 'WAL' is running. Is there
> something better I can do to improve this process?

Use an SSD.

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

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

[John Drescher]

> What happens if you insert more than your RAM size into an in memory
> database?
> (I'm particularly interested in the Windows context).
>

Are we talking about 32bit windows? I mean under 32 bit windows the
normal address space limit (without the /3GB switch and
LARGEADDRESSAWARE link flag) is 2GB and fragmented so that the largest
single process allocation (without resorting to AWE) is somewhere
around 1.2GB to 1.5GB even if you have a system with 4GB of RAM and
8GB of swap space.

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

Re: [sqlite] SQLite3.dll for Win 64

[John Drescher]

On Mon, Jul 25, 2011 at 10:52 AM, Everton Vieira  wrote:
> So far so good but return an error:
>
> C:\Dattna\Applications\Installs\sqlite\sqlite-src-3070701>nmake -f
> Makefile.msc sqlite3.dll
>
> Microsoft (R) Program Maintenance Utility Version 10.00.30319.01
> Copyright (C) Microsoft Corporation.  All rights reserved.
>        cl.exe -O2 -Femkkeywordhash.exe  -DSQLITE_ENABLE_FTS3=1
> -DSQLITE_ENABLE_
> RTREE=1 -DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_MAX_TRIGGER_DEPTH=100
> .\tool
> \mkkeywordhash.c
> Microsoft (R) C/C++ Optimizing Compiler Version 16.00.30319.01 for x64
> Copyright (C) Microsoft Corporation.  All rights reserved.
> mkkeywordhash.c
> .\tool\mkkeywordhash.c(6) : fatal error C1034: stdio.h: no include path set
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio
> 10.0
> \VC\bin\amd64\cl.exe"' : return code '0x2'
> Stop.
> Anyone knows how can I include this path that is missing?
>

Did you run that from a "Visual Studio 2010 command prompt" ?

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

Re: [sqlite] FW: How about a proper forum rather than an e-mail list

[John Drescher]

My biggest reason for wanting a mailing list versus a forum is that I
subscribe to 20+ mailing lists that all go to my gmail account with
gmail rules to organize the content. If these mailing lists all were
forums I would not bother with most of them since that would be a lot
of work to check their status. With that said I rarely participate on
the sqlite mailing list. This is mainly because I have not had many
problems with it.

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

Re: [sqlite] How about a proper forum rather than an e-mail list

[John Drescher]

> If the mailing list was replaced by a forum, everybody would go to the forum.
>
The failure in this logic is that is not true. I already said I would
not bother with the forum and I was not the only one.

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

Re: [sqlite] Newbie question on Data Source

[John Drescher]

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
>>> 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:
>>>
>>> SQLite Error
>>> no such table: MyTableName
>>>
>>> I have the database in the project folder on my Win7 64 Pro system. The
>>> app, when run, creates an empty database file of the same name as my
>>> database file which is 13KB in size.
>>
>> What do you mean, of the same name? It's impossible to have two files with
>> the exact same name in the same folder. The two names must be different in
>> some way.  Figure out what this difference is, then it probably will become
>> clear why it happens.
>
> 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 name is:
> type: DB3 File
>

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 but with a different icon in the explorer
view.

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

Re: [sqlite] how can i unsubscribe from this forum?

[John Drescher]

Follow the link at the bottom of  each message.

On Thu, Jul 8, 2010 at 12:54 AM, Ravi Kiran  wrote:
> --
> Best Regards,
> Ravi
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



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

Re: [sqlite] Sqlite Insert Speed Optimization

[John Drescher]

> I also wrap my statements (about 500 inserts at a time) with a begin/end
> transaction.
> After these 500 i take a few seconds to read more data so sqlite should
> have time to do any housekeeping it might need.
>

Wrap more into a transaction. 500 is too small of a percentage of a million.

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

Re: [sqlite] Sqlite Insert Speed Optimization

[John Drescher]

> I was wondering if that's really so.  Wouldn't the marginal speed improvement 
> be quite small?  Is the percentage of the final rowcount really a criterion?

Each transaction costs at least 1 disk seek. Doing thousands of seeks
the result would be very slow.

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

Re: [sqlite] Sqlite Insert Speed Optimization

[John Drescher]

On Tue, Jul 13, 2010 at 12:48 PM, John Drescher <dresche...@gmail.com> wrote:
>> I was wondering if that's really so.  Wouldn't the marginal speed 
>> improvement be quite small?  Is the percentage of the final rowcount really 
>> a criterion?
>
> Each transaction costs at least 1 disk seek. Doing thousands of seeks
> the result would be very slow.
>

I guess synchronous=off eliminates this flushing / seeking though.

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

Re: [sqlite] Compiling as part of MFC C++ project

[John Drescher]

> What do I need to do to get sqlite3.c to compile in a MFC C++ project
> (Visual C++)? If I just add it to the project, I end up getting a
> compile error something like: "Unexpected end of file while searching
> for pre-compiled header directive".
>

This is a basic Visual C++ question.

http://www.delphifaq.com/faq/f923.shtml

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

Re: [sqlite] Compiling as part of MFC C++ project

[John Drescher]

>> What do I need to do to get sqlite3.c to compile in a MFC C++ project
>> (Visual C++)? If I just add it to the project, I end up getting a
>> compile error something like: "Unexpected end of file while searching
>> for pre-compiled header directive".
>>
>
> This is a basic Visual C++ question.
>
> http://www.delphifaq.com/faq/f923.shtml
>
Sorry for the noise. I guess I should not try reading mail while
playing a flash game in a second window..
John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Insert Speed Optimization

[John Drescher]

> Thanks for all the feedback!
>
> It helped a lot.
> 1. I'm going to try and see what happen if I leave the "end transaction"
> until 5 insert was done.

This is what I meant also when I said 500 was too small.

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

[sqlite] Temporary views across attached databases

[John Drescher]

I see that normal views across attached databases do not work but it
looks like I can create a temporary view across attached databases. Is
this a supported configuration? I want to make sure before I put this
in my application.

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

Re: [sqlite] Run Time Error #1 in VS2008

[John Drescher]

On Sat, Oct 9, 2010 at 12:25 PM,   wrote:
> I am working on a project in VS2008 and I am including the sqlite3 code
> directly (compared to in the past using wrappers).  The program is working
> great  (accessing DB, using calls, etc) but I have hit a peculiar issue
> during runtime.  I am getting an error from VS that is:
>
> 
> Run-Time Check Failure #1 - A cast to a smaller data type has caused a
> loss of data.  If this was intentional, you should mask the source of the
> cast with the appropriate bitmask.  For example:
>
>        char c = (i & 0xFF);
>
> Changing the code in this way will not affect the quality of the resulting
> optimized code.
>
> 
>
> Is this a common Multibyte versus Unicode error issue?
>

Mixing debug and release?

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

Re: [sqlite] Windows performance problems associated with malloc()

[John Drescher]

>
> I'm unable to run your sqlite3.exe: MSVCR100.dll no found.
>
That is visual studio 2010 runtime.

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

Re: [sqlite] Windows performance problems associated with malloc()

[John Drescher]

On Fri, Dec 17, 2010 at 3:12 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Fri, Dec 17, 2010 at 2:27 PM, John Drescher <dresche...@gmail.com> wrote:
>
>> >
>> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found.
>> >
>> That is visual studio 2010 runtime.
>>
>
> Can somebody with windows-foo please explain to me what I need to do to
> vs2010 so that it generates exe file that doe not depend on non-standard
> DLLs?
>

You probably need to enable multithreaded runtime /MT instead of
multi-threaded DLL runtime /MD in the C++ Code Generation tab. Note
that I do not have 2010 installed here so I am looking at 2008 menus..

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

Re: [sqlite] how to speed up this ?

[John Drescher]

> i m affraid so ... but what it's will be with 50 000 000 rows ? i don't
> have 100 gigabytes of memory :(

I would get a 256GB SSD.

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

Re: [sqlite] how to speed up this ?

[John Drescher]

On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane
 wrote:
> that very very much expensive :( how much you thing ?
>

$500 to $600 US.

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

Re: [sqlite] Sqlite management

[John Drescher]

On Sat, Feb 5, 2011 at 6:36 AM, mustafa  wrote:
> Hello,
>
> I am planning to write an open source software with wxWidgets
> to simplify SQLite operations(select,insert etc)
>
> There are open source alternative softwares.
> http://sourceforge.net/projects/sqlitemanager/
>
>
> http://sqlitebrowser.sourceforge.net/index.html
>
>
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
>
> Writing new a management tool is wasting time or SQLite doesn't need a
> software to simply SQLite operations.
>
> Could you please give a suggestion?
>

The big question is what will you offer that is not available on the
currently available opensource or free tools?

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

Re: [sqlite] Fw: SQLite and Windows 7

[John Drescher]

>> in the near future we will implement windows 7. My question: Is
>> SQLite running on windows 7?
>>

I have been using sqlite under windows 7 for at least 8 months without
a single issue.

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

Re: [sqlite] VC++ and SQLite

[John Drescher]

>> I know this question is not a SQLite question, but I am hoping that
>> someone here has had a similar experience and/or can point me to the right
>> place to ask this question.
>>
>> After years or using Code::Blocks and Dev-Cpp, I have recently installed
>> Visual Studio 10 Express; it is the first time I am using it, in my Windows
>> 7 machine.
>>
>> I have written, with the help of this mailing list a wrapper class for the
>> latest SQLite3 library using C::B as my development platform, now that I
>> want to switch to VS10, there were a lot of gcc specific code that I had to
>> repair and after clearing all the C++ discrepancies between MinGW's g++ and
>> MS's VC++ I have been left with this error message:
>>
>> fatal error C1853: 'Debug\sql.pch' precompiled header file is from a
>> previous version of the compiler, or the precompiled header is C++ and you
>> are using it from C (or vice versa
>>
>>
>>
>> Does anyone know how to resolve this issue or perhaps a VS10 specific

You can like the other poster said disable PCH in visual studio or
just delete all the PCH files and have VS rebuild them. The second is
what I do in Visual Studio retail versions when I get this error.

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

Re: [sqlite] VC++ and SQLite

[John Drescher]

On Mon, Nov 12, 2012 at 1:52 PM, Doug Nebeker  wrote:
> You might be surprised at the speed increase you see in compile time if
> you've got large projects.  The time isn't lost to CPU as much, but disk I/O
> time adds up when hitting many hundreds of small (header) files (even with
> an SSD).
>

This is why I use PCH. Building some of my projects take a long time
even on a 12 threaded processor with multiple SSDs.


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

Re: [sqlite] VC++ and SQLite

[John Drescher]

On Tue, Nov 13, 2012 at 8:51 AM, Arbol One  wrote:
> Following the advice of MSN:
> Open the project's Property Pages dialog box. For details, see Setting Visual 
> C++ Project Properties.
> Click the C/C++ folder.
> Click the Advanced property page.
> Modify the Force Includes property.
>
> and now my Force Include property text entry box has the word: stdafx.h
>
> This now produces the following error:
> fatal error C1083: Cannot open include file: 'stdafx.h': No such file or 
> directory
> 1>  strtools.cpp.
> What else needs to be changed now?
>
> PD
> Why is MS paying people to create software that is s complicated to use?

The PCH requirements and behavior are the same as they have been since
at least the mid 1990s but probably longer. Before that I used borland
compilers.

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

Re: [sqlite] VC++ and SQLite

[John Drescher]

On Tue, Nov 13, 2012 at 10:29 AM, Arbol One  wrote:
> Further inspection showed that there is a macro that is added, and not the 
> stdafx.h file name, the macro is 
> '%(PrecompiledHeaderFile);%(ForcedIncludeFiles)'. Nevertheless, VS10 still 
> complains with the following error:
> fatal error C1853: 'Debug\vsSamiira.pch' precompiled header file is from a 
> previous version of the compiler, or the precompiled header is C++ and you 
> are using it from C (or vice versa).
>
> How do I solve this problem?

If  this file exists delete it. And then rebuild clean.

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

Re: [sqlite] Deletion slow?

[John Drescher]

On Tue, Feb 5, 2013 at 7:54 AM, Jason Gauthier  wrote:
> Hey Everyone,
>
>  I am a fairly new user of sqlite, but not particularly new to SQL 
> principles.  I am developing an application that will run on a low end system.
> Not quite embedded, but not quite a PC.  In my application, I do frequent 
> table deletes.  My results have been poor, and I am looking for someone to 
> tell me "I'm doing it wrong", or maybe "that's the best you're going to get", 
> etc.
>
> Anyway, my table is create as such:
>
> create table trip (
> key integer primary key,
> vin varchar(17),
> ts int,
> cur_time int,
> caps varchar(20),
> cmdid int,
> value real,
> longitude real,
> latitude real);
>
> create index ivin on trip (vin);
> create index icaps on trip (caps);
> create index icur_time on trip (cur_time);
>
> sqlite> .indices
> icaps
> icur_time
> ivin
>
> I understand that a primary key index is created automatically, so it won't 
> be listed here.
>
> Now, I can execute a queries very quickly:
> ---
> time sqlite3 trip.db 'select count(*) from trip where key<=1400'
> 200
>
> real0m0.026s
> user0m0.020s
> sys 0m0.000s
> ---
> Notice there are only 200 rows that match this query!
> ---
> time sqlite3 trip.db 'select * from trip where key<=1400'
> real0m0.205s
> user0m0.030s
> sys 0m0.070s
> ---
> 200ms is not bad.
> ---
> time sqlite3 trip.db 'delete from trip where key<=1400'
>
> real0m1.532s
> user0m0.050s
> sys 0m0.020s
> ---
> The deletion takes 1.5 seconds.  This is actually fast, it usually takes 
> closer 2 seconds.
>
> Any thoughts on why this may be so slow, or what I can do to improve it?
>

Put the delete in a transaction.

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

Re: [sqlite] Bug in sqlite3.exe?

[John Drescher]

On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote:

> SQLite version 3.7.16.2 2013-04-12 11:52:43
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> .tables
> CityCountry Languages
> Country Country Official Languages
> Country CapitalsCountryLanguage
> sqlite> select count(*) from country languages;
> count(*)
> --
> 239
> sqlite> select count(*) from country official languages;
> Error: near "languages": syntax error
> sqlite> select count(*) from country official;
> count(*)
> --
> 239
> sqlite> select count(*) from countrylanguage;
> count(*)
> --
> 988
> sqlite> select count(*) from languages;
> Error: no such table: languages
> sqlite>
>
> I'm aware the version of SQLite is not current so it might already have
> been fixed.
>
>
This does not look like a bug to me. You need to escape spaces.

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

Re: [sqlite] Bug in sqlite3.exe?

[John Drescher]

On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote:

> SQLite version 3.7.16.2 2013-04-12 11:52:43
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> .tables
> CityCountry Languages
> Country Country Official Languages
> Country CapitalsCountryLanguage
> sqlite> select count(*) from country languages;
> count(*)
> --

239
>

Although I am a bit surprised that this query succeeded since there is no
languages table.

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

Re: [sqlite] Bug in sqlite3.exe?

[John Drescher]

On Tue, Sep 24, 2013 at 12:53 PM, Staffan Tylen wrote:

> Well, it's not my database I'm looking at. What puzzles me is that Country
> Languages works but Country Official Languages doesn't, so could there be a
> parsing problem?
>
>
I think I see what is happening..

when you have a space in the from the second name is being taken as an AS
(used for an alias)

So in your

You are counting the number of countries in your Country table.

The following should work in that example:

select count(languages.*) from country languages;

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

Re: [sqlite] Column names including spaces

[John Drescher]

>  For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1"
> (which I'd expect).  If I try 'SELECT "CoL 1" FROM...", I get and error "no
> such column "Col1" - notice there is no space in the column name listed in
> the error message".
>

Are you escaping the quotes for whatever language / tool you are using
so they are passed to SQLITE?

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

Re: [sqlite] Manual

[John Drescher]

On Sat, Mar 3, 2012 at 10:15 AM, Mark Schonewille
 wrote:
> Hi,
>
> MySQL has a really great manual with extensive explanations and dozens of 
> examples for each command. SQLite is none of all this. It just has a limited 
> number of pages listing a small number of commands and some special features. 
> It also has a number of really weird diagrammes.
>
> How do I read diagrammes like http://sqlite.org/images/syntax/sql-stmt.gif ?
>

Are you a programmer? That diagram is very basic and should be easy to
understand if you took university level computer science courses.

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

Re: [sqlite] What do people think of SQLite Root?

[John Drescher]

> Download the latest version Sqlite Root 1.9.7.6 
>

BTW, if you press Help then log in windows 7 using that version I get
a crash as well.



Traceback Info:
Traceback (most recent call last):
  File "core.pyo", line 2481, in actionLog
  File "framelog.pyo", line 99, in addTextFromLog
  File "codecs.pyo", line 881, in open
IOError: [Errno 2] No such file or directory: 'main.log'

System Information:
Timestamp: 2012-03-06 11:15:51.424000
Operating System: Windows NT 6.1 (build 7601, Service Pack 1)
Python Version: 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32
bit (Intel)]
wxPython Version: 2.8.12.1 (msw-unicode)
wxPython Info: (__WXMSW__, wxMSW, unicode, wx-assertions-on, SWIG-1.3.29)
Python Encoding: Default=ascii  File=mbcs
wxPython Encoding: cp1252
System Architecture: 32bit AMD64
Byte order: little
Frozen: windows_exe

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

Re: [sqlite] SQLITE3 64-bit version

[John Drescher]

> Would you know if SQLITE3 can be compiled (and if it will work) as a 64-bit
> DLL?
>

I use SQLITE as a 64 bit dll on windows. However for me it is included
with the Qt library.

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

Re: [sqlite] Disk file size

[John Drescher]

On Wed, Jun 6, 2012 at 7:42 AM, vallur raghava reddy
 wrote:
> Hi,
>     I have created a database "MyDb.db" and created a table MyTable using
> the query *create table MyTable (id INTEGER PRIMARY KEY, value
> CHARACTER(10))* and inserted 3000 records in the table.I executed query 
> *select
> * from MyTable* it returned 3000 rows and was able to print all values.
> Now the size of the db file MyDB.db is 57kb.
> After that I have deleted all the records and then I executed query *select
> * from MyTable* it returned zero rows.
> Now I have checked file size and it is same as 57kb.
> So my question is, why does the file size is not decreased after deleting
> the rows?
> Is it like the SQLite will reuse the disk space later or something?
> Please let me know about this

Issue the VACUUM statement to compact the database.

http://sqlite.org/lang_vacuum.html

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

Re: [sqlite] SQLite and C++

[John Drescher]

On Wed, Jun 13, 2012 at 7:21 AM, Arbol One  wrote:
> Anyone knows where I can find some examples of how C++ interfaces with 
> SQLite? I just need to see some code that is functional and not just some 
> snips of how it maybe-should-possibly work.


Although this is probably not what you want Qt comes with a bundled
sqlite that it uses with its C++ database classes.

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

Re: [sqlite] Problem with including sqlite3.c into c++ project

[John Drescher]

On Mon, Jun 25, 2012 at 4:15 PM, deltagam...@gmx.net
 wrote:
> Hello,
>
> Im using MSVS 2010 for an c++ GUI project.
> After including sqlite3.h and sqlite3.c from the amalgamation-3071200
> and with the Project Properties--> C/C++  --> Precompiled Headers -->
> Precompiled Header --> Use (/Yu)
> I get the error
> sqlite3.c : fatal error C1853: 'Debug\Contegos_UI.pch' precompiled header
> file is from a previous version of the compiler, or the precompiled header
> is C++ and you are using it from C (or vice versa)

This is something I see with Visual Studio from time to time (not with
sqlite but I use that with Qt):

Delete Debug\Contegos_UI.pch

and try again.

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