Hello dear sqlite users,
is it ok to mix journal modes from different threads accessing the same
database?
The typical scenario is that I use one thread for reading using normal
(default) journalling (e.g. only SELECT queries are performed) and two to
four threads for writing using WAL
.
On Thu, Aug 21, 2014 at 10:07 PM, Richard Hipp d...@sqlite.org wrote:
On Thu, Aug 21, 2014 at 3:05 PM, George Ionescu geoione...@gmail.com
wrote:
Hello dear sqlite users,
is it ok to mix journal modes from different threads accessing the same
database?
SQLite does not allow you
input.
But I can live with that, as long as searching works with *and* without
diacritics.
Thanks again,
George.
On Wed, Feb 8, 2012 at 8:30 PM, Dan Kennedy danielk1...@gmail.com wrote:
On 02/09/2012 12:49 AM, George Ionescu wrote:
Hello Dan,
yes, I thought of that. But wouldn't this break
Hello all,
I would like to know how are diacritics handled in FTS, specifically if I
can index text with diacritics and search for terms without them.
For example, given the queries
CREATE VIRTUAL TABLE fts_pages USING fts4(tokenize=snowball ro_RO);
INSERT INTO fts_pages (docid,content) VALUES
Hello Dan,
yes, I thought of that. But wouldn't this break the snippet's function?
If the tokenizer will return text without diacritics, wouldn't the snippet
return the same?
Thanks,
George.
2012/2/8 Dan Kennedy danielk1...@gmail.com
On 02/08/2012 11:34 PM, George Ionescu wrote:
Hello all
Hello dear sqlite users,
Hello dr. Hipp,
I'm trying to create a user-defined function having the name LEFT but that
does not seem to work (I get an sql parsing error). All is fine if I rename
it to STRLEFT, but I'd stick to the first one since I'd like to add some
compatibility with other db
) and SQLiteDb.
Accessing sqlite via ODBC is an option. However, the ADO dependecy you're
stuck with is something that should be avoided.
Regards,
George Ionescu
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Hello Noel,
I'm reposting this message because I have the feeling that you missed the
original one.
I don't plan to replace the normal indexing, I plan to have a set of
function to create a (memory ?) index. But how do I retrieve the data
without doing a select where rowid = xxx ?
If you're
Hello dear Noel,
hello all sqlite users,
a spatial extension for sqlite would be nice, although I think that
replacing the indexing scheme (e.g. replace the current b-tree with a
quad-tree or another spatial index) is alot of work.
Just some questions / thoughts:
1. How would you handle
Hello Noel,
I don't plan to replace the normal indexing, I plan to have a set of
function to create a (memory ?) index. But how do I retrieve the data
without doing a select where rowid = xxx ?
If you're going to create a memory index, than this will be no sqlite
spatial
index extension: I'm
Hello dr. Hipp,
hello sqlite users,
I'm trying to build sqlite from cvs and I'm experiencing problems with
generating parse.h and parse.c:
I've compiled lemon.exe and it succesfully generated parse.c and parse.h
by using lemon.exe parse.y.
The problem I'm facing is that the generated parse.c is
Hello Dr. Hipp,
Hello dear sqlite users,
following my post regarding how sqlite treats
column names and the reply from Dr. Hipp, I've studied the way various RDBMS
treat column names. The document containing the results obtained is attached to
this message.
The conclusions I can draw from
Hello Dr. Hipp,
Hello dear sqlite users,
following my previous post: I did not know that I'm not allowed to post
attachments in this group...
I've added the document which compares how SQL Server, MySQL and sqlite treats
column names as an attachment to the wiki page
Hello Clay,
thanks for replying to the message,
I suspect very strongly that most SQLite users are submitting themselves
to that discipline which I suggested in an earlier message, principally
that we don't expect SQLite to cover for our own inconsistencies in column
naming. The discipline
Hello Dr. Hipp,
Hello dear sqlite users,
And I don't really think I'm asking much: all I want is that when I ask
for
Field1 column, the database engine to report Field1 and not FIELD1.
Set PRAGMA short_column_names=OFF; and that will happen.
Why doesn't that solution work for you?
Hmmm,
Hello Dr. Hipp,
Hello dear sqlite users,
while working with sqlite v3.2.1, I've noticed another annoyance in the way
sqlite returns column names (besides the bug with #1141, duplicated as #1218).
Using sqlite command line, enter the following:
sqlite3 test.db
create table test(Field1
notice the uppercase F from Field1, although field1 is requested.
So, it seems that sqlite returns column names as defined in schema, not as
requested by the user. This may not seem a big problem, but it becomes one
when working with columns and trying to refer them by name and not wanting to
Hello Gupta,
depending on the platform you're using, you could try our SQLiteDb (ActiveX COM
Wrapper) which support on-the-fly database encryption. (search for it at
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers)
Best regards,
George Ionescu
an easy one), since it breaks existing
applications.
Thanks.
Regards.
George Ionescu.
_
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
was really expecting to be able to make changes to the database
while SELECT queries are executing...
I'm using version sqlite command-line v3.1.1 beta.
Thanks.
George Ionescu.
:
you can have a whole database engine by delivering a single file to the
client.
Best regards,
George Ionescu
Hello sten,
you could try SQLiteDb Query Analyzer from
http://www.terrainformatica.com/sqlitedb
(it's included in the SQLiteDb install package).
It's not much right now but it's going to be improved alot in the next
weeks.
Best regards,
George Ionescu
Hello sten,
you could try SQLiteDb Query Analyzer from
http://www.terrainformatica.com/sqlitedb
(it's included in the SQLiteDb install package).
It's not much right now but it's going to be improved alot in the next
weeks.
Best regards,
George Ionescu
Hello Dr. Hipp,
Hello sqlite users,
I would like to know if it's legal to use sqlite documentation (sql syntax,
sqlite logo etc.) into commercial applications' documentation (which are
obviously built on top of sqlite).
Thanks.
Regards,
George Ionescu
Hello Dr. Hipp,
Hello sqlite users,
I would like to know if it's legal to use sqlite documentation (sql syntax,
sqlite logo etc.) into commercial applications' documentation (which are
obviously built on top of sqlite).
Thanks.
Regards,
George Ionescu
to the documentation.
Thanks.
How can I distinguish between *your* documentations and everyone else's ?
Regards,
George Ionescu
Hello Dr. Hipp,
hello sqlite users,
I'm looking for an sqlite-based bulletin board to run under linux. Any recommendations?
Thanks.
Regards,
George Ionescu
(results are as expected).
However, when I ask for first column's type with sqlite3_column_decltype, the result I
get is:
AFFINITYINT,[Cu
I'm using v3.0.7
Any ideas?
Regards,
George Ionescu
to tell sqlite myself the each
column's affinity.
And, according to the docs, the syntax I'm using is supported.
Regards,
George Ionescu
_
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.com/
think that you're disk is
full is more correct than sql error or missing database? Since there's really no
sql error and the database is still there.
Regards,
George Ionescu
: (the location where was the database).
So, my question is this: if sqlite cannot insert data into the database because it
doesn't have enough free space, shouldn't it return SQLITE_FULL insted of SQLITE_ERROR
?
Regards,
George Ionescu
string'
but, when the sqlite database is opened in a file viewer, 'some string' would not be
visible but only it's encrypted form.
Regards,
George Ionescu
lazily flush them.
2. If synchronous is off, and I write a single record (a single INSERT) and
a power failure occurs, will the database be affected in any way?
Regards,
George Ionescu
Hello sqlite users,
Hello dr. Hipp,
using v3.0.6, I've discovered that PRAGMA default_synchronous directive is not
working. Will this be implemented in the next version?
Regards,
George Ionescu
regards,
George Ionescu
. faster
than Access/ADO).
Best regards,
George Ionescu
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-pBusyHandler-xFunc
pPager-pBusyHandler-xFunc(pPager-pBusyHandler-pArg, busy++)
);
#endif
..
Will this behavior be implemented in the next release?
Regards,
George Ionescu
) before
returning SQLITE_BUSY ? In v3.0.4, the result is that T2 returns immediately reporting
SQLITE_BUSY, as if it is ignoring the busy timeout.
Regards,
George Ionescu
some samples written in VB: SQLiteImport, a tiny database import
utility, SQLiteBenchmark - compare SQLiteDB's performance with an Access database
(ADO/JET) and SQLiteMultiThread - hammer an sqlite database by reading data from
multiple threads.
Best regards,
George Ionescu
Hello SQLite users,
Hello Dr. Hipp,
I think I have found another way to corrupt an sqlite database: create it with v3.0.2,
add some data, open it with v2.8.14 and then try to open it back with v3.0.2.
Regards,
George Ionescu
a CREATE TABLE statement, after parsing the Parse struct isn't filled with
a Table structure).
Any ideas ?
Best regards,
George Ionescu
PS: I don't want to 'reinvent the wheel': since the parser is already there, I don't
want to create my own sql parsing functions.
I get two records, both having 1 value ?
Regards,
George Ionescu
in the real
database.
Regards,
George Ionescu
INTEGER);
INSERT INTO test2 VALUES(503);
INSERT INTO test2 VALUES(504);
SELECT * FROM test2 WHERE b='503';
SELECT * FROM test2 WHERE b'503';
produces:
b
503
b
504
Best regards,
George Ionescu
).
Just tell me how interested you are and I will try to publish it.
Regards,
George Ionescu
- Original Message -
From: Carlos Garces [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 10:59 PM
Subject: sqlite with Visual Basic
Hi!
I can use SQLLite with Visual Basic
, the following statements return the same result:
SELECT 'match' WHERE '500' = 500;
SELECT 'match' WHERE '500' = 499 + 1;
Hope I've been of some help.
Regards,
George Ionescu
but since I'm not *that* smart, I couldn't understand much of it
;-)
If this document could be of any help in implementing a better concurency access in
sqlite, you decide. Go get it at http://research.microsoft.com/pubs/ccontrol/.
Regards,
George Ionescu
is the approach you would recommend?
Regards,
George Ionescu
in mind: just a 'smarter' LIKE operator (which returns
ranking), or something more...
Best regards,
George Ionescu
, with no success: when doing PRAGMA default_temp_store, I always get
0.
I would also like to know if there are any other things involved with changing this?
Is the data integrity affected in any way? ( This might sound like a silly question,
but I have to ask it )
Best regards,
George Ionescu
be 'highlighting hits'. For this, the position / positions in
the text where the word was found would be enough (I think).
Eagerly waiting for your answers and comments,
Sincerely,
George Ionescu
-
To unsubscribe, e-mail: [EMAIL PROTECTED
51 matches
Mail list logo