Re: [sqlite] WAL for single user database on nfs

Great thanks for the info. Richard. Pete From: Richard Hipp To: General Discussion of SQLite Database Sent: Wed, November 24, 2010 3:11:57 PM Subject: Re: [sqlite] WAL for single user database on nfs On Wed, Nov 24,

Re: [sqlite] Some floats of 15 digits or less do not round-trip

In Visual C, a "long double" and a "double" are the same, and only offer 53 bits of precision. On GCC, a "long double" has 80 bits of precision. Unfortunately, I don't think there's a way to have Visual C use more precision. Because of this, round off error will always differ between the two

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Mon, Nov 29, 2010 at 3:04 PM, Rick Regan wrote: > So the question remains -- why does the Windows build get it wrong? > I think I figured it out. It is due to the use of extended precision. In sqlite3.c, if you change "#define LONGDOUBLE_TYPE long double" to

Re: [sqlite] Just compiled SQLite in Visual Studio

john darnell wrote: > I just added it to a Visual Studio 8 project, turned off the use of > precompiled headers (the project is a C++ project) and > compiled the SQLite.c file without any errors. There is no such thing as a C++ project. A project in Visual Studio can

Re: [sqlite] Just compiled SQLite in Visual Studio

john darnell wrote: > Thanks, Simon. I'll take your advice. > > Oh and BTW, I apologize for the "Mac truck" remark--I meant no offense to my > friends who code for the Mac (grin). My Mac is Peterbilt. > R, > John > >> -Original Message- >> From: sqlite-users-boun...@sqlite.org >>

Re: [sqlite] Just compiled SQLite in Visual Studio

Thanks, Simon. I'll take your advice. Oh and BTW, I apologize for the "Mac truck" remark--I meant no offense to my friends who code for the Mac (grin). R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Simon

Re: [sqlite] Just compiled SQLite in Visual Studio

On 29 Nov 2010, at 11:10pm, john darnell wrote: > here's that first dumb-sounding question. > > I got my boss to purchase an O'Reilly book called Using SQLite, and the > author makes a rather ominous statement: "All of the SQLite source is > written in C...Make sure you use a vanilla C

[sqlite] Just compiled SQLite in Visual Studio

Hello Folks: I just started a big project that needed an internal database manager and SQLite looks like it will fit the bill. I am old hat with SQL but have absolutely no experience with SQLite, so here's hoping that you folks are a real friendly bunch and will help me get up to speed.

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Sun, Nov 28, 2010 at 8:55 AM, Black, Michael (IS) wrote: > > I find it interesting though that the math is different between the two > compilers...I wonder which is actually "correct" ?? > > > I ran a GMP version of the section of code we've highlighted, converting

Re: [sqlite] [ADV] 60% off "Using SQLite" and other O'Reilly ebooks

On Mon, Nov 29, 2010 at 10:41:25AM -0700, Gerry Snyder scratched on the wall: > I bought this book on opening day and now can highly recommend it. I'm glad you're finding it useful. > It is a very useful supplement to the online docs. The info is pretty > up-to-date, but SQLite keeps advancing

Re: [sqlite] searching with like on FTS3

The problem is that is is that i don't want the ICU tokenizer to split single words entrys and shorter figure of speaches, and for those the search is atm very good (and it has to be exact in 99% because i limit the results to 1). I modded the simple tokenizer to filter more stuff like [ ]

Re: [sqlite] [ADV] 60% off "Using SQLite" and other O'Reilly ebooks

I bought this book on opening day and now can highly recommend it. It is a very useful supplement to the online docs. The info is pretty up-to-date, but SQLite keeps advancing so the most recent enhancements perforce are missing. For example, wal mode is not covered, but there is a good

Re: [sqlite] searching with like on FTS3

On 11/30/2010 12:09 AM, boscowitch wrote: > Hi recently I noticed that i can't search with the like '%searchword%' > syntax on an FTS3 virtual table. > > And with "match" i can't search on example sentences (the indexed data > is a japanese dictionary an therefore has no spaces in example

[sqlite] searching with like on FTS3

Hi recently I noticed that i can't search with the like '%searchword%' syntax on an FTS3 virtual table. And with "match" i can't search on example sentences (the indexed data is a japanese dictionary an therefore has no spaces in example sentences and there is no perfekt tokenizer atm i tried

Re: [sqlite] SQLITE 3.7.3 bug report (shell) - output in column?mode does not align UTF8-strings correctly

On Fri, Nov 26, 2010 at 06:52:56AM +, Niklas Bäckman wrote: > Igor Tandetnik writes: > > Note that counting codepoints, while it happens to help with your > > particular data, won't help in general. Consider combining > > diacritics: U+00E4 (small A with diaeresis) looks the

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Mon, Nov 29, 2010 at 10:08 AM, Doug Currie wrote: > > The Grisu2 strings do "round trip" correctly, which I think is where this > thread started. > > Grisu addresses the "floating-point to decimal to floating-point" round-trip. The bug I found (it will become a bug

Re: [sqlite] WAL file size

> Well, I love sqlite, and I want to continue using it (small, fast, > reliable ...). > I think it is better to solve such problems inside sqlite It's impossible. Just try to design the solution you want. Think of how SQLite should behave to make you happy, think of it with all details and don't

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Nov 29, 2010, at 9:37 AM, Rick Regan wrote: > "For IEEE 754 double-precision numbers and 64-bit integers roughly > 99.4% of all numbers can be processed efficiently. The remaining 0.6% are > rejected and need to be printed by a slower complete algorithm." > > Hmmm. What's involved in the

[sqlite] [ADV] 60% off "Using SQLite" and other O'Reilly ebooks

O'Reilly Media is running a one-day sale, Monday, 29 Nov, only. *All* ebooks and videos are 60% off, including "Using SQLite" and over 2000 other titles. Just use the discount code DDF2H when placing your order. With this discount, the ebook version of "Using SQLite" is only $12.80

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Sun, Nov 28, 2010 at 8:09 PM, Doug Currie wrote: > The paper compares the performance of sprintf from glibc 2.11 and Grisu. I > don't know if glibc sprintf is based on Gay's code; at one point I thought > it was, but I cannot find an authoritative reference. > > In any

Re: [sqlite] how to search '%' in a string

done ! 3ks to davies. At 2010-11-29 18:31:21，"Simon Davies" wrote: >2010/11/29 黄小刚 : >> anybody tell me how to search '%' in a string？ 3q:) > >http://www.sqlite.org/lang_expr.html#like > >Regards, >Simon

Re: [sqlite] how to search '%' in a string

2010/11/29 黄小刚 : > anybody tell me how to search '%' in a string？ 3q:) http://www.sqlite.org/lang_expr.html#like Regards, Simon ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to search '%' in a string

anybody tell me how to search '%' in a string？ 3q:) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users