Hi,
you can use the UNIQUE constraint with two columns: UNIQUE(CustID, Count).
regards,
Szymon Lipiński
On 1 September 2016 at 11:28, Michelle Konzack
wrote:
> Hello to all,
>
> after a period of silence from Debian, Courier, PHP and PostgreSQL I am
> half back and running in
so other programmers could create
their own properties file without debugging the application. And document
how I should make my own properties file, and run the app.
--
regards Szymon Lipiński
On 21 May 2016 at 11:28, Chris Travers wrote:
>
>
> On Fri, May 20, 2016 at 10:43 PM, Guyren Howe wrote:
>
>> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <
>> pierrechevalierg...@free.fr> wrote:
>> >
>> > Le 04/05/2016 18:29, Szymon Li
On 20 May 2016 at 22:43, Guyren Howe wrote:
> On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <
> pierrechevalierg...@free.fr> wrote:
> >
> > Le 04/05/2016 18:29, Szymon Lipiński a écrit :
> >> On the other hand, when I was trying to store all my logic i
On 21 May 2016 at 00:08, Steve Atkins wrote:
>
> > On May 20, 2016, at 1:43 PM, Guyren Howe wrote:
> >
> > On May 20, 2016, at 13:38 , Pierre Chevalier Géologue <
> pierrechevalierg...@free.fr> wrote:
> >>
> >> Le 04/05/2016 18:29, Szymon Lipińs
inconsistent" and "Indexes are useless, they don't give anything
except for slowing down the database". So, don't believe in everything
"wise" people say, just think, and check on your own.
--
regards Szymon Lipiński
e
>> breakpoints and such in PGAdmin, but I'll be that doesn't work for
>> other languages.
>>
>>
> There is a unit test framework for Postgres
>
> http://pgtap.org/
>
>
>
Right, and it is quite painful to use compared to writing tests as some
external program.
--
regards Szymon Lipiński
more money? But
> this is far to often the case and the root cause is they did not have the
> right tool (pun not intended) for the job.
>
> On Wed, May 4, 2016 at 1:33 PM, Szymon Lipiński
> wrote:
>
>>
>>
>> On 4 May 2016 at 19:09, Will McCormick wr
own DAO's. I think if
> your a database guy and you don't own the DAO's you are missing an
> opportunity to really make a difference and get more aligned with your
> development staff. Doesn't matter what code base DAO's are in it's a
> repetitive pattern
r. Of course it is always simpler to migrate
a database treated like a CSV file, where all the logic (including
constraints) is in an external application. But do we really want that?
On the other hand, when I was trying to store all my logic in a database,
there was just one thing that made me hate it. Testing. Testing the
procedures inside the database was not easy, not funny, and too much time
consuming.
--
regards Szymon Lipiński
s book should be about something else, start from an ORM, and
show how to translate it to much better SQL, as ORMs are the things
programmers usually understand, and they really don't bother that using
them can be a bad idea.
--
regards Szymon Lipiński
logic
> but this is not that often.
>
> I.e. people think the peg is square but indeed it is round.
>
>
>
>From my perspective there is one more thing: when I tried, in couple of
companies, to move some part of the logic to a database, then usually the
management said "no, t
12 matches
Mail list logo
