Wanted: Free Relational Database Online

PasturesNew

You'd not think it hard would you.... I want a simple-to-use free online relational database.

I'd be creating just 2-3 simple tables:

Supplier
ProductGroup
Specific Product Available

I'd populate it with stuff I might want to buy. Then create simple reports.

e.g. 4 companies make widgets, wodgets and wudgets. Each of them sell a blue widget at £X. As I discover these I'd like to add them to the database, then when I want to buy a blue widget my report will show me: "Who sells blue widgets and at what price?". "Which companies sell wodgets?"

I've found free trials, but no free forever result.
Anybody know of one?

I want one online as I have a laptop and a PC at present; in the next year I'll be getting another PC..... and so I just want to be able to add things without having to concern myself with which PC I am on.

Or, is the answer to use OpenOffice on all PCs and store the file on Google Drive? (Not used Google Drive yet, just downloading it to my laptop to see how it works).

InsideInsurance

A NAS or Cloud drive is one solution.

If you google for free MySQL hosting then you will find both free webhosts that give you a MySQL db and those that just do dedicated MySQL hosting.

Unless you want to use a web access (either custom built by you or using an off the shelf/ open source option) then you will need to ensure the host allows remote connection to the db server

timbim_2

The best answer will be to use OpenOffice Base with a remote MySQL database, which could be anywhere (Cloud server, NAS, one of the PC's etc). See here for how to connect the two

Linton

Agree with OpenOffice Base and MySQL. I have used it myself for genealogical data and found it very powerful and reliable.

But be warned that this is serious professional database software and so you do need an understanding of SQL and possibly Basic programming.

I guess you are familiar with SQL, but if not the O'Reilly book "Learning SQL" is based on MySQL. Also of use is "Database Programming, OpenOffice.org Base & Basic" by Roberto Benitez. I have found the MySQL and Open Office official documentation rather limited.

PasturesNew

OK.... I have a 3rd year Uni-level qualification in SQL and database modelling etc .... I wanted the easy peasy point/click and drag/drop solution

I've got a bunch of MySQL databases kicking around on hosts doing other stuff, so that might be the way to go then..... have to bite the bullet and get up to speed with specifics again.... but it won't happen today, whereas an easy peasey.... would have happened today.

I hadn't spotted earlier, but zoho creator is free, up to 1000 records (I could hit that easily within a year)..... I hadn't spotted it as I have a small screen and it was under the list of paid options. Might bung some data in that for now... can always export the csv files then import them to MySQL when I've more time to dedicate to this stuff.

Cheers.

Mr_Toad

There's a free version of Oracle that might be worth a look.

http://www.oracle.com/technetwork/products/express-edition/overview/index.html

I've never tried the free version only the commercial version.

InsideInsurance

Mr_Toad wrote: »

There's a free version of Oracle that might be worth a look.

Same with Microsoft SQL Server and IBM DB2

I mentioned MySQL because the OP said laptop and therefore may want to access it from outside of their network. Whilst Oracle, MS SQL and DB2 could run on their home network and exposed to the outside world or a VPN be set up etc a free or cheap as chips hosted MySQL db may be easier