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  3491 
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 "Introducti on 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 database and files are "in synch" (in other words,
in a consistent state). We need to maintain the
"referential integrity" between database and files.
|
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 database engine cannot open the file
'\\Server1\DataFolder\Countries5.mdb'. It is already opened exclusively by
another user, or you need permission to view its data.
I have setup the connection string to have the username = admin and the
password is...
|
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), and not the client.
I think the best way to do this is to expose data layer objects using
Remoting to the client.
This sounds almost like a design pattern to me, but I can't seem to find
|
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 the code it
would be something like:
Set thisForm = new classBigForm
|
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 close'
I think that I have read in some threads (althoug I cannot find them
now) that others place such tables in a local, linked database. I
could do this but I am interested to know what would be the advantages.
And disadvantages, if any.
Any...
| | |
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 don't work
nearly as well as they should, even for analysts and power users. The
reason they haven't
reached the masses is because most of the tools are so difficult to use
and reveal so little
|
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 foreign Key
relationship or does this always indicate some sort of underlying
design flaw. Something that requires a re evaluation of the problem
domain?
The reason I ask is because in our application, the user can perform x
|
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 unique 4 digit identifying code.
The central server runs an application which reads the database table
on each computer.
|
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 design that I am planning should support both version.
Development Environment : VS2008, C#
Currently Database supported are MS SQL Server 2005 and MYSQL 5 and design for database support is extensible.
This application contains several high...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
