PSG 2.0 is a client/server database applications development platform.
It offers a solution for building secured applications that can efficiently function in heterogeneous networks such as the Internet, Intranet and local networks. The variety of built-in components and classes for different programming languages makes integration faster when working with a PSG platform and also allows the development of modular applications.
The PSG platform allows database applications to efficiently perform over the Internet or Intranet. It enables easy loading of thousands of records instantly, using them locally and updating the server. It builds rich Internet applications operating as well and efficient as any desktop applications and uses different programming languages. Among them .NET, Visual FoxPro or Java, are using PSG as an intermediate communication layer that’s secured by default.
PSG 2.0 can help you with:
- multi user applications based on relational databases
- ERP’s , Accounting, Warehouse, Production management, Human resource applications and any other similar areas
- CRM’s, SFA’s
- Document management applications
- Database applications for custom purposes
- secured application
- applications that require an additional level of security
- Software as a service (SAAS) solutions
PSG 2.0 can be used for client applications developed with:
- Microsoft programming languages like .Net C#, VFP
- JAVA (crossplatform client – Windows, Linux)
- support for other languages like Delphi, Ruby and maybe others, currently on research (January 2012 – check psgsdk.com).
PSG 2.0 enables faster development of applications compared with other solutions.
The system provides a default series of facilities, simplifying the development of complex applications, thus reducing development time with 40 to 60 %:
- user management and user access rights per user and users groups
- integrated powerful reporting engine
- templates and classes
- integrated simple help system (as HTML pages)
- integrated international toolkit
For client/server applications:
- compared to .NET SOAP web services, REST technology can decrease 3-4 times the time required to develop application modules (from days to hours)
- compared to WEB AJAX technologies, the development time can be around 5 times shorter.
For using PSG 2.0 you need only:
- programming experience with one of these languages: C#, VFP or JAVA
Some experience with client/server N-tier applications could be a plus, but not mandatory.
PSG 2.0 uses as additional resources:
- PSG server, which can be installed on any Microsoft Operating system, starting with Windows XP. The client is compatible with Microsoft XP,2000-2003, Vista, Win 7.
- database server, no other software or facilities are required.
- licenses for software development, which are not provided with PSG (.NET studio or VFP).
To run your application over the Internet, just set your NAT router/firewall to allow access to the PSG server secured port.
In terms of security over the Internet:
- PSG server runs behind firewalls in a totally protected environment. No need for DMZs.
- PSG server uses SSL 128 bit encryption and PKI up to 2048 bit. The communication protocol is HTTPS.
- While VPNs are not required, they can be used if necessary to comply to the company internal rules.
- The users are authorized with:
- username and password
- username/password and hardware key
- The server protects itself against brut force password crackers.
- The SSL security mechanism is implemented by default
- tools for creating custom certificates are provided.
- For the client, the maintenance cost is close to zero, same as a Web Browser maintenance.
- The client application will be automatically updated with the last releases from the server.
- The database server should be administrated by a specialist, according to its size and complexity (like any other application database servers)
- for small databases (few hundreds of Mb) that sort of support might not be necessary.
- medium and big databases need maintenance depending on the database server specifications (ie. some databases like Oracle, require a database administrator as Oracle is generally used for complex databases).