Books we've written
SQL in a Nutshell 4th
PostgreSQL: Up and Running (1st, 2nd, and 3rd Editions)
pgRouting: A Practical Guide
Custom Database And Web Applications
It is a recurring pattern in software development that people scope out projects without the end-users in mind. They put in too much or too little validation. They demand input of pieces of information that are rarely used in reporting or are redundant. These decisions are often made in a vacuum without considering the effect of this on the usability of the application. They focus their development on rarely used difficult to program pieces and neglect on making the more common day to day tasks easy to do. In the end, despite the good intentions of the programmers and project managers, if the end user finds an application cumbersome to use, the application will collect dust.
When starting a project, we first consider:
We then try to put all of this into perspective, weighing items based on criticalness, ease of implementation, dependency on other action items, and whether an item is really needed or can be achieved as a derivative of another piece of information.
We consider ourselves much better than most IT consultants at making these critical common sense decisions as well as having the knowledge to execute them. These fundamental skills are the main determinant of success or failure of a project.
We have proven skills with PostgreSQL/PostGIS, SQL Server, Microsoft Access, SQLite, MySQL, and other relational database systems. We also offer development using Visual Basic, VB.NET, PHP, and C#. We can help you:
Contact Us detailing your project requirements and we can provide a free ball-park estimate as to the pieces that need to be implemented and the cost and time of implementation.
Web Application Development and Prototype Hosting
Have an application you want to webify? Paragon can help you convert existing desktop applications to web based ones, design new web-based applications or enhance and upgrade existing ones. Our staff has expertise in the areas of database and web application development and deployment using technologies ASP.NET (1.1, 2.0, 4.0), PHP (5+), SOAP and REST Web Services. We have experience with both Windows and Linux.
We are experts in PostGIS and PostgreSQL
Below is a sampling of services we have provided in this area
Real Estate Analysis
We are experts in spatial database analysis and its use in analyzing property data. With are unique skill set, we can load in freely available government data to answer the following questions and many more:
Mentoring, Training, and Support
We have helped many companies and individuals across the country develop their own database and web applications. We provide one-on-one training usually via the phone, IM (such as Skype Slack, or Matrix), and/or Zoom. Mentoring works best when you have a project you are working on. We will help you get over the technical hurdles by either pointing you in the right direction or doing that technically challenging portion of the work for you and explaining the steps.
Below is a list of some of the areas we have mentored
Union Membership, Payment and Dues Modules, and Union Organizing
We have extensive experience working with Unions. We have developed many Union Membership, dues tracking, grievance tracking and case management custom tailored applications and also provide On-Demand web application hosting for these applications. We can provide a standard application with minimum customization for low-budget shops and provide more advanced customizations as needed. Refer to our Union Services guide for more details.
Not happy with your current hosting company and want to move to a different one, or want to host your own website? Paragon has helped many companies relocate their websites and database applications. Below are a couple of reasons you may choose to move your website.
Here are some of the functions we have provided in the past to other customers
Networking, Internetworking, Windows 2003, Windows 2008 / Linux server support, IIS/Apache Support and Database server administration
We have staff proficient in Windows 2003/2008/2012/2016/2019/2022, Linux (Debian/Ubuntu, Redhat EL , CentOS) and FreeBSD, IIS, NGINX, Apache, and PostgreSQL, SQL Server, and MySQL administration. We can provide 24/7 phone support.