Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Kees Nuyt]

On Wed, 8 Dec 2010 06:35:06 -0500, Richard Hipp 
wrote:

>The version is still 3.7.4.  It is merely encoded as 3070400 in the
>filename, since names like 3070400, 3070403, 3070420, 3070500, 3071200
>sort into correct order when you do "ls", but the corresponding real
>version numbers 3.7.4, 3.7.4.1, 3.7.4.20, and 3.7.12 do not.

For anyone who needs it, here's a quick and dirty converter:

#!/usr/bin/ksh93
#
# convert numeric version into
# version.revision.release.dotrelease
#  vrrlldd -> v.r.l.d
#
# e.g. 3070400 -> 3.7.4.0
#  3071201 -> 3.7.12.1
#
# Written 2010 for fun by Kees Nuyt, NL
# No copyright, use as you wish 
#
## funcs
#
function convert {
if [ "$1" = "" ] ; then return; fi
p="$1"
v=${p:0:1}
r=${p:1:2}
l=${p:3:2}
d=${p:5:2}
# remove this demo output to stderr
printf "%s is %d.%d.%d.%d\n" "$p" "$v" "$r" "$l" "$d" >&2
# output "the unix way" to stdout
printf "%d.%d.%d.%d\n" "$v" "$r" "$l" "$d"
}
#
## MAIN
#
#  Two demos and the real thing
convert 3070400 # remove this demo
convert 3071201 # remove this demo
convert $1
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Richard Hipp]

On Tue, Dec 7, 2010 at 9:23 PM, Ladislav Bodnar  wrote:
> On Wednesday 08 December 2010, Richard Hipp wrote:
>> I changed to a more consistent naming scheme for all of the build
>> products:
>>
>>      sqlite-PRODUCT-OS-ARCH-VERSION.zip
>>
>> with the OS and ARCH being omitted for source-code products.  In your
>> case, you probably are looking for
>>
>>     http://www.sqlite.org/sqlite-amalgamation-3070400.zip
>
> So the version number is no longer "3.7.4", but "3070400"?

The version is still 3.7.4.  It is merely encoded as 3070400 in the
filename, since names like 3070400, 3070403, 3070420, 3070500, 3071200
sort into correct order when you do "ls", but the corresponding real
version numbers 3.7.4, 3.7.4.1, 3.7.4.20, and 3.7.12 do not.


> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Ladislav Bodnar]

On Wednesday 08 December 2010, Richard Hipp wrote:
> I changed to a more consistent naming scheme for all of the build
> products:
> 
>  sqlite-PRODUCT-OS-ARCH-VERSION.zip
> 
> with the OS and ARCH being omitted for source-code products.  In your
> case, you probably are looking for
> 
> http://www.sqlite.org/sqlite-amalgamation-3070400.zip

So the version number is no longer "3.7.4", but "3070400"?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Darren Duncan]

Roger Binns wrote:
> On 12/07/2010 08:45 PM, Darren Duncan wrote:
>> I am also working with automated scripts, which now have to be updated to 
>> use 
>> either the new style or old style depending on the user-requested SQLite 
>> version.  (DBD::SQLite bundles a SQLite version, and includes a script users 
>> can 
>> use to pull in a different, albeit typically newer, SQLite version to use 
>> with 
>> DBD::SQLite instead.)
> 
> And my python stuff does the same thing and is also now has to cope with
> different naming styles.  It also broke the other python SQLite wrapper.
> 
> It would have been nice if there had been a least little forewarning and
> consultation.

For my part, I have already committed an update to the DBD::SQLite script so 
that it now works with the old and new SQLite dist versions.

Moreover, the script now lets users specify a SQLite version in either the old 
or new format for any version, and will normalize as appropriate, so the users 
at least don't even have to know that there was a change.

If anyone else can benefit from my solution to speed their own similar updates, 
see 
https://fisheye2.atlassian.com/browse/cpan/trunk/DBD-SQLite/util/getsqlite.pl#r13338
 
and click on "raw".

I expect it will receive third-party testing before being released though it 
works for me.

That said, I will like to know soon if any further changes will be made, before 
this DBD::SQLite update is pushed to CPAN and users try self-updating with it.

-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 12/07/2010 08:45 PM, Darren Duncan wrote:
> I am also working with automated scripts, which now have to be updated to use 
> either the new style or old style depending on the user-requested SQLite 
> version.  (DBD::SQLite bundles a SQLite version, and includes a script users 
> can 
> use to pull in a different, albeit typically newer, SQLite version to use 
> with 
> DBD::SQLite instead.)

