Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has its own database system. And another system uses No-SQL database. I am faced with a task of producing web-based management reports to allow managers to see key performance indicators on screen. What would be the best way of accomplishing this? I would perform cross database queries of the key performance …

Member Avatar
Member Avatar
+0 forum 4

I worked for 20 years in hardware and twenty odd now in software, so change is an old friend. I consult on UNIX/LINUX to a variety of industries, write lots of bits for my own needs, love to help others over their hurdles.

Member Avatar
Member Avatar
+0 forum 1

Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO product table linking to specified Catageory Table? How to SELECT products with same FK? as well as UPDATE and DROP? Thanks in advance!

Member Avatar
Member Avatar
+0 forum 11

A new version (9.0) of [URL="http://www.postgresql.org"]PostgreSQL[/URL] is in beta and ready for public testing. If version 9.0 lives up to its proposed [URL="http://www.postgresql.org/about/featurematrix"]feature list[/URL], then it is serious competition for MySQL. PostgreSQL proponents have long suggested that PostgreSQL has always enjoyed superiority over MySQL. I beg to differ but that may be changing. I tried using PostgreSQL several times over the past few years, beginning with version 6.x. I received it on CD for review. It was OK. Nothing thrilling or special. I did think it was an ambitious project but at the time, I didn't really care much for …

Member Avatar
Member Avatar
+0 forum 16

I'm not sure if this is the place for this post but I didn't really know what it fell under so I apologize in advance if this belongs in another forum. I'm looking at creating a new online app for myself and others to store certain types of data. I'd like the ability to display this data in a "versioned" sort of way. For example, someone uploads some data for people to use. Someone else comes along and likes what they did, but wants to modify it and store it under their collection as well, so they "fork" it. I …

Member Avatar
Member Avatar
+0 forum 1

The End.