On Sep 25, 2009, at 4:00 PM, Jay A. Kreibich wrote:
> According to the RFC Excel doesn't use double-quotes for anything.
Don't believe everything written on the interweb :P
Contemporary version of Excel properly quote everything that needs to
be quoted.
_
On Sep 24, 2009, at 11:47 PM, Jay A. Kreibich wrote:
> The bigger issue is that CSV isn't really a format, but more of a
> loose idea.
Right, that said, sticking to RFC 4180 is not such a bad bet:
Common Format and MIME Type for Comma-Separated Values (CSV) Files
http://www.rfc-editor.org/rfc/
On Jul 27, 2009, at 8:31 PM, W.-H. Gu wrote:
> Is there a way to disable fsync()
pragma synchronous = off
http://www.sqlite.org/pragma.html#pragma_synchronous
--
PA.
http://alt.textdrive.com/nanoki/
___
sqlite-users mailing list
sqlite-users@sqlite.o
On Jul 17, 2009, at 11:18 PM, Igor Tandetnik wrote:
> This is known as a nested-set model:
>
> http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Perhaps of interest as well:
Trees in the database: Advanced data structures
http://www.alberton.info/talks
http://www.slideshare.n
On Jun 11, 2009, at 9:05 PM, Jim Wilcoxson wrote:
> you will have to place each on its own physical disk drive to
> increase transaction rates.
Arguably, such micro management of what data block sits on what disk
spindle would be better left to the underlying volume manager or such.
A bit O
On Jun 11, 2009, at 4:53 PM, Sam Carleton wrote:
> I am a late comer to this discussion, so this might have already
> been purposed...
Additionally, if this was not mentioned already, you can partition
your database across multiple physical files through the magic of
'attach database' or s
On Mar 18, 2009, at 12:30 AM, Ken wrote:
> Does anyone know of an embedded http server that can serve and/or
> create pages from a sqlite database?
Arguably, there is an embarrassment of choices:
http://en.wikipedia.org/wiki/Comparison_of_lightweight_web_servers
To add to the confusion, here
Hello,
IPLocation.db provides access to MaxMind's GeoLite City data as a -
rather hefty- SQLite3 database.
http://alt.textdrive.com/assets/public/Nanoki/IPLocation.20090201.tar.bz2
(42.5 MB)
Usage example:
% sqlite3 IPLocation.db
select location.start as start,
location.e
On Feb 3, 2009, at 3:12 PM, Brandon, Nicholas (UK) wrote:
> I'm open to other techniques particularly if they would be simpler to
> implement and manage!
Using a queue of DML statements sound very reasonable :)
Nanoki [1] uses that technique when indexing text documents with fts3:
(1) A reques
On Dec 15, 2008, at 8:31 PM, Ofir Neuman wrote:
> What can I do in order to improve performance?
take a look at pragma temp_store = memory
http://www.sqlite.org/pragma.html#pragma_temp_store
> Will it be better to delete the content of the table instead of
> delete the table and recreate it?
Hello,
The online demo of Nanoki, a simple wiki engine implemented in Lua,
has been updated to version 1.11:
http://svr225.stepx.com:3388/a
The demo sports content from the 2008/9 Wikipedia Selection,
containing about 5500 articles, accessible through full text search,
courtesy of SQLite e
On Oct 21, 2008, at 10:44 PM, jonwood wrote:
> Given some of the comments here, one might wonder how those poor MS
> SQL Server
> folks are able to get anything working at all. ;-)
Good point. Usually, "they" don't have anything working at all :))
Cheers,
PA.
--
http://alt.textdrive.com/nan
On Oct 5, 2008, at 3:59 PM, Gilles Ganault wrote:
> Is there a trick in SQL that lets me do this? ORDER BY ASC won't do
> this.
order by to_char( account_id ) perhaps?
--
PA.
http://alt.textdrive.com/nanoki/
___
sqlite-users mailing list
sqlite-users
On Oct 3, 2008, at 4:48 PM, D. Richard Hipp wrote:
> http://www.sqlite.org/draft/syntaxdiagrams.html
> http://www.sqlite.org/draft/lang.html
>
> Comments, criticism, and error reports are welcomed - particularly if
> they are received in time to be addressed prior to the release of
> 3.6.4, curre
On Sep 7, 2008, at 1:46 AM, Peter Hoffmann wrote:
> 1) The first one is to strip out all tags before inserting new text
> into the virtual table. I don't want to do this, because I have a pure
> text interface too, where the tags in results won't hurt.
Went down that road (i.e. stripping tags be
Hello,
Nanoki, a simple, elegant wiki engine implemented in Lua.
http://alt.textdrive.com/nanoki/
Online demo:
http://svr225.stepx.com:3388/search?q=chicago
Nanoki incorporates SQLite excellent FTS module to provide full text
search.
Cheers,
PA.
On Aug 28, 2008, at 11:39 PM, Scott Hess wrote:
> There is already such a feature request at:
> http://www.sqlite.org/cvstrac/tktview?tn=2604
>
> I just added a patch there which, I believe, implements this. I'm
> going to float it on sqlite-dev to see if I'm missing anything.
Nice :) Hope to
On Aug 27, 2008, at 4:52 AM, Alexandre Courbot wrote:
> I know there is a patch at
> http://www.sqlite.org/cvstrac/tktview?tn=3140,38 that is supposed to
> improve Unicode support in FTS3. I suspect it to turn any Unicode
> character into a token - however maybe you can use it as a basis to
> imp
Hello,
On Aug 26, 2008, at 11:34 PM, Dennis Cote wrote:
> Petite Abeille wrote:
>>
>> Is it possible to use 'if not exists' in conjunction with the
>> creation
>> DDL for a virtual table?
>>
>
> No, its not possible.
>
> The sy
Hello,
% sqlite3 -version 3.5.9
FTS's snippet seems to truncate Unicode sequences at time.
For example, given the following text:
Motto: ძალა ერთობაშია (Georgian)
"Strength is in Unity"
FTS's snippet would return the extract bellow for 'Unity, Freedom,
Work':
“… ��ია (Georgian) "Strength
Hello,
Is it possible to use 'if not exists' in conjunction with the creation
DDL for a virtual table?
For example:
create table if not exists document( content text )
vs.
create virtual table if not exists document using fts3( content text )
The first statement works as advertise, but the
Hello,
Not specific to sqlite, but a rather generic SQL question...
Given a set of ids, what would be the proper way to find the records
containing all those ids?
Specifically, given a 'document_token' table containing a document_id
mapping to multiple token_id, how would one find the docume
Hello,
IPLocation.db provides access to MaxMind's GeoLite City data as a -
rather hefty- SQLite3 database.
http://alt.textdrive.com/assets/public/Nanoki/IPLocation.100.zip (48.3
MB)
Usage example:
% sqlite3 IPLocation.db
select location.start as start,
location.end as end,
On Jun 28, 2008, at 8:10 PM, [EMAIL PROTECTED] wrote:
> I see. Do you have any suggestions on where I can find out about how
> to get more specific timing information? I'm pretty much an sqlite
> novice.
In the sqlite3 command line:
.timer ON|OFF Turn the CPU timer measurement on or
On Jun 27, 2008, at 7:15 PM, Igor Tandetnik wrote:
> Personally, I never saw any DBMS that supported anything like this. I
> can't prove that none such exists, of course.
Oracle provides something called Function Based Indexes:
http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg0
On Jun 3, 2008, at 7:27 PM, Christophe Leske wrote:
> i am a new member of this list and interested in speeding up my
> sqlite queries.
There are no magic bullets, but "The SQLite Query Optimizer Overview"
is a good read:
http://www.sqlite.org/optoverview.html
As well as "Query Plans":
ht
Hello,
On May 27, 2008, at 9:47 PM, [EMAIL PROTECTED] wrote:
> Is this a limitation, or am I missing something?
Creating tables dynamically is not very useful in general, so perhaps
this is misguided, yes :)
On the other hand, an alternative I found useful is to use SQLite's
'attach databas
Hello,
On May 27, 2008, at 9:07 PM, Stephen Oberholtzer wrote:
> Well, the first thing you should bring away from this experience is
> that the
> number of VM instructions isn't really an indicator of how efficient
> the
> query is :)
Good point :)
> Now, I'm not sure exactly why one is fas
Hello,
% sqlite3 -version
3.5.9
I'm trying to figure out a frugal way to handle a unique key
constrain...
I tried using both 'insert or ignore' and a self join. The self join
seems to be noticeably faster even though 'insert or ignore' would
empirically appear to be the better deal (shorte
On May 27, 2008, at 3:21 PM, Gilles Ganault wrote:
> I have two tables, and I'd like to SELECT rows from table1 where an
> item it not in table2
Something along these lines:
selecttable1.*
from table1
left join table2
ontable2.employee = table1.employee
...
where tabl
On May 17, 2008, at 9:49 AM, Mike Marshall wrote:
> SELECT guid FROM data WHERE text MATCH SELECT query FROM category
Perhaps something along these lines:
select data.guid
fromdata
joincategory on category.guid = data.guid
where data.text match category.query
Or something :)
--
PA.
On May 16, 2008, at 11:07 PM, Igor Tandetnik wrote:
> Well, for any string A there exists another string B that sorts
> after A.
> How can I guarantee that, after I choose A as my "sorts after
> everything" marker, somebody doesn't put B into the database?
Well... not to beat a dead horse or a
On May 16, 2008, at 10:40 PM, Andrés G. Aragoneses wrote:
> Interesting, but the replacement to 'z' seems kind of a hack, I would
> not prefer magic strings...
Well... it doesn't have to be 'z'... it's just an example... choose
whatever character sequence is relevant to get the proper ordering
On May 16, 2008, at 10:41 PM, Igor Tandetnik wrote:
> That would sort 'zebra' after ''.
Well... this is meant as an example... 'z' should be whatever
character one deems appropriate, e.g. '{' or whatever utf-8 sequence
does the job.
--
PA.
http://alt.textdrive.com/nanoki/
__
On May 16, 2008, at 10:23 PM, Andrés G. Aragoneses wrote:
> If I use "ORDER BY ItemName = '', ItemNameLowered" I get 2,1,3 and I
> want to get 1,3,2. Any ideas?
Perhaps something like:
select *
from item
order by case
when name = '' then 'z'
else name
end
On May 14, 2008, at 8:10 PM, D. Richard Hipp wrote:
>
> Works for me. Did you compile the shell yourself or use the prebuilt
> binary?
Ooops... never mind... the shell works fine... I was using
sqlite3_prepare and my application was linked against a different
version of the lib...
Everythi
On May 14, 2008, at 8:10 PM, D. Richard Hipp wrote:
> Works for me. Did you compile the shell yourself or use the prebuilt
> binary?
I did compile it myself. Any additional configuration(s) one should
take care of to enable this pragma?
___
sqlite-
Hello,
On May 14, 2008, at 7:17 PM, D. Richard Hipp wrote:
> There is also a new *experimental* PRAGMA called "journal_mode"
> which can provide performance improvements under some circumstances.
I'm trying the new journal_mode pragma:
% uname -v
Darwin Kernel Version 9.2.2; root:xnu-1228.4
On May 2, 2008, at 8:50 PM, [EMAIL PROTECTED] wrote:
> Is there a way to configure SQLite using a property/config file?
> Is changing the source code the only way to affect how it behaves?
Have you looked at pragmas?
http://www.sqlite.org/pragma.html
--
PA.
http://alt.textdrive.com/nanoki/
__
On May 1, 2008, at 4:09 PM, Jay A. Kreibich wrote:
> As the document referenced above explains, you can create a user
> function called "like(A,B)" that will over-ride the built-in behavior
> for LIKE. If you're only dealing with one language, such as
> Brazilian-Portuguese, then you can jus
Hello,
[sqlite 3.5.8, Mac OS X 10.5.2]
Given the following schema [1]:
document <->> document_token <<-> token
I'm trying to retrieve some documents with a set of token(s) [2].
Things works rather fine when looking for multiple tokens:
select sum( document_token.weight ) as score,
Hello,
In "index using and explain using question", Dennis Cote wrote:
"An EXPLAIN QUERY PLAN returns three columns. The output of explain
query plan is not documented (to the best of my knowledge anyway), but
is fairly self explanatory. It shows the order that tables are scanned
and which i
On Apr 16, 2008, at 12:09 AM, Hartwig Wiesmann wrote:
> I am looking for a program that can visualize the relations between
> different tables, their connections and indices.
Martin Krzywinski's Schemaball is rather interesting:
http://www.visualcomplexity.com/vc/project_details.cfm?id=42&in
Hello,
Would adding an unique index on an integer primary key be of any
benefit? Or is it redundant?
In "Primary key and index", Ben Carlyle wrote the following:
1 Table = 1 BTree, the BTree holds the data and is ordered by ROWID
1 Table with 1 Index = 2 BTrees, the second referring to rows in
Hello,
What heuristics do people use to determine the frequency for analyzing
their indices?
Is there something equivalent to user_tab_modifications that keep
tracks of the number of inserts, updates and deletes for each table?
Thanks in advance.
Kind regards,
--
PA.
http://alt.textdrive.c
Hello,
How does one emulate a DML MERGE statement in SQLite [1]?
INSERT OR REPLACE sounds promising but the REPLACE documentation under
the ON CONFLICT clause seems to imply that in the case of a constraint
violation the existing row will be deleted entirely and then replaced
by a brand new
601 - 646 of 646 matches
Mail list logo
