Jump to content



Photo

Database creation software


  • Please log in to reply
14 replies to this topic

#1 rdt

rdt

    Neowinian

  • Joined: 21-October 12

Posted 21 October 2012 - 09:27

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


#2 +BudMan

BudMan

    Neowinian Senior

  • Tech Issues Solved: 106
  • Joined: 04-July 02
  • Location: Schaumburg, IL
  • OS: Win7, Vista, 2k3, 2k8, XP, Linux, FreeBSD, OSX, etc. etc.

Posted 21 October 2012 - 13:50

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.

#3 OP rdt

rdt

    Neowinian

  • Joined: 21-October 12

Posted 21 October 2012 - 20:00

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.

#4 xendrome

xendrome

    In God We Trust; All Others We Monitor

  • Tech Issues Solved: 14
  • Joined: 05-December 01
  • OS: Windows 8.1 Pro x64

Posted 21 October 2012 - 20:02

Access or FIle Maker

#5 Barney T.

Barney T.

    Debian Linux: I'm Loving It!

  • Tech Issues Solved: 3
  • Joined: 30-August 03
  • Location: Williamsburg, Virginia

Posted 21 October 2012 - 20:09

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....

#6 ILikeTobacco

ILikeTobacco

    Neowinian Senior

  • Joined: 08-July 10

Posted 21 October 2012 - 20:20

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

#7 oshocus

oshocus

    Neowinian

  • Joined: 16-October 12

Posted 21 October 2012 - 20:27

FileMaker personally is the best Database software in the World.

#8 +Majesticmerc

Majesticmerc

    Resident Idealist

  • Tech Issues Solved: 9
  • Joined: 24-August 05
  • Location: United Kingdom
  • OS: Arch Linux / Win 7
  • Phone: HTC One X

Posted 21 October 2012 - 20:51

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.

#9 +BudMan

BudMan

    Neowinian Senior

  • Tech Issues Solved: 106
  • Joined: 04-July 02
  • Location: Schaumburg, IL
  • OS: Win7, Vista, 2k3, 2k8, XP, Linux, FreeBSD, OSX, etc. etc.

Posted 21 October 2012 - 22:32

"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.

#10 OP rdt

rdt

    Neowinian

  • Joined: 21-October 12

Posted 22 October 2012 - 09:28

Thanks everyone for your comments :)

But plenty of FREE databases out there.


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

#11 yakumo

yakumo

    Neowinian

  • Tech Issues Solved: 1
  • Joined: 11-September 03

Posted 22 October 2012 - 09:44

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

PostgreSQL
mySQL
SQLite

#12 Glassed Silver

Glassed Silver

    ☆♡Neowin's portion of Crazy♡☆

  • Joined: 10-June 04
  • Location: MY CATFORT in Kassel, Germany
  • OS: OS X ML; W7; Elementary; Android 4
  • Phone: iPhone 5 64GB Black (6.0.2)

Posted 22 October 2012 - 09:46

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

#13 moloko

moloko

    Neowinian Senior

  • Joined: 28-December 02

Posted 22 October 2012 - 09:50

My SQL or ACCESS

portable freeware http://portableapps....rowser_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.portablef...ndex.php?sc=140


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

#14 +Nik L

Nik L

    Where's my pants?

  • Tech Issues Solved: 2
  • Joined: 14-January 03

Posted 22 October 2012 - 09:57

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.

#15 OP rdt

rdt

    Neowinian

  • Joined: 21-October 12

Posted 25 October 2012 - 08:25

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.


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.