database software

turalyon · 07-04-2007, 09:24 AM

hello is there a database software that would allow you to exceed 256 columns of data without using macros and the like? excel and MS access cant handle it so i hope there are others that have. havent tried oracle/ms sql others because i want to be sure b4 buying it. thanks for the help

**prh99** · 07-04-2007, 06:12 PM

As far as free goes there is MySQL, PostgreSQL, and SQLite, I don't know if they'll exceed 256 columns. Then there are the commercial ones like Oracle and Microsoft that you mentioned. MySQL also has a commercial version of their database.

Just curious, but why do you need to go over 256 columns?

vincent_10_27 · 07-04-2007, 11:03 PM

There is a lite/free version of Microsoft SQL Server 2005. I think it was called "Express Edition". Well, I can not remember much of the software since we used it in my database class for the sake of having a good feel of different structured query language programs. You can download that via Microsoft's Website if you have a Genuine Copy of Windows(Not sure as of now).

And I have never tested if it will go beyond 256 columns. But most database tools for servers out there should THEORETICALLY support far more than 256 columns considering these software handle many many loads of data in real life applications.

turalyon · 07-05-2007, 09:37 AM

256 columns? well im doing image processing and i need to pass a matrix of 320x320 to the database and as of now i have thought to convert it to 640x1 instead so i dont need to go over 256 columns.

anyway maybe i'll go try the free ones one by one first.

thanks for the replies ^^

07-04-2007, 09:24 AM	#1 (permalink)
turalyon Spammer Join Date: Mar 2006 Posts: 127 Points: 7,491.39 Bank: 59,053.86 Total Points: 66,545.25 Donate	database software hello is there a database software that would allow you to exceed 256 columns of data without using macros and the like? excel and MS access cant handle it so i hope there are others that have. havent tried oracle/ms sql others because i want to be sure b4 buying it. thanks for the help

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

07-04-2007, 06:12 PM	#2 (permalink)
prh99 - Join Date: Aug 2005 Posts: 1,567 Images: 3 Points: 876.00 Bank: 1,667,481.60 Total Points: 1,668,357.60 Donate	As far as free goes there is MySQL, PostgreSQL, and SQLite, I don't know if they'll exceed 256 columns. Then there are the commercial ones like Oracle and Microsoft that you mentioned. MySQL also has a commercial version of their database. Just curious, but why do you need to go over 256 columns?

07-04-2007, 11:03 PM	#3 (permalink)
vincent_10_27 Special Member Join Date: Feb 2006 Location: BC, Canada Posts: 877 Images: 1 Points: 3,884.09 Bank: 1,079,488.41 Total Points: 1,083,372.50 Donate	There is a lite/free version of Microsoft SQL Server 2005. I think it was called "Express Edition". Well, I can not remember much of the software since we used it in my database class for the sake of having a good feel of different structured query language programs. You can download that via Microsoft's Website if you have a Genuine Copy of Windows(Not sure as of now). And I have never tested if it will go beyond 256 columns. But most database tools for servers out there should THEORETICALLY support far more than 256 columns considering these software handle many many loads of data in real life applications.

07-05-2007, 09:37 AM	#4 (permalink)
turalyon Spammer Join Date: Mar 2006 Posts: 127 Points: 7,491.39 Bank: 59,053.86 Total Points: 66,545.25 Donate	256 columns? well im doing image processing and i need to pass a matrix of 320x320 to the database and as of now i have thought to convert it to 640x1 instead so i dont need to go over 256 columns. anyway maybe i'll go try the free ones one by one first. thanks for the replies ^^

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)