database program

[knows_something]

I would like to create a small database of around 4-6 tables. I know MySql and Firebird so i could do it in cmd but that wouldn't make it easy to correct and see them. I'm just wondering if there's a good, FREE program that would help me do it. I thought about using Microsoft's Access but people keep telling me that that is not good enough and there are better, but they usually just advise payable software. 

tl;dr: free app for database creation

Thank you in advance

[unijab]

Why do you say that doing it over cmd line wont be easy to see or correct?

[ALwin]

snip

 

You want to create a database or an application that uses a database to store and retrieve data?  Additionally do you want something to host on your own computer for yourself or host it on a commercial webserver?

 

If you want a really good and free tool to create database applications, I would recommend Oracle APEX.  It's free and they let you use the Lite version of Oracle DB. Oracle APEX (Applications Express) has many enterprise level features.

 

http://www.oracle.com/technetwork/developer-tools/apex/overview/index-155186.html

https://apex.oracle.com/en/

[johnt]

I would like to create a small database of around 4-6 tables. I know MySql and Firebird so i could do it in cmd but that wouldn't make it easy to correct and see them. I'm just wondering if there's a good, FREE program that would help me do it. I thought about using Microsoft's Access but people keep telling me that that is not good enough and there are better, but they usually just advise payable software. 

tl;dr: free app for database creation

Thank you in advance

 

It's been my experience that people who say Access isn't good enough are people who don't know what they are talking about. For something like 4 to 6 tables, if you have access to Access (because it isn't free), then I say go for it and use it. 

[knows_something]

I would just like to create a database. it wouldn't be very heavy regarding sources, so i would run it on my PC. it's just for a project i'm doing in school and i don't need it to be professional. using cmd isn't hard, but is time consuming and correcting mistakes would take longer than just too let's say drag and drop a line in box like you do it in Access. 

I'm going to try that Oracle APEX and see how it goes, but if there's some really easy and quick to learn program, let me know 

[DigitalHermit]

Here:

http://dev.mysql.com/downloads/

GPL versions of MySQL

[knows_something]

Here:

http://dev.mysql.com/downloads/

GPL versions of MySQL

I'm not familiar with this program. Is it easy to use?

[DigitalHermit]

I'm not familiar with this program. Is it easy to use?

It's the Windows GUI for MySQL... more or less like MS Access/LibreOffice Base...

at least, that's how I remember it... (Haven't used it for over a year now...)

You can also try LibreOffice Base if the database that you're planning to build will not be connected to a web-based service (i.e. as part of a website's backend)...

[knows_something]

as a matter of fact it will be connected to a website i'll make. And now that i've mentioned, do any of you know a good site or an article of connecting database to a website using php (or any other method)? i'd be grateful if you knew.

[DigitalHermit]

as a matter of fact it will be connected to a website i'll make. And now that i've mentioned, do any of you know a good site or an article of connecting database to a website using php (or any other method)? i'd be grateful if you knew.

W3Schools...

I suggest getting the entire XAMPP package if you're going to dev a website...

[kango_v]

It's been my experience that people who say Access isn't good enough are people who don't know what they are talking about. For something like 4 to 6 tables, if you have access to Access (because it isn't free), then I say go for it and use it. 

LOL. It's been my experience that people who say that have absolutely no grasp of the problem domain. All you know is 4 to 6 tables. Our database has 6 tables, but will be using Apache Cassandra (as used by Netflix/Apple) as the RDBMS that we are using just cannot handle the load.

 

The the RDBMS based system we use currently is created with Hibernate/Java to create the classes and then the build (Maven) can create all the SQL statements and even connect to an existing database and update it. Good for unit tests. The same would be with NHibernate.

 

You can be up and running in Hibernate within a day.