On 3 May 2015, at 19:26, Eric Sink wrote:
> Last time I asked myself this question, I ended up in the same place you
> did: zlib, libpng and libjpeg may be the only candidates in the same
> ballpark as SQLite.
Likely libxml2 as well. Seems to get embedded by just about everything.
Some of the
On 25 Apr 2015, at 20:41, Jeff M wrote:
>> On Apr 24, 2015, at 2:44 AM, Simon Slavin wrote:
>>
>> On 24 Apr 2015, at 6:59am, Jeff M wrote:
>>
>>> I don't need to map SQLite to iCloud -- I only need to map SQLite to Core
>>> Data. Core Data then takes care of the iCloud issues.
>>
>> I
Hello,
> what is the difference between major and minor?
To quote from the pull request [1]:
The idea is major are kind of "A" league and minor "B" league. For
something more concrete - the tool is "A" league if it is open source
(and works ;-)). Another is how popular (hard to say). Not sure
> > There is no difference between a file opened over the network and one
> opened locally, except that in the network open case the network
> filesystem does not maintain consistency between the client view of the
> file and the server view of that same file, because doing so takes time
> and
Hi,
After running the following script in sqlite 3.8.7.1:
set dbfile {c:/temp/db.sqlite3}
file delete -force $dbfile
sqlite3 ::db $dbfile
::db eval {
PRAGMA journal_mode = WAL;
create table test2 (id, txt)
}
for {set i 0} {$i < 1} {incr i} {
set t txt$i
::db eval {insert into test2
Hello Peter,
I use UTF-8 exclusively in the engine parts my windows applications. I
just translate to UTF-16 for the GUI layer. In that way, no matter
what platform I support, the DB's remain the same.
C
Tuesday, May 5, 2015, 3:29:54 PM, you wrote:
PH> Thanks for all the replies. I'm still
On 5 May 2015, at 1:57pm, Keith Medcalf wrote:
> There is no difference between a file opened over the network and one opened
> locally, except that in the network open case the network filesystem does not
> maintain consistency between the client view of the file and the server view
> of
Under SQLite Admin Tools what is the difference between major and minor?
--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org
No... Skype doesn't come with ALL versions of Win 7 or later. I've
purchased three copies of 8.1 since Dec and none of them come with Skype.
Two Notebooks with the OS installed as well as an OEM I've downloaded from
MSoft.
I'm not saying that MSoft doesn't have an application or two that uses
On 5 May 2015, at 11:44am, James K. Lowden wrote:
> Simon Slavin wrote:
>
>> In contrast to NFS both SMB and AFP are designed to support networks
>> properly, with caches only on the computer which hosts the file and
>> locking correctly implemented.
>
> Are you saying that SMB clients
On 5-5-2015 12:40, Luuk wrote:
>
> now it becomes time that windows will do some things with UTF-8
> (sigh) ;-)
>
> /me currently watching
> "Your PC will restart serveral times. Sit back and relax"
> while installing updates for technical preview to Windows 10
>
>
C:\temp>sqlite3.exe
On 5/5/15, Zaumseil Ren? wrote:
>
> Is there a way to shrink the file when it is still open in WAL mode?
>
Run "PRAGMA wal_checkpoint=TRUNCATE;" in SQLite 3.8.8.2 or later.
--
D. Richard Hipp
drh at sqlite.org
Hello,
> It seems to me that it would be useful to include them, flagged as
> "commercial only".
Due to popular demand I started a "commercial only" awesome sqlite
list [1]. For now entries are free (as in beer) ;-) Cheers.
[1]
On 5-5-2015 12:25, Clemens Ladisch wrote:
> Staffan Tylen wrote:
>> I must admit that I'm a bit confused here. If I'm not wrong UTF-8 differs
>> from ascii when the value is higher than '7f'x, but storing data in sqlite
>> as text with character values beteen 'x80'x and 'ff'x seems to be no
>>
On 5-5-2015 11:25, Kees Nuyt wrote:
> On Tue, 05 May 2015 10:50:00 +0200, Clemens Ladisch
> wrote:
>
>> Luuk wrote:
>>> on Windows 7:
>>> C:\temp>sqlite3.exe encoding.sqlite
>>> sqlite> select * from test;
>>> ??n
>>
>> The Windows console does not support UTF-8 with the default settings and
>>
Thanks for all the replies. I'm still confused on this. It sounds like
maybe UTF8 is the answer on OSX but UTF-16LE on Windows.
Whatever the answer to that, it seems there isn't a way to control the
encoding within sqlite3 so I guess I won't worry about it.
Pete
lcSQL Software
Staffan Tylen wrote:
> I must admit that I'm a bit confused here. If I'm not wrong UTF-8 differs
> from ascii when the value is higher than '7f'x, but storing data in sqlite
> as text with character values beteen 'x80'x and 'ff'x seems to be no
> problem. I previously thought that this could only
>
>
>>> I think it assumes UTF8 in both cases.
>>>
>>
>> when using '.dump', it does not create a UTF8 file on Windows 7 (sQlite
>> version 3.8.8.3)
>>
>
> It's UTF16-LE data.
>
>
>
I must admit that I'm a bit confused here. If I'm not wrong UTF-8 differs
from ascii when the value is higher than
At https://www.sqlite.org/mmap.html, the documentation mentions:
"An I/O error on a memory-mapped file cannot be caught and dealt with by
SQLite. Instead, the I/O error causes a signal which, if not caught by the
application, results in a program crash."
It seems to me that a naively implemented
On Tue, 05 May 2015 10:50:00 +0200, Clemens Ladisch
wrote:
>Luuk wrote:
>> on Windows 7:
>> C:\temp>sqlite3.exe encoding.sqlite
>> sqlite> select * from test;
>> ??n
>
>The Windows console does not support UTF-8 with the default settings and
>the C stdio functions. Any data you entered in the
Luuk wrote:
> on Windows 7:
> C:\temp>sqlite3.exe encoding.sqlite
> sqlite> select * from test;
> ??n
The Windows console does not support UTF-8 with the default settings and
the C stdio functions. Any data you entered in the console is not
encoded correctly.
Regards,
Clemens
At 09:22 05/05/2015, you wrote:
>On 4-5-2015 20:54, Richard Hipp wrote:
>>On 5/4/15, Peter Haworth wrote:
>>>When using the .dump command with .output to a filename, what
>>>encoding does
>>>sqlite3 for the file? Same as the database encoding? Is it possible to
>>>change whatever encoding
On 5-5-2015 09:22, Luuk wrote:
> On 4-5-2015 20:54, Richard Hipp wrote:
>> On 5/4/15, Peter Haworth wrote:
>>> When using the .dump command with .output to a filename, what
>>> encoding does
>>> sqlite3 for the file? Same as the database encoding? Is it possible to
>>> change whatever encoding
On Mon, 04 May 2015 17:15:17 +0100,
Gerald Bauer wrote:
>
> Note: For now commercial only tools (e.g. SQLite Analyzer) will NOT
> get include - sorry. If you want to get it included, buy a sponsored
> link or a beer for everyone on the mailing list! Just kidding ;-)
It seems to me that it
On 4-5-2015 20:54, Richard Hipp wrote:
> On 5/4/15, Peter Haworth wrote:
>> When using the .dump command with .output to a filename, what encoding does
>> sqlite3 for the file? Same as the database encoding? Is it possible to
>> change whatever encoding is used?
>>
>> Similarly, when using the
Hello,
As posted before I've started an awesome collection about all things
SQLite [1].
One section collections ready-to-use (instant) SQLite schemas (and
sample data) scripts. So far listed are:
- football.db - teams, competitions, seasons, matches, goals,
rounds, groups, etc.
-
> SMB keeps its cache on the computer which hosts the file. So if a file is
> opened locally the cache is on the only computer concerned. If computer A
> opens a file on computer B, the file-system cache is on computer B, where
> all file requests pass through it.
>
> Of course a badly written
On Mon, 4 May 2015 02:05:54 +0100
Simon Slavin wrote:
> On 4 May 2015, at 1:30am, James K. Lowden
> wrote:
>
> > That is the way most remote filesystems are designed and implemented
> > and documented. Cf. http://www.ietf.org/rfc/rfc1813.txt:
> >
> > 4.11 Caching policies
> >
> > The
On 2015-05-03 08:18 PM, Richard Hipp wrote:
> SQLite is not in default Windows installations (historically - that is
> about to change with Windows 10 which uses SQLite as a core OS
> component) but many Windows desktops will include secondary software
> such as Firefox or Chrome or iTunes or
29 matches
Mail list logo