How to edit bookmarks sqlite database directly?
V S Rawat
and if yes, then is there any way that we can directly insert a few
dozens of links/ desc for bookmarks into the database?
if not, then how to?
thanks.
--
V
V S Rawat
And -
For a first run, FF has always been asking whether to import bookmarks
from ie ( I wonder whether it asks "from" other browsers)
But, one we have been using it, which is the easiest method of importing
the bookmarks FROM various browsers (ie, sm, opera) and exporting the ff
bookmarks TO them?
Do those browser have option to give html that FF3 would read, or are
they able to read html that FF creates for bookmarks?
thanks.
--
V
Jay Garcia
--- Original Message ---
It's an encrypted file and can't be edited directly. However you can
install the Sqlite Manager extension that works quite well, I use it all
the time:
https://addons.mozilla.org/en-US/firefox/addon/5817
--
Jay Garcia - Netscape / Flock Champion
Netscape - Firefox - Flock - Thunderbird Support
UFAQ - http://www.UFAQ.org
Fox on the run
I don't believe it's encrypted. You can view the content of it with a
sqlite browser. You can edit it directly, but it's not recommended.
Because unless you make the proper entries in the various tables, it
won't work properly. They (Mozilla) recommend that you use the API if
you want to add/change something in the database. The API will make
the appropriate entries for you. There may be an add-on already
written to do what you want to do.
JB
Jay Garcia
--- Original Message ---
It is encrypted and all what you say is all the more reason to leave it
alone and rely on a bona-fide sql manager application.
Fox on the run
Just to be clear, are you saying it's encrypted because it's not
easily legible in notepad for example, or are you talking about true
encryption? I honestly do not believe it is encrypted. If it was,
you would not be able to open the database to browse its content
without Firefox (or without the encryption key). Yet I can easily
browse the sqlite database files using sqlite browser from
sourceforge.net (an external, stand alone sqlite browser).
Not trying to split hairs. But there is a huge difference between
something that is encrypted, encoded, or just not user-friendly to
read without the application designed to read that file format.
Regards what I said is reason enough not to do it, I won't argue with
that one. Unless you fully understand the relationship between the
various tables within places.sqlite, attempting to manually add/remove
data could cause real problems. It's not that it's terribly
complicated. But it's not elementary either.
JB
David McRitchie
> Do those browsers have option to give html that FF3 would read, or are
Yes, all browsers can export and import bookmarks.html formatted
files. But the information actually included varies. The most glaring is
that IE does not include descriptions from the very beginning, and it
does not include keywords (/aliases/). I think tags are unique to
Firefox. Important information is lost converting to IE, so that information
is not available coming back to Firefox. Opera is much better as it has
descriptions and aliases (/keywords/). Bookmarklets are available across
browsers, but may not always work, in any case they will not be lost as
they are simply Javascript instead of a url. Favicons (web icons) probably
get passed through don't know. Usage statistics, and timestamps don't
know if they get brought in when importing even within Firefox, but it might
be questionable when and where they would be valid somewhere else.
In any case keep in mind that exporting from Firefox to IE, then exporting
from IE and back to Firefox you will lose your original Firefox keywords,
and descriptions. No problem with those between Firefox and Opera.
With all of the browsers when you import bookmarks, they are added to the
END of your bookmarks. So you would need to move what you want where
you want it and delete the remaining crud (duplicate folders & bookmarks).
(off topic) A little trick for copying bookmarks or folders from one Fx3 to
another Fx3 profile is to copy folder or bookmark from one profile to another profile is to
copy and paste from and to bookmarks toolbar / bookmarks menu /
organize bookmarks (library list).
--
HTH,
David McRitchie, extensions I use are briefly documented on my site
Firefox Custom: http://www.mvps.org/dmcritchie/firefox/firefox.htm
d381e
> (off topic) A little trick for copying bookmarks or folders from one
> Fx3 to
> another Fx3 profile is to copy folder or bookmark from one profile to
> another profile is to
> copy and paste from and to bookmarks toolbar / bookmarks menu /
> organize bookmarks (library list).
I was curious about this, since I don't have FF3 yet and have put off
installing it because I didn't think I'd be able to keep bookmarks in
sync between computers. I don't fully understand what's being copied. Is
this being done within FF, or outside FF in the profile folders?
Is it possible simply to copy the sqlite database from one profile to
another, maybe the simplest for me?
--
David
Fox on the run
Yes, you could simply copy places.sqlite from one machine to another
to copy over your bookmarks (and surfing history as they are contained
within the same sqlite file). I have not seen anything in the sqlite
file that would tie it to a particular profile. There is now a new
table within places.sqlite that I'm not sure what it does. However I
don't think it would cause any problems.
Having said that if you are comfortable with storing your bookmarks
online, you can make life simple by using an addon such as Foxmarks
(https://addons.mozilla.org/en-US/firefox/addon/2410) to synchronize
your bookmarks between computers.
JB
d381e
Thank you very much. I'll be more comfortable moving to FF3 with the
database copying (as well as the copying the exported backup html file
for good measure). I feel more comfortable not having to rely on an
outside service to store the bookmarks, and the copying method fits
right in with my workflow, so once I have it set up there would be
nothing additional I should have to do. Having the browse history in
both profiles I consider a plus for when I've forgotten to bookmark
something I'd searched on the other computer.
--
David