[ITA] sqlite3

[ITA] sqlite3

[Jan Nijtmans]

I would like to adopt sqlite3. I've packaged the latest release.

setup.hint
----------------------------------------------------------------------
category: Database
requires: libreadline7 libgcc1
sdesc: "Client program for accessing SQLite 3 databases, plus docs"
ldesc: "SQLite is a C library that implements an embeddable SQL database
engine.  Programs that link with the SQLite library can have SQL
database access without running a separate RDBMS process. The
distribution comes with a standalone command-line access program
(sqlite3) that can be used to administer an SQLite database and which
serves as an example of how to use the SQLite library."


download:
----------------------------------------------------------------------
D=http://dl.dropboxusercontent.com/u/69449580/Cygwin64
wget -x -nH --cut-dirs=3 \
 ${D}/sqlite3/setup.hint \
 ${D}/sqlite3/sqlite3-3.8.1-1.tar.xz \
 ${D}/sqlite3/sqlite3-3.8.1-1-src.tar.xz \
 ${D}/sqlite3/libsqlite3_0/setup.hint \
 ${D}/sqlite3/libsqlite3_0/libsqlite3_0-3.8.1-1.tar.xz \
 ${D}/sqlite3/libsqlite3-devel/setup.hint \
 ${D}/sqlite3/libsqlite3-devel/libsqlite3-devel-3.8.1-1.tar.xz \
 ${D}/sqlite3/sqlite3-debuginfo/setup.hint \
 ${D}/sqlite3/sqlite3-debuginfo/sqlite3-debuginfo-3.8.1-1.tar.xz


D=http://dl.dropboxusercontent.com/u/69449580/Cygwin
wget -x -nH --cut-dirs=3 \
 ${D}/sqlite3/setup.hint \
 ${D}/sqlite3/sqlite3-3.8.1-1.tar.xz \
 ${D}/sqlite3/sqlite3-3.8.1-1-src.tar.xz \
 ${D}/sqlite3/libsqlite3_0/setup.hint \
 ${D}/sqlite3/libsqlite3_0/libsqlite3_0-3.8.1-1.tar.xz \
 ${D}/sqlite3/libsqlite3-devel/setup.hint \
 ${D}/sqlite3/libsqlite3-devel/libsqlite3-devel-3.8.1-1.tar.xz \
 ${D}/sqlite3/sqlite3-debuginfo/setup.hint \
 ${D}/sqlite3/sqlite3-debuginfo/sqlite3-debuginfo-3.8.1-1.tar.xz

-- 
Jan Nijtmans  ----  jan.nijtmans@gmail.com

Re: [ITA] sqlite3

[Christopher Faylor]

On Wed, Nov 13, 2013 at 04:03:40PM +0100, Jan Nijtmans wrote:
>I would like to adopt sqlite3. I've packaged the latest release.

I don't think the package is in need of adoption.  Warren Young is still
around and active, AFAICT.

cgf

Re: [ITA] sqlite3

[Jan Nijtmans]

2013/11/13 Christopher Faylor:
> On Wed, Nov 13, 2013 at 04:03:40PM +0100, Jan Nijtmans wrote:
>>I would like to adopt sqlite3. I've packaged the latest release.
>
> I don't think the package is in need of adoption.  Warren Young is still
> around and active, AFAICT.
>
> cgf

Yes, he is! I'm waiting for his endorsement mail, because
actually he is the one who proposed this adoption to me.
I will do my best to be a good package maintainer for
sqlite, but I hope you can forgive any beginners
mistakes I might make. With your help I think
everything will be OK.

Regards,
         Jan Nijtmans

Re: [ITA] sqlite3

[Warren Young]

On 11/13/2013 08:18, Christopher Faylor wrote:
> On Wed, Nov 13, 2013 at 04:03:40PM +0100, Jan Nijtmans wrote:
>> I would like to adopt sqlite3. I've packaged the latest release.
>
> I don't think the package is in need of adoption.  Warren Young is still
> around and active, AFAICT.

Jan has been the driving force behind fixing the problems that prevented 
a simple update from SQLite 3.7.x to 3.8 on Cygwin.  (3.8 is a big 
upstream release, and they broke a lot of things on Cygwin, since it 
isn't a primary deployment platform for them.)

The only reason I adopted this package in the first place is that the 
previous maintainer disappeared, and it was about to be removed from the 
distribution.  I just stepped in to rescue it.  I have never actually 
*used* SQLite on Cygwin, other than testing; Cygwin SQLite has never 
been my "itch."

I expect Jan to be a better SQLite package adoptive parent than I was.

Via private email and on the SQLite list, I've been explaining the whys 
and wherefores of the current Cygwin SQLite package to Jan and others. 
I don't intend to disappear entirely from the SQLite world, but I think 
most of the knowledge transfer has already happened.

Re: [ITA] sqlite3

[Corinna Vinschen]

[-- Attachment #1: Type: text/plain, Size: 1721 bytes --]

On Nov 13 16:05, Warren Young wrote:
> On 11/13/2013 08:18, Christopher Faylor wrote:
> >On Wed, Nov 13, 2013 at 04:03:40PM +0100, Jan Nijtmans wrote:
> >>I would like to adopt sqlite3. I've packaged the latest release.
> >
> >I don't think the package is in need of adoption.  Warren Young is still
> >around and active, AFAICT.
> 
> Jan has been the driving force behind fixing the problems that
> prevented a simple update from SQLite 3.7.x to 3.8 on Cygwin.  (3.8
> is a big upstream release, and they broke a lot of things on Cygwin,
> since it isn't a primary deployment platform for them.)
> 
> The only reason I adopted this package in the first place is that
> the previous maintainer disappeared, and it was about to be removed
> from the distribution.  I just stepped in to rescue it.  I have
> never actually *used* SQLite on Cygwin, other than testing; Cygwin
> SQLite has never been my "itch."
> 
> I expect Jan to be a better SQLite package adoptive parent than I was.
> 
> Via private email and on the SQLite list, I've been explaining the
> whys and wherefores of the current Cygwin SQLite package to Jan and
> others. I don't intend to disappear entirely from the SQLite world,
> but I think most of the knowledge transfer has already happened.

Ok, thanks for clarifying, Warren.

Jan, please see https://sourceware.org/cygwin-apps/package-upload.html
for how to request upload privileges and how to upload, once you got
your GTG for the package, which AFAICS, Warren would be the right guy to
do.


Thanks,
Corinna

-- 
Corinna Vinschen                  Please, send mails regarding Cygwin to
Cygwin Maintainer                 cygwin AT cygwin DOT com
Red Hat

[-- Attachment #2: Type: application/pgp-signature, Size: 836 bytes --]

Re: [ITA] sqlite3

[Christopher Faylor]

On Thu, Nov 14, 2013 at 10:47:51AM +0100, Corinna Vinschen wrote:
>Jan, please see https://sourceware.org/cygwin-apps/package-upload.html
>for how to request upload privileges and how to upload, once you got
>your GTG for the package, which AFAICS, Warren would be the right guy to
>do.

Jan has an upload directory on cygwin.com now.

Jan, if you can send the information at the above link now, you'll be
GTG for uploading as soon as the package has been pronounced GTG by
Warrent.

cgf

Re: [ITA] sqlite3

[Christopher Faylor]

On Thu, Nov 14, 2013 at 02:27:51PM -0500, Christopher Faylor wrote:
>On Thu, Nov 14, 2013 at 10:47:51AM +0100, Corinna Vinschen wrote:
>>Jan, please see https://sourceware.org/cygwin-apps/package-upload.html
>>for how to request upload privileges and how to upload, once you got
>>your GTG for the package, which AFAICS, Warren would be the right guy to
>>do.
>
>Jan has an upload directory on cygwin.com now.
>
>Jan, if you can send the information at the above link now, you'll be
>GTG for uploading as soon as the package has been pronounced GTG by
>Warrent.

i.e., "Warren"

cgf

Re: [ITA] sqlite3

[Warren Young]

On 11/14/2013 12:27, Christopher Faylor wrote:
>
> Jan, if you can send the information at the above link now, you'll be
> GTG for uploading as soon as the package has been pronounced GTG by
> Warrent.

Jan sent me a link to his proposed packages, which I looked at briefly, 
but they've disappeared.  What I saw of the tarball contents looked 
good, but I didn't actually install and exercise packages here.

Jan, will you please put the package tarballs you intend to upload on a 
public file server somewhere?  You can send the link directly to me, or 
post it in reply to this thread.  I'll want to test both 32- and 64-bit 
versions.

Don't worry about the tclsqlite package at this point.  There's no 
reason that should hold up the main packages.

Re: [ITA] sqlite3

[Warren Young]

On 11/15/2013 06:38, Warren Young wrote:
> On 11/14/2013 12:27, Christopher Faylor wrote:
>>
>> Jan, if you can send the information at the above link now, you'll be
>> GTG for uploading as soon as the package has been pronounced GTG by
>> Warrent.

GTG.

I tested by unpacking the 3 main packages (exe, lib, and -devel), 
examining the file list, running the exe, and running svn to make sure 
it loaded the DLL correctly.  I had to rebase on 32-bit, but that's 
probably not surprising since I did a manual install.

Jan, some nits to take care of in the next sqlite3.README file:

- It still mentions lemon3.exe.

- I wasn't the maintainer of all prior versions of Cygwin SQLite.  I 
started with 3.5.8.  I don't remember who the prior maintainer of the 
official Cygwin SQLite package was.  From the port notes, I started from 
Yaakov's Cygwin Ports version, but it was someone else's package I was 
replacing in the official distro.

- Typo: "idential" -> "identical"

Also, when you post your cygwin-announce message, be sure to describe 
the new VFS switching mechanism.  One of the READMEs should describe 
this Cygwin-specific environment variable in some detail, too.