Help me create URL database!

I want to create a database online that looks like a spreadsheet and would have columns for URL, PPA, Launchpad, Supports: Windows, OS X, Linux (which I can checkmark) I'd also need to sort it by type of software (ie. Audio, Video, etc.) I can tell it which it belongs too.

Google Bookmarks comes close to what I'd like but am really interested in abit more details as shown above. I found this http://www.zoho.com/creator/ but how can I use it for that?

 

Log in or Sign up to hide all adverts.

Look very carefully at the term "Database", it's meaning is Base Data, which in turn means data that isn't formatted, or is being processed, the "raw" data if you would like.

To format the data into a spreadsheet like environment online, you are taking data from a database, parsing it through the usage of a script engine on the webserver and outputting it into a webpage.

It's simple enough to "read" the database of entries and "Format" it in a particular way for viewing, however if you want to be able to "edit" the database from the method that formats it, it will require additional coding.

It is possible to convert data that's placed into an OpenOffice spreadsheet into a SQL (database) format. So you'd have a potentially easy way of populating a page, however it is the parser scripts that you would require getting hold of, since they would have to test your data to make sure they aren't trying to inject interpretable code into the SQL engine. (Even if it accidentally happened, it could undermine your database integrity)

I'd suggest looking at creating something using software that can "export" the information you require for eventual inclusion in an online format. There is a Microsoft database application as well as OpenOffice having an open-source solution. Both to my knowledge can be exported and imported into a different database if needed.

 

Log in or Sign up to hide all adverts.

I figured it out, the site was easier to use than I thought. Have a look

Please Register or Log in to view the hidden image!

See I wanted to have a very simple list view of what platforms the software was available for without confusing me, I am going to fill it up with about 120 links

Please Register or Log in to view the hidden image!

Oh well it'll be done eventually. Also I had to have the PPA info easily made available to me and the launchpad addresses so I can just refer to it during reinstall of Ubuntu

 

Log in or Sign up to hide all adverts.