Re: Doubts about Linux databases

[Biju Chacko <biju@xxxxxxxxxxx>]

I would suggest that you use PostgresSQL as your backend. You could write a
frontend in VB or Perl/Python if you want cross-platform compatibility.

An alternative, of course, is to use a web-based front end written in PHP.

I think this would take care of your basic requirements.

With regards to limitations -- I think it's pretty much a non-issue. A well
designed app should include proper purging and archiving of data such that
limits are not approached. That said, you'd be pretty surprised what databases
can handle. I've seen gigabyte sized clipper databases working happily, for 
chrissake!

Biju

On Fri, Mar 23, 2001 at 08:32:29AM +0530, fileof wrote:
>  [1] The databases should preferably sport a GUI interface ( preferably
> because, the entries will be done by inexperienced individuals-- and we do
> not want to spend  a lot of time with them explaining how to enter the
>  data ) . First of all is it possible.. ??
>  [2] The database should be network based that is distributed database.. I
> should be able to access my database from a centralised server from any
> client, but with appropriate permissions..
>  [3] what about an RDBMS ...??
>  [4] and also security is top priority on my mind...Will the database permit
> view based security like in Oracle. For example students should be able to
> see only their personal details and not of others.. Also they should not be
> allowed to look at their internal marks before a certain date.. So i need to
> solve problems like these which are plenty...
>  [5] Ease of use.....
>  [6] Licensing issues.... I know this may not be much of a matter..in
> Linux..
>  [7] Also Its capability-- Like what is the maximum database size it can
> support--  By the way, how many of the Linux databases are being used in
> Industries in  a production environment--  I am really curious..Medium to
> large scale industries.. where the employees  are more then 5000..  For
> example in my organisation, we a 5000+ strong Public sector.. we need
> databases to do salary processing , Tax processing, PF calculations,
> Inventory management, and other such stuff.. The issue is can how can i
> convince my organisation to take up those Linux databases instead of Oracle
> on NT.. Does any of the Linux databases satisfy my Organisational
> requirements..???
>  [8] What are the Hardware capabilities required-- Also what distros to be
> used.. Can i use Redhat or Suse or Mandrake..???
>  [9] what stability issues are involved-- Also support issues...
>  [10] ALso i am curious to know as to how many Universities and IIT's are
> using Linux based databases in thier campuses ( I know that many of the
> IIT's CSSE dept's are using Linux for educaton) .. But what about the
> databases..??
>  [11] We already have a COMPAQ Proliant server ( sorry i forgot the server
> Hardware release number) .. So anybody have any idea about these servers
> vis-a-vis Linux ( like involving driver issues-VGA, Network card, Modem's
> etc...)
>  I know about COMPAQ presarios .. They are definitely NOT Linux friendly..
> However we have COMPAQ Deskpro clients ( all of them are so) ...what about
> them..???
> 
>      I wanted to suggest Linux databases for them because it does not
> involve  costly Licenses, if the same can be achieved..
> Also it is an educational institution.. And it can propel many on the Linux
> path by serving as a model..
> I can use the same knowledge to suggest to my organisation ( I am working in
> a Public sector) about these issues..
> 
> My request to those who answer my queries, is to suggest appropriate links
> for the software, books, interesting experiences, any intersting info etc..
> 
> Ok that is all..
> Regards,
> Suri@Vizag
> 
> 
> 
> 
> 
> 
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
> 
> 
> ----------------------------------------------
> LIG is all for free speech.  But it was created
> for a purpose.  Violations of the rules of
> this list will result in stern action.

-- 
-------------------------------------------------
Biju Chacko        | biju@xxxxxxxxxxx (work)            
Exocore Consulting | biju_chacko@xxxxxxxxx (play)
Bangalore, India   | http://www.exocore.com
-------------------------------------------------