You probably want to either use sqlite3_bind_int64 to bind the 32-bit
IPv4 address as a positive 32-bit number (this will take between 1 and
5 bytes of space in the variable length integer format), or use
sqlite3_bind_blob and force storing the IP address as a fixed 4 byte
blob (in this case, you'd
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
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 h
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 Rath wrote:
> Hello,
>
> I have program that continuously runs several threads (about 4 to 10)
> which concurrently read an
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 h
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 t
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 tr
> 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
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
term
--- On Fri, 8/7/09, Dan Kennedy wrote:
> From: Dan Kennedy
> Subject: Re: [sqlite] Disk IO ERROR on AIX
> To: "General Discussion of SQLite Database"
> Date: Friday, August 7, 2009, 8:26 AM
>
> On Aug 4, 2009, at 5:07 AM, Kenneth Long wrote:
>
> >
> > Hi,
> >
> > I'm getting a Disk I/O erro
> 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 sqlite3Pcach
> 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
assured
>
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 sqli
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 generall
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 con
> 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 stri
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 happenin
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
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 typ
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 liu<7101...@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
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 int
On Wed, Aug 5, 2009 at 8:20 PM, Jean-Denis Muys 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 associated with h
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
__
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 h
On Aug 5, 2009, at 8:32 PM, Hamish Allan wrote:
> On Wed, Aug 5, 2009 at 5:50 PM, Jean-Denis
> Muys 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 you google
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; i<4; i++, m*=0x100 )
1337 gateaddr = gatead
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 conditi
27 matches
Mail list logo