Thank you for this message. We've just fixed the bug you mentioned and
uploaded an updated version of SQLite Maestro at
http://www.sqlmaestro.com/products/sqlite/maestro/download/
Wow. Nice to see you folks monitoring this list.
(Support for visual relation design would be great, too.)
Hello all,
I have just come accross a bug - which is essentially and most likely a
bug in my program but results in a segfault in sqlite3 code. So I
thought I would suggest a robustness change (not to correct my bug, but
for other people not to see a segfault in the same
I want to use a integer to save the ip address of ipv4. Because they all are
4 bytes.
but it is better when the data type is unsigned int.
How to create a data of unsigned int?
1334
1335 // tcp-gate_addr[0]是地址的高8位
1336 for ( i=0, m=1; i4; i++, m*=0x100 )
1337 gateaddr =
On Aug 5, 2009, at 8:32 PM, Hamish Allan wrote:
On Wed, Aug 5, 2009 at 5:50 PM, Jean-Denis
Muysjdm...@kleegroup.com wrote:
You're top-posting, it's evil, the thread is becoming messy.
You need to look up the word evil sometime.
No I don't (even though I don't speak English natively). If
Hi,
I am using sqlite 3.6.16 in my application to create a database. I am
aware that sqlite supports Unicode and it expects the database file path
to be either UTF-8 or UTF-16 encoded. But my application supports only
ANSI (ASCII + rest of the 128 characters in the machine's character map)
and I
Hi,
I'm getting a Disk I/O error when committing a transaction on an AIX system.
The extended result code is 1290. Which i believe means that the extended code
is a SQLITE_IOERR_DIR_FSYNC error.
Any ideas why this is happening or how to track it down?
Thanks,
Ken
On Wed, Aug 5, 2009 at 8:20 PM, Jean-Denis Muysjdmuys...@free.fr wrote:
No I don't (even though I don't speak English natively). If you google
top posting evil you will realize that evil has been associated
with top posting for longer than I can remember.
And Natalie Portman has been
Hi,
Thank you anybody for your replies and ideas to FTS and postfix
search. I thought a lot about it and came to the conclusion: In general
it is not necessary for a fulltext system not find subwords. If it would
be, then I either need no index (search through whole data) or put
subwords into
int64 type is okay to store data of type unsigned int. And int64 is
exactly the type used for all integers in SQLite.
Pavel
On Fri, Aug 7, 2009 at 5:53 AM, liubin liu7101...@sina.com wrote:
I want to use a integer to save the ip address of ipv4. Because they all are
4 bytes.
but it is
Thanks, :)
But now I think that's ok to use the int type to store the four byte.
Because I could get the value by using forced conversion.
But Do SQLite3 support the unsigned type?
And You know that int64 is too wasting here.
Pavel Ivanov-2 wrote:
int64 type is okay to store data of type
SQLite doesn't support unsigned types. And int64 is not too wasting
for you unless you work with negative numbers (which you are not
because you work with unsigned numbers). It's because SQLite always
does compacting of integer numbers - if number fits into 1 byte then
it stores 1 byte, if it fits
On Aug 4, 2009, at 5:07 AM, Kenneth Long wrote:
Hi,
I'm getting a Disk I/O error when committing a transaction on an AIX
system.
The extended result code is 1290. Which i believe means that the
extended code is a SQLITE_IOERR_DIR_FSYNC error.
Any ideas why this is happening or how
I'm trying to take a CSV file and create a sqlite3 database for the
iPhone.
The CSV file has 33K entries and is 2 MB. The problem I am having is that
only about 1/10 of the database file gets written into the sqlite3
database.
The .import csv method is imperfect; if you have quoted strings
This is why I generally advocate TAB delimited files over CSV
Restaurant , Menu Item, Price
Tom, Dick The MAN, and Harry's Bar Grill , Specials /new stuff! Mikey's
Burger Delishiousness ' , $5
If you only have to upload your data once, you should be able to use a
spreadsheet program to
Have you tried my SQLiteManager app?
http://www.sqlabs.com/sqlitemanager.php
It can easily convert/import your CSV file into an sqlite3 database.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Aug 7, 2009, at 4:57 PM, Adam DeVita wrote:
This is why I
John Machin wrote:
On 7/08/2009 1:21 PM, aerende wrote:
I'm trying to take a CSV file and create a sqlite3 database for the
iPhone.
The CSV file has 33K entries and is 2 MB. The problem I am having is
that
only about 1/10 of the database file gets written into the sqlite3
database.
This is why I generally advocate TAB delimited files over CSV
How does .mode tabs cope with quoted strings with tabs or newlines in them?
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
sqlite-amalgamation-3_6_16.zip
win32
msvc 2008 sp1
func sqlite3_open_v2() is called with 'flag' param = SQLITE_OPEN_FULLMUTEX
| SQLITE_OPEN_READWRITE
in sqlite3_initialize() func winMutexInit() is indirectly called three
times:
1) in sqlite3MutexInit()
2) in
--- On Fri, 8/7/09, Dan Kennedy danielk1...@gmail.com wrote:
From: Dan Kennedy danielk1...@gmail.com
Subject: Re: [sqlite] Disk IO ERROR on AIX
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Friday, August 7, 2009, 8:26 AM
On Aug 4, 2009, at 5:07 AM, Kenneth Long
I'm looking to start a project using SQLite to handle some database
transactions. I have question about how SQLite handles Concurrency. I read
up on SQLite.org about the file locking and concurrency but I didn't really
get the info I wanted (at least I didn't walk away with an answer in the
If I have 2 separate processes, 1 of which will attempt to Read and Write a
Database (Process A)
and the 2nd which will only Read the database (Process B), then if Process A
is in the middle of a Write when Process B tries to read what will happen?
If Process A is in the middle of writing
On 7 Aug 2009, at 4:21am, aerende wrote:
sqlite .import myfile.csv mydatabasetable
sqlite .output mydatabasetable.sql
When you look at the .sql file in a text editor, does it make sense ?
Does it look like legal SQL ? Does it have all the INSERT commands in ?
I would probably try
On 7 Aug 2009, at 10:53am, liubin liu wrote:
I want to use a integer to save the ip address of ipv4. Because they
all are
4 bytes.
but it is better when the data type is unsigned int.
You may find it better just to store an IP number as a string, or as
four integers. Although it takes
Hello,
I have program that continuously runs several threads (about 4 to 10)
which concurrently read and write to an SQLite database. From
http://www.sqlite.org/sharedcache.html it seems to me that I should be
using shared cache mode.
Until now, I have set the busy timeout to 500 msec and never
Maybe you could benefit of using sqlite3_unlock_notify()? See more
info here: http://www.sqlite.org/c3ref/unlock_notify.html.
Pavel
On Fri, Aug 7, 2009 at 1:45 PM, Nikolaus Rathnikol...@rath.org wrote:
Hello,
I have program that continuously runs several threads (about 4 to 10)
which
On 8/08/2009 2:02 AM, Simon Slavin wrote:
On 7 Aug 2009, at 4:21am, aerende wrote:
sqlite .import myfile.csv mydatabasetable
sqlite .output mydatabasetable.sql
When you look at the .sql file in a text editor, does it make sense ?
Does it look like legal SQL ? Does it have all
Singaravelu, Rajaram schrieb:
Hi,
[...]
In short, can anyone tell me if I can compile sqlite3 with only ANSI
support so that it works like the ANSI version of fopen().
If I understand you correctly you just care about the filename when you
talk about UTF8?!
In this case everything
27 matches
Mail list logo