Database creation software

[rdt]

Hi,

I am looking for database or list creation software.

I was wondering if anyone here is familar with any software, which allows users to quickly create lists, and create create custom columns within the list(s).

Does anybody know any software either free or paid that can create lists with custom columns?

Thanks

[+BudMan MVC]

you mean like excel? ;) yeah there are plenty of free spreadsheet software other that lets you create a list of things be it text or numbers dates in columns and rows even and sure you can put what ever heading you want on each column or row.

Can even do graphs of this data, and pivot type tables to present the data in different ways. You can run queries against data included in your "list" of stuff

But sure if you want to put it into a "database" mysql comes to mine or MS Access works too. SQLite comes to mind as well - but you have not described any need for anything other than a spreadsheet.

[rdt]

  On 21/10/2012 at 13:50, BudMan said:

but you have not described any need for anything other than a spreadsheet.

Hi BudMan,

Thanks for your response, I was hoping to have some of the columns link to items on other lists, so that's why I can't use Microsoft Excel? Also it needs to support up to 20 people potentially adding data simultaneously.

[xendrome]

Access or FIle Maker

[Barney T. Administrators]

I was going to suggest Access if you really need a database. Or for a freeware alternative, you can use Libra Ofice or OpenOffice database programs....

[ILikeTobacco]

Access and its freeware alternatives are your best bet. Simple and easy to learn.

[oshocus]

FileMaker personally is the best Database software in the World.

[+Majesticmerc MVC]

Microsoft Access (part of MS office) and LibreOffice Base (free) are the two that come to mind straight off. If you've got any basic web experience it wouldn't be too hard to make a MySQL/PostgreSQL/MSSQL/Sqlite and a PHP (or Ruby, etc) front end for your web browser.

[+BudMan MVC]

"I was hoping to have some of the columns link to items on other lists"

Could be done with excel.

As to 20 people - shared workbook, not sure of the limit, again you can have multiple users using excel spreadsheet at same time so again not something that could not be done with excel.

But plenty of FREE databases out there.

[rdt]

Thanks everyone for your comments :)

  On 21/10/2012 at 22:32, BudMan said:

But plenty of FREE databases out there.

Do you have examples, or names of products? I tried googling but didn't find much...

[yakumo]

  On 22/10/2012 at 09:28, rdt said:

Do you have examples, or names of products? I tried googling but didn't find much...

PostgreSQL

mySQL

SQLite

[Glassed Silver]

FileMaker, which is top notch or Bento if you're on a Mac and don't need the full blast. (read OP again and the request rules out Bento I'm afraid)

Or if you need to stay very very open, go for MySQL and possibly a localhost'd web front end/operate it with an application.

Glassed Silver:mac

[moloko]

My SQL or ACCESS

portable freeware http://portableapps.com/apps/development/database_browser_portable

• Works directly with Oracle, MS Sql Server, ODBC, MySql, PostgreSQL, SQLite, Ole DB, Interbase and Firebird
  
• Support for ODBC connection strings
  
• Unlimited number of connections
  
• One click switching from one connection to another
  
• One click table browsing
  
• Data browsing
  
• Data exports into CSV, Excel, Html files
  
• Execution history
  
• SQL Builder with wide range of supported databases
  
• Execution Log
  
• Incremental Table Search
  

OR

http://www.portablefreeware.com/index.php?sc=140

Lots of options out there. I just did portable database search in google.

[+Nik Louch Subscriber²]

MySQL is a database server, and I feel the user is looking more towards a standalone product rather than a server to build his database on?

Access would be just dandy. But as said above - your specs are fully possible within Excel.

[rdt]

  On 22/10/2012 at 09:57, nik louch said:

MySQL is a database server, and I feel the user is looking more towards a standalone product rather than a server to build his database on?

Yes, that's correct I am looking for an application that allows end users to create lists and relationsips without any coding.

  On 22/10/2012 at 09:46, Glassed Silver said:

FileMaker, which is top notch or Bento if you're on a Mac and don't need the full blast. (read OP again and the request rules out Bento I'm afraid)

Glassed Silver:mac

Thanks, a program similar to Bento is exactly what I am looking for, execept windows or web based.