And my python stuff does the same thing and is also now has to cope with
different naming styles.  It also broke the other python SQLite wrapper.

It would have been nice if there had been a least little forewarning and
consultation.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkz/EuUACgkQmOOfHg372QSQ6wCgh2UNn2KQk5FWLXw62aEnBMiF
jA0An3wbKeP1y7FUQOf0AdDlUgD95ARM
=1FeE
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Darren Duncan]

Richard Hipp wrote:
> I changed to a more consistent naming scheme for all of the build products:
> 
>  sqlite-PRODUCT-OS-ARCH-VERSION.zip
> 
> with the OS and ARCH being omitted for source-code products.  In your
> case, you probably are looking for
> 
> http://www.sqlite.org/sqlite-amalgamation-3070400.zip
> 
> which is the very first build product at the top of the page at
> 
> http://www.sqlite.org/download.html
> 
> Or maybe you want
> 
> http://www.sqlite.org/sqlite-autoconf-3070400.tar.gz
> 
> which is the second build product from the top.  The -amalgamation-
> product is just the sqlite3.c source file and a few others.  The
> -autoconf- product contains sqlite3.c together with a configure
> script, ready to build on your unix-like machine.

I am also working with automated scripts, which now have to be updated to use 
either the new style or old style depending on the user-requested SQLite 
version.  (DBD::SQLite bundles a SQLite version, and includes a script users 
can 
use to pull in a different, albeit typically newer, SQLite version to use with 
DBD::SQLite instead.)

With respect to the two files:

   sqlite-amalgamation-3070400.zip

   sqlite-autoconf-3070400.tar.gz

A few questions:

1.  Why does the file "sqlite3ext.h" differ between the 2 of them?  The one in 
-amalgamation had added some declarations from 
sqlite-amalgamation-3.7.3.tar.gz, 
but the one in -autoconf is the same as for 3.7.3; I would expect -autoconf to 
be a proper superset.

2.  Why does -amalgamation unzip to the folder name 
"sqlite-amalgamation-3070400" but -autoconf untars to the folder name 
"sqlite-3.7.4"?  Why the inconsistent use of version formats?

-- Darren Duncan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Ladislav Bodnar]

On Wednesday 08 December 2010, Richard Hipp wrote:
> I changed to a more consistent naming scheme for all of the build
> products:
> 
>  sqlite-PRODUCT-OS-ARCH-VERSION.zip
> 
> with the OS and ARCH being omitted for source-code products.  In your
> case, you probably are looking for
> 
> http://www.sqlite.org/sqlite-amalgamation-3070400.zip

So the version number is no longer "3.7.4", but "3070400"?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Rich Shepard]

On Tue, 7 Dec 2010, Richard Hipp wrote:

> I changed to a more consistent naming scheme for all of the build products:
>
> sqlite-PRODUCT-OS-ARCH-VERSION.zip
>
> with the OS and ARCH being omitted for source-code products.  In your
> case, you probably are looking for

Richard,

   That's how it's been for a while.

>http://www.sqlite.org/sqlite-amalgamation-3070400.zip

   I will change the script so it unzips rather than untars, and it looks for
zeros rather than periods in the version number.

Thanks,

Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite-3.7.4 Amalgamation?

[Richard Hipp]

On Tue, Dec 7, 2010 at 8:17 PM, Rich Shepard  wrote:
>   What happened to the souce tarball of the amalgamation? I'm wondering if
> the change to the autoconf version will break the Slackbuild script I use.
>
>   Was there something wrong with the tarballs of previous versions?

I changed to a more consistent naming scheme for all of the build products:

 sqlite-PRODUCT-OS-ARCH-VERSION.zip

with the OS and ARCH being omitted for source-code products.  In your
case, you probably are looking for

http://www.sqlite.org/sqlite-amalgamation-3070400.zip

which is the very first build product at the top of the page at

http://www.sqlite.org/download.html

Or maybe you want

http://www.sqlite.org/sqlite-autoconf-3070400.tar.gz

which is the second build product from the top.  The -amalgamation-
product is just the sqlite3.c source file and a few others.  The
-autoconf- product contains sqlite3.c together with a configure
script, ready to build on your unix-like machine.

>
> Rich
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite-3.7.4 Amalgamation?

[Rich Shepard]

   What happened to the souce tarball of the amalgamation? I'm wondering if
the change to the autoconf version will break the Slackbuild script I use.

   Was there something wrong with the tarballs of previous versions?

Rich
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users