[dundee] Database front end - any ideas?
Barry Carr
barry at benericht.co.uk
Sat Feb 9 20:07:59 GMT 2008
Jen,
If this is your first exposure to Databases then I personally wouldn't start with Oracle. If you
want something that is full featured, has a low overhead, easy to deploy and has good support then I
would recommend Firebird. (go for 2.1 release candidate). If you don't need triggers and stored
procedure and just need something simple, then I'd recommend SQLite -its most SQL92 compliant and
can be embedded in the application, similar to Access. Both of the above will run on Linux, OS X and
Windows
http://www.firebirdsql.org/
http://www.sqlite.org
Cheers
Barry
<3 wrote:
> Thanks Gordon, I'll check with my group on Monday and see what sort of
> materials we need :)
>
> On Feb 8, 2008 5:07 PM, gordon dunlop <astrozubenel at googlemail.com
> <mailto:astrozubenel at googlemail.com>> wrote:
>
> I used version 9 of Oracle as version 10g takes up a lot of resources.
> I have also thick textbooks on oracle & databases. If you want, I will
> them in next Thursday if people want to borrow them over the next
> month.
>
> Gordon
>
> On 08/02/2008, <3 <sauntering.with.scissors at gmail.com
> <mailto:sauntering.with.scissors at gmail.com>> wrote:
> > she did not! ..sneaky secrets!
> >
> > thanks! ill have a google for it
> >
> >
> > On Feb 8, 2008 5:00 PM, gordon dunlop
> <astrozubenel at googlemail.com <mailto:astrozubenel at googlemail.com>>
> wrote:
> >
> > > Is the Lecturer Petra? Did she tell you that there is a free Oracle
> > > download, Windows and Linux.
> > >
> > > Gordon
> > >
> > >
> > >
> > >
> > > On 08/02/2008, <3 <sauntering.with.scissors at gmail.com
> <mailto:sauntering.with.scissors at gmail.com>>
> > wrote:
> > > > Lots of great suggestions! thanks!
> > > >
> > > > I think its the SQL behind the scenes and documentation
> that's being
> > > > assessed.. lecturer isnt too fussed about the front end. Her
> suggestion
> > is
> > > > Access (blegh) but said we could use something else if we like.
> > > >
> > > > We only have 3 or 4 weeks to complete it, so a web interface
> looks like
> > the
> > > > way to go on this one.
> > > >
> > > >
> > > > On Feb 8, 2008 4:32 PM, Rick Moynihan
> <rick.moynihan at gmail.com <mailto:rick.moynihan at gmail.com>> wrote:
> > > >
> > > > >
> > > > > On 08/02/2008, Barry Carr <barry at benericht.co.uk
> <mailto:barry at benericht.co.uk>> wrote:
> > > > > > Hi Jen,
> > > > > >
> > > > > > > Hi guys,
> > > > > > >
> > > > > > > A bunch of us have a database project to do and I was
> wondering if
> > > > > > > anyone had any ideas for what we could use as a front end?
> > > > > > >
> > > > > > > We were thinking of maybe a having web interface. I
> believe the
> > back
> > > > end
> > > > > > > has to be Oracle. Preferably cross platform (mixture of
> windows,
> > linux
> > > > > > > and OS X developers), and also if it requires an
> install it should
> > be
> > > > > > > something we can all get our hands on easily.
> > > > > >
> > > > > > There's quite a lot to choose from. If you're set on a
> web front end
> > > > then you might want to try
> > > > > > Ruby-On-Rails. Free to download and deploy and its got
> quite good
> > tool
> > > > support Netbeans 6.0, (XP,
> > > > > > Linux, OS X - runs on the JVM) and TextMate (OS X). Rails has
> > excellent
> > > > DB support but may struggle
> > > > > > if you're expecting a lot of visitors to the site.
> Deploying a rails
> > app
> > > > can also be a bit of a pain
> > > > > > too. There are also a couple of JVM alternatives, like
> Grails (Ruby
> > on
> > > > rails like framework for
> > > > > > Groovy) and JRuby-On-Rails (Netbeans has direct support
> for this
> > too).
> > > > > >
> > > > > > If you want a desktop app then you can choose between
> Mono (although
> > I'm
> > > > not sure how good its DB
> > > > > > support is) or the JVM. If you go for the latter then I
> wouldn't use
> > > > Java but have a look at Groovy
> > > > > > or Scala instead. Groovy and Scala should be able to use
> all Java
> > > > libraries and frameworks that are
> > > > > > currently available and both of these languages are waaay
> ahead of
> > Java
> > > > esp. Scala. If you use the
> > > > > > JVM you might also want to take a look at Hibernate which
> is an
> > > > Object-relational mapping framework.
> > > > > >
> > > > > > There is loads more to choose from but the above should
> point you at
> > the
> > > > current mainstream.
> > > > >
> > > > > Now, now, Barry I'm not sure any of those other than
> perhaps Rails and
> > > > > Hibernate are mainstream! :-) Sure, they're all generating
> a lot of
> > > > > interest amongst tech bloggers and the like and have many
> compelling
> > > > > reasons for adoption but they're definitely not
> mainstream... They're
> > > > > just fashionable to talk about :-)
> > > > >
> > > > > --
> > > > >
> > > > > Rick Moynihan
> > > > > rick.moynihan at gmail.com <mailto:rick.moynihan at gmail.com>
> > > > > http://sourcesmouth.co.uk/blog/
> > > > >
> > > > > _______________________________________________
> > > > >
> > > > >
> > > > >
> > > > > dundee GNU/Linux Users Group mailing list
> > > > > dundee at lists.lug.org.uk <mailto:dundee at lists.lug.org.uk>
> http://dundee.lug.org.uk
> > > > > https://mailman.lug.org.uk/mailman/listinfo/dundee
> > > > > Chat on IRC, #tlug on dundee.lug.org.uk
> <http://dundee.lug.org.uk>
> > > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > dundee GNU/Linux Users Group mailing list
> > > > dundee at lists.lug.org.uk <mailto:dundee at lists.lug.org.uk>
> http://dundee.lug.org.uk
> > > > https://mailman.lug.org.uk/mailman/listinfo/dundee
> > > > Chat on IRC, #tlug on dundee.lug.org.uk
> <http://dundee.lug.org.uk>
> > > >
> > >
> > > _______________________________________________
> > > dundee GNU/Linux Users Group mailing list
> > > dundee at lists.lug.org.uk <mailto:dundee at lists.lug.org.uk>
> http://dundee.lug.org.uk
> > > https://mailman.lug.org.uk/mailman/listinfo/dundee
> > > Chat on IRC, #tlug on dundee.lug.org.uk <http://dundee.lug.org.uk>
> > >
> >
> >
> > _______________________________________________
> > dundee GNU/Linux Users Group mailing list
> > dundee at lists.lug.org.uk <mailto:dundee at lists.lug.org.uk>
> http://dundee.lug.org.uk
> > https://mailman.lug.org.uk/mailman/listinfo/dundee
> > Chat on IRC, #tlug on dundee.lug.org.uk <http://dundee.lug.org.uk>
> >
>
> _______________________________________________
> dundee GNU/Linux Users Group mailing list
> dundee at lists.lug.org.uk <mailto:dundee at lists.lug.org.uk>
> http://dundee.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/dundee
> Chat on IRC, #tlug on dundee.lug.org.uk <http://dundee.lug.org.uk>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> dundee GNU/Linux Users Group mailing list
> dundee at lists.lug.org.uk http://dundee.lug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/dundee
> Chat on IRC, #tlug on dundee.lug.org.uk
More information about the dundee
mailing list