Sunday, October 18, 2009

GetDeb v2 Beta Available

GetDeb v2 Beta is a major milestone on the GetDeb project development, it addresses most of the technical limitations of the current system/engine that we have been using for the last 3 years.
The major improvements are:

* Software installation using a GPG signed APT repository with mirror distribution
* Single click installation even for multi-package installs
* Automatic software updates (from the repository)
* New design - for the first time not based on a Ubuntu offical site
* Web based applications publishing


These changes will increase our ability to provide more and better packages in a safely manner.
Most of the effort was invested at the APT-Portal project, which is shared with Playdeb and because is open source it can be used by by other teams to deploy their own repository based portals.

Both the design and code base -rewritten in python- still need a lot of work, if you have any skills with Python/HTML/CSS/AJAX please join the developers team.

http://beta.getdeb.net
http://wiki.getdeb.net/apt-portal

Tuesday, October 6, 2009

Importing APT repository info into a SQL DB

Hello,
in case you love repositories and databases there is a simple utility that allows you to export a remote APT repository metatada into a SQL database.
It was only tested with sqlite3 and MySQL, should work with any sqlalchemy supported DB .

First you need to get debfactory using bzr:
bzr checkout lp:debfactory

Now let's import the package info for Ubuntu Karmic (i386).
cd debfactory/bin
./apt2sql.py -d sqlite:///apt2sql.db \
http://archive.ubuntu.com/ubuntu/ karmic "*" i386

Check the packages count from the db:

sqlite3 apt2sql.db "SELECT COUNT(*) FROM package"