Bug 52321 – Sqlite cache backend for portage

• Product: Portage Development
• Status: RESOLVED WONTFIX

[Description Karol Wojtaszek (RETIRED) 2004-05-29 00:21:38 UTC]

Sqlite cache backend for portage:

Steps to install:
1. `emerge pysqlite`
2. copy modules to /etc/portage
3. copy portage_db_portage.py to /usr/lib/portage/pym
4. execute `init.sh`
5. `emerge regen`

[Comment 1 Karol Wojtaszek (RETIRED) 2004-05-29 00:22:27 UTC]

Created attachment 32234 [details]
initialize database

[Comment 2 Karol Wojtaszek (RETIRED) 2004-05-29 00:22:54 UTC]

Created attachment 32235 [details]
modules file

[Comment 3 Karol Wojtaszek (RETIRED) 2004-05-29 00:23:24 UTC]

Created attachment 32236 [details]
sql

[Comment 4 Karol Wojtaszek (RETIRED) 2004-05-29 00:23:45 UTC]

Created attachment 32237 [details]
portage-sqlite/portage_db_sqlite.py

[Comment 5 Karol Wojtaszek (RETIRED) 2004-05-31 15:09:52 UTC]

Comment on attachment 32234 [details]
initialize database

>#!/bin/bash
>
>cat portage-sqlite-init-db.sql | sqlite /var/cache/edb/sqlite-cache

[Comment 6 Karol Wojtaszek (RETIRED) 2004-05-31 15:11:36 UTC]

Comment on attachment 32234 [details]
initialize database

>#!/bin/bash
>
>cat portage-sqlite-init-db.sql | sqlite /var/cache/edb/sqlite-cache2
cat portage-sqlite-init-db.sql | sqlite /var/cache/edb/sqlite-cache

[Comment 7 Karol Wojtaszek (RETIRED) 2004-06-01 08:48:26 UTC]

Init.sh should create /var/cache/edb/sqlite-cache not sqlite-cache2 :)

[Comment 8 Nicholas Jones (RETIRED) 2004-06-05 17:18:13 UTC]

Requirements:
The module needs to be self-contained. It need to be able to create or
alter the tables itself without user intervention.

[Comment 9 Jason Stubbs (RETIRED) 2005-10-07 09:23:18 UTC]

Caching backend design will be changing in such a way that a backend will be 
queriable rather than just a glorified file system. Will integrate new backends 
at that time.