Thread: I've created an Apache Derby to PostgreSQL converter, would like to add to wiki

I've created an Apache Derby to PostgreSQL converter, would like to add to wiki

From
bill robertson
Date:
Hello,

I've created a converter program that will convert the tables, data and indexes in a given schema to a script that can be used to populate a PostgreSQL database.

 https://github.com/billrobertson42/derby2pg

I'd like to add it to the wiki page for this (https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL), but my wiki account is new enough and I can't log in yet, and I don't have edit permissions yet.

If somebody could either add the converter to the page for me, or give my account edit permission for the wiki so I can add it, I would appreciate it.

Thanks!
Is there anyone who will help? I still can't even log into the site.

On Mon, Dec 5, 2016 at 11:14 PM, bill robertson <billrobertson42@gmail.com> wrote:
Hello,

I've created a converter program that will convert the tables, data and indexes in a given schema to a script that can be used to populate a PostgreSQL database.

 https://github.com/billrobertson42/derby2pg

I'd like to add it to the wiki page for this (https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL), but my wiki account is new enough and I can't log in yet, and I don't have edit permissions yet.

If somebody could either add the converter to the page for me, or give my account edit permission for the wiki so I can add it, I would appreciate it.

Thanks!

On 12/10/2016 09:52 AM, bill robertson wrote:
> Is there anyone who will help? I still can't even log into the site.

>     I'd like to add it to the wiki page for this
>     (https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL
>     <https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL>),
>     but my wiki account is new enough and I can't log in yet, and I
>     don't have edit permissions yet.

Sorry, I never noticed your request. The normal "cooling off" period is
a week. I have just expedited that. Please log into the wiki once and
reply back. At that point I can give you editor rights for the wiki.

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


On Sat, Dec 10, 2016 at 12:52:15PM -0500, bill robertson wrote:
> Is there anyone who will help? I still can't even log into the site.
> 

I can't give you editor privilege, so I added derby2pg to the wiki page.

Hope the description is ok for you, I copy/paste what you used in your first
mail.

> On Mon, Dec 5, 2016 at 11:14 PM, bill robertson <billrobertson42@gmail.com>
> wrote:
> 
> > Hello,
> >
> > I've created a converter program that will convert the tables, data and
> > indexes in a given schema to a script that can be used to populate a
> > PostgreSQL database.
> >
> >  https://github.com/billrobertson42/derby2pg
> >
> > I'd like to add it to the wiki page for this (https://wiki.postgresql.org/
> > wiki/Converting_from_other_Databases_to_PostgreSQL), but my wiki account
> > is new enough and I can't log in yet, and I don't have edit permissions yet.
> >
> > If somebody could either add the converter to the page for me, or give my
> > account edit permission for the wiki so I can add it, I would appreciate it.
> >
> > Thanks!
> >

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org



Thank you Joe, I appreciate you adding the link.

Thank you Julien. I appreciate you activating the account. I didn't realize that the cool off period was quite so long. I appreciate the help.

I have logged into the site, will you please give me edit privileges on the wiki? I realized that my description needs a bit of work.

Also, I have and idea about something that might be added to the wiki. I still want to look into a bit, but would this be an appropriate place to ask later on for feedback?

Cheers!

On Sat, Dec 10, 2016 at 1:23 PM, Julien Rouhaud <julien.rouhaud@dalibo.com> wrote:
On Sat, Dec 10, 2016 at 12:52:15PM -0500, bill robertson wrote:
> Is there anyone who will help? I still can't even log into the site.
>

I can't give you editor privilege, so I added derby2pg to the wiki page.

Hope the description is ok for you, I copy/paste what you used in your first
mail.

> On Mon, Dec 5, 2016 at 11:14 PM, bill robertson <billrobertson42@gmail.com>
> wrote:
>
> > Hello,
> >
> > I've created a converter program that will convert the tables, data and
> > indexes in a given schema to a script that can be used to populate a
> > PostgreSQL database.
> >
> >  https://github.com/billrobertson42/derby2pg
> >
> > I'd like to add it to the wiki page for this (https://wiki.postgresql.org/
> > wiki/Converting_from_other_Databases_to_PostgreSQL), but my wiki account
> > is new enough and I can't log in yet, and I don't have edit permissions yet.
> >
> > If somebody could either add the converter to the page for me, or give my
> > account edit permission for the wiki so I can add it, I would appreciate it.
> >
> > Thanks!
> >

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

On 12/10/2016 12:37 PM, bill robertson wrote:
> Thank you Joe, I appreciate you adding the link.
>
> Thank you Julien. I appreciate you activating the account. I didn't
> realize that the cool off period was quite so long. I appreciate the help.
>
> I have logged into the site, will you please give me edit privileges on
> the wiki? I realized that my description needs a bit of work.


You got Julien and I backwards ;-), but in any case I have now made you
an editor.

> Also, I have and idea about something that might be added to the wiki. I
> still want to look into a bit, but would this be an appropriate place to
> ask later on for feedback?


Good question actually. I think most people just edit the wiki in a way
that makes sense to them with little prior oversight. I guess where you
might ask depends on the topic. Anyone else with opinions?

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


> You got Julien and I backwards ;-), but in any case I have now made you
an editor.

LOL. Sorry about that. :D

Maybe to add some context to my idea if others want to think about it. I was looking for ways to integrate ElasticSearch with PostgreSQL. Started on the FDW page, and found a few projects, but eventually ended up finding Zombodb, which isn't an FDW, but it's not mentioned on the site anywhere.

All of this got me to wondering, should there be a page that is about integrating PostgreSQL with other things?

Also, another side note, the FDW page only lists one of the many ElasticSearch FDWs. Is that one listed because it's known to be better than the others or is it just there because it's there? If it's the later case, I'd like to help fill in a bit more detail for others in the future.

Thanks.


On Sat, Dec 10, 2016 at 4:43 PM, Joe Conway <mail@joeconway.com> wrote:
On 12/10/2016 12:37 PM, bill robertson wrote:
> Thank you Joe, I appreciate you adding the link.
>
> Thank you Julien. I appreciate you activating the account. I didn't
> realize that the cool off period was quite so long. I appreciate the help.
>
> I have logged into the site, will you please give me edit privileges on
> the wiki? I realized that my description needs a bit of work.


You got Julien and I backwards ;-), but in any case I have now made you
an editor.

> Also, I have and idea about something that might be added to the wiki. I
> still want to look into a bit, but would this be an appropriate place to
> ask later on for feedback?


Good question actually. I think most people just edit the wiki in a way
that makes sense to them with little prior oversight. I guess where you
might ask depends on the topic. Anyone else with opinions?

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


> On Dec 10, 2016, at 4:43 PM, Joe Conway <mail@joeconway.com> wrote:
>
> On 12/10/2016 12:37 PM, bill robertson wrote:
>> Thank you Joe, I appreciate you adding the link.
>>
>> Thank you Julien. I appreciate you activating the account. I didn't
>> realize that the cool off period was quite so long. I appreciate the help.
>>
>> I have logged into the site, will you please give me edit privileges on
>> the wiki? I realized that my description needs a bit of work.
>
>
> You got Julien and I backwards ;-), but in any case I have now made you
> an editor.
>
>> Also, I have and idea about something that might be added to the wiki. I
>> still want to look into a bit, but would this be an appropriate place to
>> ask later on for feedback?
>
>
> Good question actually. I think most people just edit the wiki in a way
> that makes sense to them with little prior oversight. I guess where you
> might ask depends on the topic. Anyone else with opinions?

It depends on the idea - my hunch would be “-advocacy” but that’s without having any additional context.

Jonathan




bill robertson wrote:

Hi Bill,

> Maybe to add some context to my idea if others want to think about it. I
> was looking for ways to integrate ElasticSearch with PostgreSQL. Started on
> the FDW page, and found a few projects, but eventually ended up finding
> Zombodb, which isn't an FDW, but it's not mentioned on the site anywhere.

The wiki is not a good venue to discuss things.  If you want to chat
with somebody about some random idea you had, use the mailing lists or
IRC, or perhaps go to a conference (there are plenty all over the world)
where you can discuss in the hallway track.

> All of this got me to wondering, should there be a page that is about
> integrating PostgreSQL with other things?

That sounds way too large a topic for a single wiki page.  If you're
feeling prolific, one idea is to write a few of those pages in the wiki
and create a wiki category that links to them all.  Or perhaps you can
write a blog (and then you can create a wiki page with links to the blog
posts, or just copy the contents over).

> Also, another side note, the FDW page only lists one of the many
> ElasticSearch FDWs. Is that one listed because it's known to be better than
> the others or is it just there because it's there? If it's the later case,
> I'd like to help fill in a bit more detail for others in the future.

The wiki is not expected to be perfect all the time.  If links are
missing, feel free to contribute by editing the page.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services