Re: [sqlite] Simple SQLite-based spreadsheet?

2012-12-07 Thread Jonas Malaco Filho
Maybe you can achieve this if you use ODBC connectors and Excel Tables. *Jonas Malaco Filho* 2012/12/7 Gilles Ganault <gilles.gana...@free.fr> > Hello > > I need to enter a bunch of items into a table that I can later read > from a web app. > > I was wonderin

Re: [sqlite] Compiling SQLite3 with MSVC 2010

2012-11-03 Thread Jonas Malaco Filho
from 'i64' to 'double', possible loss of data ..\src\sqlite3.c(104170): warning C4244: '=' : conversion from 'i64' to 'double', possible loss of data Generating code Finished generating code Shell.vcxproj -> X:\jonas-malaco-filho\lib\SQLite\Shell\..\bin\x86-64\sqlite3.exe -- Rebuild

Re: [sqlite] Dump a memory DB

2012-10-31 Thread Jonas Malaco Filho
You can use the .backup command: http://www.sqlite.org/sqlite.html *Jonas Malaco Filho* 2012/10/31 Andrea Peri <aperi2...@gmail.com> > Hi, > > From the sqlite3 console, is possible to dump on disk a memory DB ? > > Thx, > > -- > - > Andrea

Re: [sqlite] "natrual" join (not "natural")

2012-10-31 Thread Jonas Malaco Filho
Maybe there could be a strict switch. It could also be useful for developing/testing stuff on SQLite that would later be sent to different a RDBMS or a custom SQL processor. *Jonas Malaco Filho* 2012/10/31 Richard Hipp <d...@sqlite.org> > On Wed, Oct 31, 2012 at 10:13 AM, Rya

Re: [sqlite] Updating on 32bit os slower than 64bit?

2012-07-16 Thread Jonas Malaco Filho
Could be different compilation settings for sqlite (or libs). *Jonas Malaco Filho* 2012/7/15 xp <needforspeed1...@gmail.com> > Hi, > > I am a sqlite newbie. I would be very grateful if anyone can answer my > question or point me to the right direction. > > I hav

Re: [sqlite] how to?

2012-06-05 Thread Jonas Malaco Filho
I think that session info is stored in sessionrestore.js, in your Firefox profile data folder. There is also a sessionrestore.bak, that may help you. You can check if you have other (older) versions of these files thanks to shadowing (or any other recovery methods). *Jonas Malaco Filho* 2012/6

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

2012-05-25 Thread Jonas Malaco Filho
Just curious, what dev language are you using? *Jonas Malaco Filho* On 25/05/2012, at 17:57, Peter Haworth <p...@lcsql.com> wrote: Just picking a random post to make my reply to. I truly wish I could get access to an external sqlite library to load at runtime. I use e devlopement la

Re: [sqlite] SQLite SELECT performance problem

2012-05-24 Thread Jonas Malaco Filho
Malaco Filho* 2012/5/24 Simon Slavin <slav...@bigfraud.org> > > On 24 May 2012, at 11:49pm, Nick <eveningn...@gmail.com> wrote: > > > The sizes of the executable files are almost identical - there's a few > > kilobytes difference. > > I have attached t

Re: [sqlite] SQLite SELECT performance problem

2012-05-24 Thread Jonas Malaco Filho
Why TEMP_STORE=1 (file by default) and not TEMP_STORE=2 (memory by default)? *Jonas Malaco Filho* 2012/5/24 Simon Slavin <slav...@bigfraud.org> > > On 24 May 2012, at 8:59pm, Nick <eveningn...@gmail.com> wrote: > > > So why does a prebuilt, downloaded from the sqlit

Re: [sqlite] is SQLite the right tool to analyze a 44GB file

2012-05-07 Thread Jonas Malaco Filho
Have you ran *.mode csv*? Jonas Malaco Filho 2012/5/7 peter korinis <kori...@earthlink.net> > Regarding SQLITE3.exe statement ".import FILE TABLE" > I created a table. > My input file is a comma-delimited text file > When I run .import I get the following &quo