Re: [sqlite] SQLite Site

2017-09-02 Thread Stephen Chrzanowski
Could be just something with this machine, or as Igor mentioned, firewall issue. My home machine pokes the sqlite3 site once a day and downloads any new packages placed, so, I had a work around. :] On Sat, Sep 2, 2017 at 12:07 PM, Igor Korot wrote: > Hi, > Are you behind firewall? > > Thank you

[sqlite] [Announcement] Mix and match Objective-C and Swift for SQLite access

2017-09-02 Thread Gwendal Roué
Hello SQLite community, I want to announce the first release of GRDBObjc, a library that allows iOS, macOS, and watchOS apps to use SQLite from both Objective-C and Swift. Both languages share the same database connections, with all the multi-threading safety expected by reasonable developers.

Re: [sqlite] SQLite Site

2017-09-02 Thread Igor Korot
Hi, Are you behind firewall? Thank you. On Sep 2, 2017 8:12 AM, "Stephen Chrzanowski" wrote: > I'm sitting on a new computer at work, and was trying to get the 3.20.1 > DLL, but, the browser is just spinning its wheels. > > I'm going to see what my Drobo has at home, and just use that, but just

Re: [sqlite] SQLite Site

2017-09-02 Thread Richard Hipp
Download took about 1 sec for me on my phone. On Saturday, September 2, 2017, Stephen Chrzanowski wrote: > I'm sitting on a new computer at work, and was trying to get the 3.20.1 > DLL, but, the browser is just spinning its wheels. > > I'm going to see what my Drobo has at home, and just use that

Re: [sqlite] Restore SQLite DB from WAL

2017-09-02 Thread Simon Slavin
On 1 Sep 2017, at 1:23pm, LincolnBurrows wrote: > Sometimes, the corruption is only or mostly in indexes, in which case it > would be possible to get some or most records by trying to dump the entire > database with .dump, and use those commands to create a new database: > > $ sqlite3 mydata.d

Re: [sqlite] Amalgamation compilation with SQLITE_THREADSAFE=0

2017-09-02 Thread Simon Slavin
On 2 Sep 2017, at 10:55am, Jacky Lam wrote: > Thanks for the answer. I have a clear picture now.I would also like to know > for Android SQLite case;does the default value for auto vacuum is OFF.Is it > the same default compiling config with sqlite.c source code?In other words, > does it need

[sqlite] SQLite Site

2017-09-02 Thread Stephen Chrzanowski
I'm sitting on a new computer at work, and was trying to get the 3.20.1 DLL, but, the browser is just spinning its wheels. I'm going to see what my Drobo has at home, and just use that, but just wanted to bring it to someones attention that somethings not working right. Heck, could even be this c

Re: [sqlite] SQLITE bug

2017-09-02 Thread Richard Hipp
On 8/31/17, Noah Simon wrote: > Hello, > While using the sqlite3 SQL shell from macOS Sierra Terminal, a bug (I > think) occurred. > > Version number: > sqlite> .version > SQLite 3.13.0 2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2 > > What happened was I created a table with an aut

Re: [sqlite] Restore SQLite DB from WAL

2017-09-02 Thread LincolnBurrows
Sometimes, the corruption is only or mostly in indexes, in which case it would be possible to get some or most records by trying to dump the entire database with .dump, and use those commands to create a new database: $ sqlite3 mydata.db ".dump" | sqlite3 new.db The easiest and most reliable way

[sqlite] SQLITE bug

2017-09-02 Thread Noah Simon
Hello, While using the sqlite3 SQL shell from macOS Sierra Terminal, a bug (I think) occurred. Version number: sqlite> .version SQLite 3.13.0 2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2 What happened was I created a table with an autoincremented primary key. After creating a ro

Re: [sqlite] Amalgamation compilation with SQLITE_THREADSAFE=0

2017-09-02 Thread Jacky Lam
Thanks for the answer. I have a clear picture now.I would also like to know for Android SQLite case;does the default value for auto vacuum is OFF.Is it the same default compiling config with sqlite.c source code?In other words, does it need to do vacuum manually? 從我的 Samsung Galaxy 智能手機發送。 ---