Oracle Application xpress/html db Query

**css_jay99** · 4 December 2008, 18:16

just had a look on oracle website and looks like a database is also needed.
oracle Express is ideal but way too small as it can only hold 4Gb of user data. So oracle related solution is out of the question.

Another choice is Microsoft access.
Would it be possible to build an access forms application or the access database (that could provide a decent programing functionalities as in Oracle Forms)?

cheers

**lilelvis2000** · 4 December 2008, 21:26

Just what is it you are trying to achieve?

Access only has a 2GB limit - you can get around it by using tables links..but it gets confusing.

Microsoft SQL Express also has a 4GB limit. IMHO that's a good size for a database. I've got a Oracle database at my client's which has over 4 millions rows in it ..and its only just now broken 1GB .

Have you calculated how much space you need? You can always upsize later...move from Oracle Express to 11g (SQL Express to SQL Standard).

As for web front ends...Oracle Is okay. MS has a way of creating Access forms on to the web..and Im sure you have things like Ruby on Rails et al which all can do similar things.

**css_jay99** · 5 December 2008, 15:25

I was not aware there was even a small limit on Acess database.

Basically i have been approached to build an application. The clients deals with its customers over the internet.
The customers enter info or upload some data on the clients website. This goes into the database.
The client then wants to build an application that sits on this database.

If the client had money or already use an Oracle licence. It would have just done an easy job using Oracle forms and data uploads stored offline.

Well they dont have money which brings a lot of issues

I am considering oracle database lite but have no idea if oracle App express can be installed on it. I am assuming that these off course will not have licencing issues

if only i had knowledge of .net

css_jay99

**lilelvis2000** · 5 December 2008, 16:18

I can't see any issue using APEX on Oracle 10 Express. Should work just fine. Obviously some of the more advanced features won't be there...

I think Oracle XE comes with APEX...so you're sorted as far as I'm concerned.

There are plenty of blogs and tutorials on the web about APEX so you'll have plenty of help.

I don't see the issues you are concerned about..A oracle 10g licence is not that expensive..so if your client can't afford CentOS 5.2 (free), oracle 10g licence (~£250???) something's up.

**TheFaQQer** · 5 December 2008, 17:28

Originally posted by css_jay99 View Post

Well they dont have money which brings a lot of issues

How f***ing cheap are your client????

Named user for standard edition is £91.

**css_jay99** · 7 December 2008, 09:05

Originally posted by TheFaQQer View Post

How f***ing cheap are your client????

Named user for standard edition is £91.

licencing mistake was my fault, I assumed that licencing for these software were expensive. kinda moved them away from thinking of oracle as a solution, its easier to find a cheapier .Net permie than an oracle one since a lot of computer related graduates will be more clued up on .net apps

I best start learning some c# & .Net skills

css_jay99

**MikeB** · 13 December 2008, 11:54

use APEX!

APEX is great. You could do this dirt cheap, as FAQQER says either by using named licences or a hosted solution like http://www.shellprompt.net/

I even know a world class APEX developer who could do this for you for a special Christmas cut price deal

**adestor** · 13 December 2008, 13:27

I'd agree that generally apex is a good tool, although some things that were easy to do in things like Oracle Forms are more complicated in apex, e.g. finding the current rows values in a multirecord block. I hope version 4 will address these issues.

Oracle XE does come with apex, but you will need to upgrade to the latest version (3.1.2). But if 4Gb is not enough then get a named licence, as Faqqer suggests.

Or you could use MySQL

Oracle Application xpress/html db Query