All,
New to the list and a relative newbie to PostgreSQL. Please forgive stupid
questions.
Designing an application server for a work order processing (et al)
database. I have a good handle on sequences, referencial integrity, views,
& the basics. What books/documentation would you recommend to learn more
about...
- database design for security
- database design for performance
- database design for ease of maintenance
- triggers and functions
Also, the application will require some complex forms, and printing
graphical reports (currently served from an Access 2000 database.) What
tools/interfaces/servers would you recommend for the application server?
Is there a tool you would recommend for generating graphical reports to
html?
TIA.
Lane Beneke; IT Manager
Stephenson Millwork Company, Inc.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
1  3462 
On Wednesday 05 November 2003 19:42, Lane Beneke wrote:
Designing an application server for a work order processing (et al)
database. I have a good handle on sequences, referencial integrity, views,
& the basics. What books/documentation would you recommend to learn more
about...
- database design for security
There are plenty of resources on designing securely and the principles are the
same for databases as anything else:
- decide what operations to permit and allow only that
- only allow validated input into your application/database
check for valid values, not invalid ones
- try to build multiple lines of security
- be realistic about the threats you face - a power failure can be as
catastrophic as a hacker break-in.
- database design for performance
- database design for ease of maintenance
Any book by Date - try "Introduction to Database Systems". A good clean
normalised design pays dividends - don't denormalise without good arguments
why, and document the problems this will cause.
- triggers and functions
Check http://techdocs.postgresql.org/ - there are lots of articles/examples
there, especially in the cookbook.
Also, the application will require some complex forms, and printing
graphical reports (currently served from an Access 2000 database.) What
tools/interfaces/servers would you recommend for the application server?
I'd leave the reporting etc in Access for phase 1 if you can, and move it over
afterwards. If your users are on Windows, I'd probably not change at all. If
they're happy with the current reporting leave well alone.
Assuming you're going web-based, you might want to consider java, perl, php or
python frameworks. Look around and see if there isn't a Zope or perl/php app
that is close to what you need, perhaps.
Is there a tool you would recommend for generating graphical reports to
html?
Plenty of perl/php libraries for this. Presumably for python too.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: L. Bertolini |
last post by:
We're considering purchasing an application,
which stores some data in the filesystem, and
some data (meta data and links to files) in
MS-SQL.
We need to be able to create a backup wherein
the...
|
by: MW de Jager |
last post by:
I'm having endless problems with gaining access to an Access Database that
sits on a different server. My ASP.NET app cannot gain control. The errror
message I get is:
The Microsoft Jet...
|
by: |
last post by:
Dear Groups,
I am trying to develop a simple client <-> server application where (for
database security reasons) the server only has access to the centralised
database (and a file repository),...
|
by: Dan |
last post by:
(Using Classic ASP & MS Access)
I have a page that has 120 fields on it (mostly checkboxes). I cannot
split this into smaller pages.
So what i want to do is write a class that handles this. in...
|
by: Jim Devenish |
last post by:
I have a split front end/back end system. However I create a number of
local tables to carry out certain operations. There is a tendency for
the front end to bloat so I have set 'compact on...
|
by: YellowFin Announcements |
last post by:
Introduction
Usability and relevance have been identified as the major factors
preventing mass adoption of
Business Intelligence applications. What we have today are traditional
BI tools that...
|
by: nyathancha |
last post by:
Hi,
I have a question regarding best practices in database design. In a
relational database, is it wise/necessary to sometimes create tables
that are not related to other tables through a...
|
by: dgleeson3 |
last post by:
Hello all
I am creating a VB.Net distributed SQL server 2005 application.
Each computer in the system has a database with a table of users and
their telephone numbers.
Each computer has a...
|
by: abhijitbkulkarni |
last post by:
Hello,
I am designing a .NET database application that uses 3 tier architecture. Starting initially, this application will be desktop application but I will convert it into a website later but...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
