R: Does anyone know of a job scheduler that uses PostgreSQL?

People,

It would be nice to be able to use PostgreSQL as the storage for Firefox
Bookmarks - anyone know if this would be possible? how it could be done?

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW 2001
Australia
E-mail: phil@pricom.com.au

Philip Rhoades wrote:

People,

It would be nice to be able to use PostgreSQL as the storage for Firefox
Bookmarks - anyone know if this would be possible? how it could be done?

Not sure about doing it with PostgreSQL but there is the Firefox Weave
Service which might do what I think you're after. Probably over-kill
though.

http://labs.mozilla.com/projects/weave/

\\||/
Rod
--

On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote:

It would be nice to be able to use PostgreSQL as the storage for
Firefox Bookmarks - anyone know if this would be possible? how it
could be done?

Uh, I think it would consume more system resources.

--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

Devrim,

On 2009-08-14 00:55, Devrim G�ND�Z wrote:

On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote:

It would be nice to be able to use PostgreSQL as the storage for
Firefox Bookmarks - anyone know if this would be possible? how it
could be done?

Uh, I think it would consume more system resources.

Why do you say that? I am running PostgreSQL for other things anyway an
occasional call from FF should not be a big deal?

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW 2001
Australia
E-mail: phil@pricom.com.au

On Fri, 2009-08-14 at 02:36 +1000, Philip Rhoades wrote:

Devrim,

On 2009-08-14 00:55, Devrim GÜNDÜZ wrote:

On Fri, 2009-08-14 at 00:20 +1000, Philip Rhoades wrote:

It would be nice to be able to use PostgreSQL as the storage for
Firefox Bookmarks - anyone know if this would be possible? how it
could be done?

Uh, I think it would consume more system resources.

Why do you say that? I am running PostgreSQL for other things anyway an
occasional call from FF should not be a big deal?

If you are using PostgreSQL for your general usage database then you
likely wouldn't notice much difference. However, as I recall FF just
uses SQLite, so if you want an interface to that it would be easy
enough.

Joshua D. Drake

--
PostgreSQL - XMPP: jdrake@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

On Fri, 14 Aug 2009, Philip Rhoades wrote:

It would be nice to be able to use PostgreSQL as the storage for Firefox
Bookmarks - anyone know if this would be possible? how it could be done?

Firefox uses SQLite to hold its bookmarks. It's certainly possible to
hack the code to use an alternate database instead; for example there's a
description of a port to use CouchDB at
http://www.kryogenix.org/days/2009/07/06/firefox-bookmarks-in-couchdb

PostgreSQL is not an inappropriate choice here though, as it's not
designed for embedded use. It's just not easy to have a captive
PostgreSQL postmaster process for a job like this that's managed by
another app, and the project at large is not interested in making that
easier. See http://wiki.postgresql.org/wiki/Todo#Features_We_Do_Not_Want
for more details.

The small advantages you'd get using PostgreSQL instead of SQLite (better
scalability with multiple clients, better handling of very large files,
less possiblity of data corruption) are pretty minor relative to how much
work it would take to make the code compatible, and the number of people
who could take advantage of it usefully (those who are already managing a
database server on the same system as the browser) is tiny.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

Philip Rhoades wrote:

People,

It would be nice to be able to use PostgreSQL as the storage for Firefox
Bookmarks - anyone know if this would be possible? how it could be done?

Most likely it could be done, if you wanted to.

You will need to know how to write a firefox plugin, and how to
programmatically connect to a postgresql server and perform an
insert/update/select, then integrate both pieces of knowledge.
sqlite manager may answer some of that for you.
http://code.google.com/p/sqlite-manager/

Then there is always the question of should you? What do you wish to
accomplish? Could a smaller db like sqlite be a better option?

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz