PostgreSQL License
*Can anyone explain the PostgreSQL License to me?* *Can I create a database with it and sell the database also preventing the buyer from reselling it?* *Can I change in the logos of the PostgreSQL system and its name?*
Re: PostgreSQL License
Thank you all, but it is saying (without fee) if I create a database with it to work with Web Application if want to sell it so the buyer must have the PostgreSQL installed in his device to work offline right? "Permission to use, copy, modify, and distribute this software and its documentation for any purpose, *without fee*, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies." > On Mon, Sep 16, 2019 at 11:18 PM Laurenz Albe wrote: > Please don't cross-post your question to more than one list! > > Ashkar Dev wrote: > > Can anyone explain the PostgreSQL License to me? > > Can I create a database with it and sell the database also preventing > > the buyer from reselling it? > > Can I change in the logos of the PostgreSQL system and its name? > > Yes. > > You only have to make sure that the original license text is included > in your license. This does not limit what you are allowed to do with > the software. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com > >
Re: PostgreSQL License
Hi all thanks, I meant maybe I create a web app with PostgreSQL that work locally for example for a pharmacy that stores data by barcode while the DB was created by PostgreSQL how I can sell the Database for him, how to deliver the product to him can I sell the package that contains web app files with PostgreSQL software and the database code? On Wed, Sep 18, 2019 at 2:23 AM Andreas Joseph Krogh wrote: > På onsdag 18. september 2019 kl. 01:07:41, skrev Rob Sargent < > robjsarg...@gmail.com>: > > > > > On Sep 17, 2019, at 4:18 PM, Andreas Joseph Krogh > wrote: > > På tirsdag 17. september 2019 kl. 22:55:02, skrev Peter J. Holzer < > hjp-pg...@hjp.at>: > > On 2019-09-17 14:56:30 +0300, Ashkar Dev wrote: > > but it is saying (without fee) > > if I create a database with it to work with Web Application if want to > sell it > > so the buyer must have the PostgreSQL installed in his device to work > offline > > right? > > "Permission to use, copy, modify, and distribute this software and its > > documentation for any purpose, without fee, and without a written > agreement is > > hereby granted, provided that the above copyright notice and this > paragraph and > > the following two paragraphs appear in all copies." > > This means that you don't have to pay a fee or sign a written agreement > to use, copy, modify, and distribute this software and its documentation > for any purpose. It doesn't say that you can't charge a fee for > distributing (although why anybody would pay you for something they can > download themselves for free I don't know). > > hp > > > A rule of thumb is - you can do anything you want with it (the PG software > inc. its source), except claim you wrote it, as long as you preserve the > original license-file(s). > > > I take it that the OP has an app/dataset on top of PG he/she wishes to > market (and protect). Perfectly legit, no? Not clear if there is a desire > to disable direct db access. > > > That seems perfectly legit. I'm not sure what "to work offline" means, but > using PG for whatever commercial purposes is totally fine, given the > license-requirement above. > > -- > *Andreas Joseph Krogh* > CTO / Partner - Visena AS > Mobile: +47 909 56 963 > andr...@visena.com > www.visena.com > <https://www.visena.com> > >
Re: PostgreSQL License
Thanks, but is it legal to charge for installing PostgreSQL? as you said: > You cannot (legitimately) charge the pharmacist for any part PostgresQL should I in the contract write that the price does not include installing PostgreSQL, preparing it or PostgreSQL itself? or just from my side while I am going to set price I have to dont count installing the PostgreSQL or PostgreSQL itself as a part of that price? On Wed, Sep 18, 2019 at 9:06 PM Rob Sargent wrote: > > On 9/18/19 11:50 AM, Ashkar Dev wrote: > > Hi all thanks, > > I meant maybe I create a web app with PostgreSQL that work locally for > > example for a pharmacy that stores data by barcode while the DB was > > created by PostgreSQL how I can sell the Database for him, how to > > deliver the product to him can I sell the package that contains web > > app files with PostgreSQL software and the database code? > > > You can charge the pharmacist for your efforts: your web app (license), > installing postgres and your schema (somewhere) and the data supporting > your web-app, any documentation of your web-app and schema, any > maintenance and support you care to specify. You can copy-right your app > and schema and data. > > You cannot (legitimately) charge the pharmacist for any part PostgresQL. > >
duplicate key value violates unique constraint
Hi all, how to fix a problem, suppose there is a table with id and username if I set the id to bigint so the limit is 9223372036854775807 if I insert for example 3 rows idusername ---- 1 abc 2 def 3 ghi if I delete all rows and insert one another it is like idusername ---- 4 jkl So it doesn't start again from non-available id 1, so what is needed to do to make the new inserts go into non-available id numbers?
UUID or auto-increment
Hi, for web application is it needed to use UUID or auto-increment? 1- if two user inserts row at the same time, does it work? 2- dose the database give the same id for both users or execute one of them first? ( I mean ID conflict not happens?) Thanks.
