Re: [sqlite] Simple SQLite-based spreadsheet?

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 wondering if someone had come up with a Windows

Re: [sqlite] Compiling SQLite3 with MSVC 2010

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 All

Re: [sqlite] natrual join (not natural)

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, Ryan Johnson ryan.john

Re: [sqlite] Dump a memory DB

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 Peri . . . . . . . . . qwerty àèìòù

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

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 have a very simple database: create

Re: [sqlite] how to?

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?

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 language

Re: [sqlite] SQLite SELECT performance problem

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 sqlite website, command line tool takes

Re: [sqlite] SQLite SELECT performance problem

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 the original (downloaded from sqlite.org) sqlite3.exe

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

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 Error: FILE line 1: expected 46 columns