From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Tremer To: development@lists.ipfire.org Subject: Re: PostgreSQL as possible addon ? Date: Fri, 29 Mar 2019 14:11:24 +0000 Message-ID: In-Reply-To: <14efc334e76a595ba4eab654d7e38631ad1260c5.camel@ipfire.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============5510510425006833880==" List-Id: --===============5510510425006833880== Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi, I really like PostgreSQL. Internally we use it for everything and it is the b= est database out there in my opinion. However, I think the best way if you want to run this on IPFire is to run thi= s in a virtual machine. Then you would even have some application that can ma= ke use of it. Is that a solution that would work for you? Best, -Michael > On 29 Mar 2019, at 10:01, ummeegge wrote: >=20 > Hi Michael, > haven=C2=B4t seen your request... >=20 > On Mi, 2019-03-27 at 15:06 +0000, Michael Tremer wrote: >> What are your arguments for it? > Some arguments from my side: > - Since we dropped MySQL cause no one maintained it appropriately > (which was also a kind of overkill) i thought it might be nice to have > a substitute which is, in my opinion, easier to update but also some > implementations has been changed here (nothing in /srv and wider spread > in the system but now all in /var) and of course i think PostgreSQL is > also the nicer one. > - I also really like some helper tools like pgsql (also to have for > MySQL) for the not so affine SQL users but that=C2=B4s only a beside one. > - Another one is, have seen some requests for a non Sqlite DB from > users in the forum where it thought i can make a try for their favorits > which was PostgreSQL clearly before MySQL. > - If someone uses IPFire also in a kind of server environment which i > do, PostgreSQL can be a nice one to have. >=20 > But again, i=C2=B4 am totaly fine with your arguments and of course i can > nevertheless use it for myself. >=20 > Best, >=20 > Erik >=20 >>=20 >>> On 27 Mar 2019, at 15:06, ummeegge wrote: >>>=20 >>> Hi Michael, >>> OK no problem. >>>=20 >>> Best, >>>=20 >>> Erik >>>=20 >>> On Mi, 2019-03-27 at 14:53 +0000, Michael Tremer wrote: >>>> Hi, >>>>=20 >>>> I would oppose PostgreSQL as an add-on. >>>>=20 >>>> There are two major reasons for this: >>>>=20 >>>> * Nobody has ever requested it. At least I am not aware of it. We >>>> do >>>> not have any applications that require it or would run better if >>>> PostgreSQL was there. Since we already have loads of add-ons that >>>> are >>>> barely used and barely maintained I would like to avoid adding >>>> another. >>>>=20 >>>> * Based on that last note, I would say that we also have enough >>>> places to do work on that constantly get stuck. Instead of >>>> opening >>>> another construction site, I would like to at least have one or >>>> more >>>> closed - or at least declare that we do not intend to work on >>>> this >>>> any more. >>>>=20 >>>> Best, >>>> -Michael >>>>=20 >>>>> On 27 Mar 2019, at 14:28, ummeegge wrote: >>>>>=20 >>>>> Hi all, >>>>> another question ;-). >>>>> Since i=C2=B4d build PostgreSQL for IPFire --> >>>>>=20 >>>=20 >>>=20 > https://git.ipfire.org/?p=3Dpeople/ummeegge/ipfire-2.x.git;a=3Dcommit;h=3D2= 30d0569d3f24b608852328a983b1791731aee4c >>>>> <-- only testing version >>>>> and made also some testings with it -->=20 >>>>> https://forum.ipfire.org/viewtopic.php?f=3D50&t=3D22476 >>>>> incl. pgcli --> https://www.pgcli.com/ i wanted to ask if it >>>>> would >>>>> make >>>>> sense to deliver it to the mailinglist ? >>>>>=20 >>>>> Best, >>>>>=20 >>>>> Erik >>>>>=20 >>>>>=20 >>>>=20 >>>>=20 >>=20 >>=20 >=20 --===============5510510425006833880==--