Re: [libreoffice-users] HSLQLDB syntax

Hi :)
http://www.lasa.org.uk/aims/choosing-the-right-package/

Just under the bullet-points it claims 
"
You can purchase AIMS Core which allows up
to 15 concurrent users. This version of AIMS is available in either Access or SQL versions.
" 

So it's a bit unclear whether the Access version is using the normal jet-engine or  Microsoft SQL 
Server as it's back-end.  Either way i think there is a potential problem at being able to run 
their front-end, or use another front-end, on non-MS platforms such as Android tablets, Macs, 
iPads.  I suspect the Firebird back-end is more likely to be faster and more compatible with more 
platforms.  

Regards from
Tom :)  





> ________________________________
> From: Mark LaPierre <marklapier@aol.com>
> To: users@global.libreoffice.org 
> Sent: Wednesday, 17 July 2013, 23:30
> Subject: Re: [libreoffice-users] HSLQLDB syntax
>
>
> Access is no back end.  As a front end it's fairly adaptable as long as 
> the total file size does not exceed 2 Gb.  That 2 Gb limit pretty much 
> rules it out as a back end for anything but very light weight databases.
>
> On 07/17/2013 06:37 AM, Tom Davies wrote:
> > Hi :)
> > +1
> > to all that, especially the "Once you are up to date, I'm sure they'd appreciate any help you 
> > can offer.".  Plus, making yourself familiar with HsqlDb 1.8 is a good plan anyway.  HsqlDb is 
> > java based but it's small and fast so as an external back-end it's good for most uses.
> >
> > My workplace is considering buying a specialist database that uses Firebird as a back-end so i 
> > kinda hope Base goes that way too.  Unfortunately they have left the final purchase decision up 
> > to someone outside the organisation that is fairly clueless about compatibility and the 
> > alternative back-end is Access.
> > Regards from
> > Tom :)
> >
> >
> >
> >
> >
> > > ________________________________
> > > From: V Stuart Foote <VStuart.Foote@utsa.edu>
> > > To: "users@global.libreoffice.org" <users@global.libreoffice.org>
> > > Sent: Wednesday, 17 July 2013, 0:55
> > > Subject: RE: [libreoffice-users] HSLQLDB syntax
> > >
> > >
> > > Mark,
> > >
> > > Hey why should you care that it is off topic, no one else seems to understand the concept ;-)
> > >
> > > So, regards movement toward a non-Java JRE dependent default SQL DB for integration with the 
> > > Base component.
> > >
> > > Several Bugzilla items worth reviewing:
> > >
> > > considering and rejecting SQLite as replacement
> > > https://bugs.freedesktop.org/show_bug.cgi?id=38811
> > >
> > > find a replacement for HSQLDB v1.8
> > > https://bugs.freedesktop.org/show_bug.cgi?id=51781
> > >
> > > considering an update to HSQLDB v2.x
> > > https://bugs.freedesktop.org/show_bug.cgi?id=44854
> > >
> > > move default to FireBird not HSQLDB in Base -- this is the current development effort
> > > https://bugs.freedesktop.org/show_bug.cgi?id=51780
> > >
> > > Finally, here is the Wiki based project coordination for implementing FirebirdSQL
> > > https://wiki.documentfoundation.org/Development/Base/FirebirdSQL
> > >
> > > Once you are up to date, I'm sure they'd appreciate any help you can offer.
> > >
> > > Stuart
> > >
> > > ________________________________________
> > > From: Mark LaPierre [marklapier@aol.com]
> > > Sent: Tuesday, July 16, 2013 6:13 PM
> > > Subject: Re: [libreoffice-users] HSLQLDB syntax
> > >
> > > Well actually, I was going to ask what might replace HSQLDB but I
> > > thought it might be a bit too far off topic.
> > >
> > >
> > >
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be deleted
>
>
> -- 
>      _
>     °v°
>    /(_)\
>     ^ ^  Mark LaPierre
> Registered Linux user No #267004
> https://linuxcounter.net/
> ****
>
> -- 
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted