Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build

2010-09-23 Thread Virgilio Fornazin
Which MSVC compiler has this bug? There's a link to information on that ? On Thu, Sep 23, 2010 at 10:17, Ben Harper b...@imqs.co.za wrote: I just discovered the MSVC compiler generates bad debug info for source files larger than 64k lines, which is the case with the Sqlite amalgamation. Does

Re: [sqlite] Breakpoints uncorrelated on MSVC amalgamation build

2010-09-23 Thread Virgilio Fornazin
2010. But I seem to recall the same business a few months ago, when I must have been on 2008. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto: sqlite-users-boun...@sqlite.org] On Behalf Of Virgilio Fornazin Sent: 23 September 2010 03:24 PM To: General Discussion

Re: [sqlite] String Vs Integer Index

2010-02-10 Thread Virgilio Fornazin
I think you should be asking 'How fast is SQLite locating a key in a integer column index vs a string index'... Generally, integer keys are faster in key lookups than string keys, because comparing a integer value is a single CMP CPU instruction versus a more-complicated string comparison (that

Re: [sqlite] String Vs Integer Index

2010-02-10 Thread Virgilio Fornazin
Sure (com certeza!), because it depends on the hardware and software of your target platform. 2010/2/10 Alberto Simões hashas...@gmail.com On Wed, Feb 10, 2010 at 5:42 PM, Virgilio Fornazin virgilioforna...@gmail.com wrote: I think you should be asking 'How fast is SQLite locating a key

Re: [sqlite] Data converting

2009-11-24 Thread Virgilio Fornazin
SQL does not have a specific datetime field type and also does not store it in binary format. You should perform the data type conversions by yourself. On Tue, Nov 24, 2009 at 09:50, Renato Oliveira ren...@sincronica.com.brwrote: Hello, I'm new to SQLite, and need a query to convert a number of

Re: [sqlite] Data converting

2009-11-24 Thread Virgilio Fornazin
You should read http://www.sqlite.org/datatype3.html , may help you. On Tue, Nov 24, 2009 at 10:48, Virgilio Fornazin virgilioforna...@gmail.com wrote: SQL does not have a specific datetime field type and also does not store it in binary format. You should perform the data type conversions

Re: [sqlite] sqlite3_column_name

2009-11-13 Thread Virgilio Fornazin
SELECT field as NAME does not work? On Fri, Nov 13, 2009 at 12:07, Marco Bambini ma...@sqlabs.net wrote: sqlite 3.6.19 CREATE TABLE foo (col1 INTEGER PRIMARY KEY, col2 TEXT); a SELECT rowid, col1, col2 returns the following column names with sqlite3_column_name: col1, col1, col2 Is

Re: [sqlite] sqlite programmed in C++

2009-06-02 Thread Virgilio Fornazin
Because there are many platforms that sqlite runs (and can run at some time) that doesn't have a C++ compiler available, but they always have a C compiler. []'s On Tue, Jun 2, 2009 at 12:33, Sylvain Pointeau sylvain.point...@gmail.comwrote: I didn't mean to program with sqlite in C++ ... I

Re: [sqlite] A bit OT: Good CVS client for Windows

2009-02-27 Thread Virgilio Fornazin
Eclipse perform better for me than other all (Tortoise, WinCVS, etc). Cross platform, excelent branching / merging support, visual list of modified files, etc. On Fri, Feb 27, 2009 at 03:51, J Jayavasanthan jayavasant...@gmail.comwrote: You can also use GNU WinCVS,

Re: [sqlite] SQLite Import Tool

2008-11-12 Thread Virgilio Fornazin
Hi You can use SQLite ODBC Driver and SQL Management Studio Data Transfer Wizard to perform this action. On Wed, Nov 12, 2008 at 12:45 PM, Baskaran Selvaraj [EMAIL PROTECTED] wrote: Hi All, This is Baskaran and I am looking for a vendor tool to automate the import process. We have an

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-14 Thread Virgilio Fornazin
Patch posted to CVSTRAC timeline. Please take a look. Ticket n# 3218 On Sun, Jul 13, 2008 at 11:04 AM, Virgilio Fornazin [EMAIL PROTECTED] wrote: Thanks for your quick answer... I'll take a look at it to see and submit a patch to cvstrac if needed. Also, thanks again for this great library

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-13 Thread Virgilio Fornazin
Thanks for your quick answer... I'll take a look at it to see and submit a patch to cvstrac if needed. Also, thanks again for this great library. On Sun, Jul 13, 2008 at 12:47 AM, D. Richard Hipp [EMAIL PROTECTED] wrote: On Jul 12, 2008, at 5:34 PM, Virgilio Fornazin wrote: These mutex

Re: [sqlite] SQLite 3.6.0 coming soon...

2008-07-12 Thread Virgilio Fornazin
These mutex changes, with sqlite3_initialize() / finalize() calls, will solve that problem reported that SQlite3 doesn't delete Critical Sections under MS-Windows VFS ? On Sat, Jul 12, 2008 at 6:00 PM, D. Richard Hipp [EMAIL PROTECTED] wrote: The current plan is to release SQLite version 3.6.0

Re: [sqlite] sqlite3.lib for ARMV4T processor

2008-06-12 Thread Virgilio Fornazin
IF you are using SQLite with eVC, you must enabled function level linking, because ARM linkers had a bug before eVC SP4 that generated corrupt image files. On Thu, Jun 12, 2008 at 9:39 AM, sqlite [EMAIL PROTECTED] wrote: Dear All, We are using SQLite for our application development which

Re: [sqlite] multiple writers for in-memory datastore

2008-04-19 Thread Virgilio Fornazin
what about creating a VFS for such task ? Can be accomplished in many ways, using heap memory, shared memory... not so easy to do, but not much complicated too... locking can be provided by multiple-readers single-writers locks strategies, etc... On Sat, Apr 19, 2008 at 2:29 PM, James Gregurich

Re: [sqlite] Date arithmetic question

2008-01-17 Thread Virgilio Fornazin
DATEDIFF should compute the difference by arithmetic subtracting M/Y in month case, if I'm not wrong ex: DateDiff (month, 1-1-2007, 3-30-2007) will return 2 Its that right ? A good reference for trying implementing it should be: http://www.sqlteam.com/article/datediff-function-demystified

Re: [sqlite] Proposed sqlite3_initialize() interface

2007-10-30 Thread Virgilio Fornazin
I always create and XXX_Initialize() (and also XXX_Finalize() for resources cleanup) in all libraries I created, because: - You can perform initializations that cannot be done at compile time; - You can create your internal structures in the required order (C++ has the problem of initialization

Re: [sqlite] how to get file handle from sqlite3 object?

2007-10-11 Thread Virgilio Fornazin
I'm thinking about this.. to get a 'exact' copy of a sqlite database we should implement a new public API: sqlite3 * sqlite3_clonedb(sqlite3 * db, const char * szOutput); sqlite3 * sqlite3_clonedb16(sqlite3 * db, const void * szOutput); // utf-16 version this api can do the real file copy

Re: [sqlite] Compiling amalgamation with G++

2007-09-18 Thread Virgilio Fornazin
-ldl -lpthread (at least in my last builds) On 9/18/07, Olaf Beckman Lapré [EMAIL PROTECTED] wrote: I'm trying to compile the amalgamation on Xubuntu Linux with G++ but I'm getting linking errors: several about pthread and others about dlopen() etc. Is there anything I need to add