The cvs/svn worked I managed to dump out of beta 1 and now have my database
restored in RC1. Many thanks to all.
--
Mark Walker
cannot re-install the version
that the database was last used with (it should have been first initialised
on 8.2, as I went to the beta to experiment with enum having recently
returned from MySQL).
Any help appreciated, including links to a download of beta1 that still
works.
--
Mark Walker
I'm not sure what you're trying to do but, it appears that you database
design is incorrect. What you need is something like
CREATE TABLE temp_readings
(
_date Date,
temperature double,
source varchar(20),
)
No reading, no record. Are you suggesting that you would have a weekly
set of rec
>>>One of my problems with database development is how to construct
analogously strong test cases in order to prove the code correct. <<<
I have found the best method is to be as random as possible. I think
coders subconsciously only test with data they think will work so they
don't have worr
If you don't know something, why are you trying to record it? From a strict
relational sense, the existence of NULL values in your fields indicates that
your primary keys are not
truly candidate keys for all your fields. That means your database isn't [BCNF]
normalized.<<<
I agree that ther
You're probably right. A good example of that is the difference between
the excellent pgadmin and the desktop mysql administrator which is very
buggy and strangely laid out. Whenever I have to deal with mysql I get
the feeling I'm messing around with a bunch of hacks. It's very strange
to de
se
server independence is definitely a goal for most non custom applications.
Scott Marlowe wrote:
On Thu, 2007-02-22 at 12:17, Mark Walker wrote:
While I'll admit to some similarities between PHP/java and mysql/pgsql,
I'd say that th gulf between php and java is far less than the gulf
I think a lot of the reasons people use LAMP is that inexpensive ISPs
use LAMP. The reasons ISPs use LAMP as opposed to other, in my opinion
more powerful tools has to do with the complexities of hosting large
numbers of user applications on single machines.
For instance, I don't know anybody
Sorry if this may be a bit off topic. I'm curious what naming
conventions people use for column names. After trying quit a few
different conventions I've come to use differing cases and the
underscore to identify and delimit variables. A lot of it has to do
with sql and Postgresql reserved w
I think you need delete, update, and insert rules for warehouse.
Subtract out the old on delete & update. Add the new in update and
insert. Aggregates would be an incredible waste of processor time.
pgsql-user wrote:
Hi,
I got stuck with the following problem and strangely couldn't find
a
Actually in theory it is possible to completely secure a database by
putting all your business logic in stored procedures/functions and
allowing only raw database access to administrators. Plenty of people
do this. In fact if I were designing something that had lots of users
who had relativel
table
role based access.
2. Proxy server method.
Storing passwords locally would be anywhere from trivial to moderately
difficult to hack.
Paul Lambert wrote:
Mark Walker wrote:
I'm curious. How do you feel about having a scrambling algorithm
embedded in your application, but having the
I'm curious. How do you feel about having a scrambling algorithm
embedded in your application, but having the scrambled password publicly
readable in a config file? Does that seem secure? This is what you
have to do if you want your users to connect to different databases
choosing their own
27;t
work. Oh well, it sounded good.
Mark Walker wrote:
But you don't have to turn it on by default for any particular
database, and you could sign any application you want for your
individual server.
Paul Lambert wrote:
Mark Walker wrote:
One other thing. Another approach to this
But you don't have to turn it on by default for any particular database,
and you could sign any application you want for your individual server.
Paul Lambert wrote:
Mark Walker wrote:
One other thing. Another approach to this problem would be to have
some sort of code signing/authentic
One other thing. Another approach to this problem would be to have some
sort of code signing/authentication capabilities for the postgresql
server. For instance, you login as an administrator (some sort of
enhanced privs), you get to look at the databases you have permission
for. Otherwise,
If hiding the password in your application is an option, i.e. you only
have one database your application will ever connect to, then at least
scramble the password within your application with some complex algorithm.
If you can't hide the password in your application, then you need to
deny acc
I used to have OOM killer problems with Tomcat, Apache's JSP server, but
not any more. A new variable appeared in the config settings which had
to do with the maximum memory that Tomcat would use for itself, and I
think that may have been what fixed the problem. Does Postgresql need
something
aris to eat at McDonald's.
Richard Troy wrote:
On Tue, 30 Jan 2007, Mark Walker wrote:
LOL, I remember those days. "Uh, can you hold on? My computer just
went down." or "you need to fill out form 1203-B, send us $25 and we'll
get you the information you need in si
LOL, I remember those days. "Uh, can you hold on? My computer just
went down." or "you need to fill out form 1203-B, send us $25 and we'll
get you the information you need in six weeks." Just kidding, but
certainly reliability standards and information demands are much higher
these days, are
It's interesting that this is yet another issue of where exactly you
want to place your business logic. Do you do it as much as you can on
your sql server or do you bias it towards your client application. It's
obvious that you can do cross database linking in your application
layer, but if y
Does the developer offer any hard evidence for his statement? I mean
like benchmark tests and a side by side list of features?
My impression is that Mysql is set up very narrowly for a typical ISP
offering LAMP and not much else. Once you start going into corporate
installations on private s
What is the delimiter between id and created_at? I believe they're
supposed to be tabs with \t used for tabs inside a field. The data you
give here is all whitespaces.
Mason Hale wrote:
I've done a bit more digging into this, here's what I've found --
The text db dump file is much too big
OK, let me think. In my situation, I'm writing an accounting app. A
typical situation would be a standard user would be able to update data
in a timesheet while an administrator would be able to approve the time
sheet. If I gave the standard user access to the timesheet header
table, they wo
I want to make a client application that logs onto a postgresql server
with an individual postgresql user role for each user. This is as
opposed to having one user role for the entire app, storing that
password on the local client, and using the client app to do
authentication against a a tabl
25 matches
Mail list logo
