Database Services From NetInvent

Introduction to NetInvent Databases

We know databases

Muliple filing options (7KB image)

Most web databases are invisible to the user; providing product data for eCommerce or client data for recruitment sites. We are accomplished at building web databases that will vastly increase the power, flexibility and maintainability of your web site.

Databases are a powerful tool in the office, and we can help you extract the full value from that tool in your business. We build in-office databases that you can rely on. A badly built database can suffer serious problems in extended use, or when scaled to a larger size. When we build your database, we plan for the future.

At NetInvent we understand relational databases, both in theory and practice. We use object oriented systems analysis to help decide what data you need to store so that your database is easy to query, easy to maintain and performs efficiently.

We have both kinds of database here: MySQL and Microsoft Access

Just kidding.

Our databases of preference are Postgresql, IBM DB2, SQLite and MongoDB, even under Windows.

We used to recommend MySQL as a database server and used it for all our own development projects. While MySQL is still inexpensive to operate and often offers superior performance to more costly alternatives, we no longer recommend it. Postgresql and SQLite performance have caught up or surpassed MySQL; MySQL has always had a highly deviant SQL dialect and Oracle support is not something that people want to pay for: it's too expensive. While many people will never need support, most customers are more comfortable with a genuinely free database that isn't encumbered with Oracle's history of aggressively monetizing customers.

We are also happy to work on SQL Server, but don't be fooled into thinking it's a cheap option: DB2 is cheaper and better in most circumstances.

If you want to change away from another database product, we can help you migrate.

If your existing database has got into a mess, we might be able to help you extract useful data from it. We can help you untangle databases that have suffered from 'unfortunate' keying choices.

Reasons why good database design matters

Read about why you should get professionals to develop your office database to leverage long term savings in database running costs. A database isn't worth building unless it can give you the confidence to rely on it and not just use it as an expensive index to paper filing.

Read about common database blunders - unfortunately they aren't very comical, but if you are building an office database and you don't have any formal training, you might want to take a look. Our basic hints could save you some pain later.

Our database suggestions, in summary:

  • Don't pay huge fees to query specialists.
  • Pay small fees to us.
  • Get a database that works right first time.
  • Don't work to keep your database updated, make it work for you.
  • A database is more than just a filing system, it's the basis of genuine office automation.
  • If your office database isn't helping your business, get us to help you get the full value from your investment.