PostGIS in Action
check out our books and download the first chapter and SQL primer free.

Tips and Tricks for PostGIS

Tips for getting the most our of PostgreSQL
Database and Web Programming Consultants at affordable prices
Paragon Corporation is a Boston based database consulting company specializing in Database and Web Applications. We provide 24/7 technical support at very affordable prices.

Specialties include, but are not limited to: PostGIS support (all versions) and PostgreSQL Consulting (9.3+, 9.2+ 9.1+ 9.0+ 8.4+ 8.3+ 8.2+ 8.1+), SQL Server Consulting (2008, 2005, 2000, 7.0), Microsoft Access (2010, 2007, 2003, 2000), MySQL (5+), SQLite, ASP.NET (1.1,2,4), VB.NET, PHP (4,5).
  • Mentoring - You like to do things yourself - but just need a little push on how to do a particular piece or need help trouble-shooting a problem. Check out some of our technology Papers and articles or RSS feed. We also provide one-on-one mentoring at our standard rates. Check out our Boston GIS for Open source Mapping, PostGIS support, GIS, and Spatial Database SQL Server 2008 SpatiaLite PostGIS tips or our Postgres OnLine Journal site for PostgreSQL support tips and tricks.
  • Intranet Application - You have a windows application or have a new application you would like to create as an intranet application for ease of manageability.
  • Internet Application or Site - You have an idea for a custom web application you'd like to get up quickly, or you have an existing site that needs some new functionality or changes.
  • ASP to ASP.NET or PHP Migration - You have a web application written in ASP and you would like it migrated to ASP.NET or PHP to take advantage of the new feature of .NET or the cross-platform/flexibility and plethora of open source sub-application add-ons for PHP.
  • Microsoft Access to PostgreSQL, SQL Server Upgrade - You have an Access database that has grown significantly and has become sluggish. You would like to upgrade the back-end to something more powerful such as PostgreSQL or SQL Server , and maintain the MS Access Client Front-end or create a Web Application Front-end.
  • Serious Database or Server Problems - You are having problems with your existing database or application server - it is locking, has become slow, or is off-line and you need help quickly. We can provide emergency services any time - day or night. We work around the clock so you don't have to.
  • E-Commerce - You have a product or service to sell and want a custom-tailored shopping cart with credit card service.
  • Upgrade a Legacy Application - You have an old application that serves most of your needs but does not work well with existing software or hardware. You need to know what can be salvaged and what needs to be redone.
  • Complex Application - You have a complex application that others have tried to do and failed. We are up to the challenge.

    We pride ourselves on being more than programmers and developers. Many members of our team have engineering degrees and apply engineering problem solving principles to programming problems. We have succeeded where many others have failed. We have a vast reservoir of knowledge in Logic, Probability & Statistics, Control Theory, Business Rules Methodology, Engineering, Economics, Finance, Optimization Algorithms, Operations Research, and Relational Calculus in addition to being proficient in various programming languages.

    When you want to build a system that can grow with you, do not hire a mere programmer that is only versed in the bits and bytes of programming, but instead hire an engineer-minded developer with experience and training in systems analysis and cost-benefit based refactoring that guarantees greater success in changing times.