272251 - create Firefox extension for sql support

Status: RESOLVED INCOMPLETE

(Core Graveyard :: SQL, enhancement)

Description

[Henrik Gemal]

it could be nice if sql support was available as a firefox extension.

Comment 1

[Asser Femø]

(In reply to comment #0)
> it could be nice if sql support was available as a firefox extension.

Agreed. It is very easy to repack the existing jar and dll to the new Firefox EM
format, however Firefox 1.0 (probably 0.9 too, haven't tested) needs the sql.dll
to be relinked against xpcom.dll. I'm trying to get Firefox to build on my WinXP
box so I can rebuild sql.dll, but I'm new at this so it could take a while :-)

If you are interested I can post my package structure and install.rdf for the
Extension Manager format.

Comment 2

[Jan Varga [:janv]]

(In reply to comment #1)
> If you are interested I can post my package structure and install.rdf for the
> Extension Manager format.

yes, I'm interested

Comment 3

[Asser Femø]

New .xpi layout:
chrome/sql.jar
components/sql.dll
components/sql.xpt
components/sqlpgsql.xpt
install.rdf
install.js (for backwards compatibility with Mozilla not using EM)

install.rdf:
<?xml version="1.0"?>
<RDF xmlns="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:em="http://www.mozilla.org/2004/em-rdf#">
    <Description about="urn:mozilla:install-manifest">
        <em:id>{0602ECD6-845C-43d8-8B71-80E30B77BBB3}</em:id>
        <em:name>SQL</em:name>
        <em:version>0.1</em:version>
        <em:description>SQL support in Mozilla</em:description>
        <em:creator>Jan Varga</em:creator>
        <em:homepageURL>http://mozilla.org/projects/sql/</em:homepageURL>
        <em:optionsURL>chrome://sql/content/pref-sql.xul</em:optionsURL>
        <em:file>
            <Description about="urn:mozilla:extension:file:sql.jar">
                <em:package>content/</em:package>
                <em:locale>locale/en-US/sql/</em:locale>
            </Description>
        </em:file>
        <em:targetApplication>
            <Description>
                <em:id>{ec8030f7-c20a-464f-9b0e-13a3a9e97384}</em:id>
                <em:minVersion>0.9</em:minVersion>
                <em:maxVersion>1.0</em:maxVersion>
            </Description>
        </em:targetApplication>
    </Description>
</RDF>

Comment 4

[Asser Femø]

Attachment: install.rdf for Firefox' Extension Manager

Comment 5

[Asser Femø]

Attachment: Patch for pref-sql.xul to fix EM Options dialog problem

This patch removes several flex=1 attributes from the tree in the preferences
dialog since Firefox renders the tree a bit too narrow otherwise.

Comment 6

[Asser Femø]

Attachment: XPI for win32 pgsql Firefox 1.0

Contains my relinked sql.dll and the changes to pref-sql.xul. Tested on 2
machines in WinXP with Firefox 1.0, and works fine with the sqltest
application.

sql.dll was compiled using the latest AVIARY_1_0_20040515_BRANCH

Hope it works for someone else, too :-)

Comment 7

[Eoin Kennedy]

Hi,
Can you please put this xpi file onto the main sql extension page for Firefox
bowsers?

Thanks(In reply to comment #6)
> Created an attachment (id=169021) [edit]
> XPI for win32 Firefox 1.0
> 
> Contains my relinked sql.dll and the changes to pref-sql.xul. Tested on 2
> machines in WinXP with Firefox 1.0, and works fine with the sqltest
> application.
> 
> sql.dll was compiled using the latest AVIARY_1_0_20040515_BRANCH
> 
> Hope it works for someone else, too :-)
> 

Comment 8

[Benjamin Smedberg]

The SQL extension and component are no longer active.