Great article the one about derby security... just what I needed to know, thanks. -----Mensaje original----- De: Rick Hillegas [mailto:rick.hille...@oracle.com] Enviado el: jueves, 09 de febrero de 2012 07:47 a.m. Para: derby-user@db.apache.org Asunto: Re: About db file sizing
Hi Carlos, Some responses inline... On 2/8/12 3:00 PM, Carlos de Luna Saenz wrote: > I really don't know if this is a good couple questions or not... > We are developing an embedded DB app that has a 1.74GB of files for the > database > I wonder if there is something like a shrink or compact command that > will reduce the amount of space for the app DB. The SYSCS_UTIL.SYSCS_COMPRESS_TABLE and SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE procedures can be used to reclaim unused space. Don't know how effective they will be for your needs though. See http://db.apache.org/derby/docs/10.8/ref/ref-single.html#rrefaltertablec ompress > Is there a way to make it user/password protected? We don't want to > "start" a server on the program side but password protection would be > appreciated. Derby currently supports 3 user/password authentication schemes, discussed here: http://db.apache.org/derby/docs/10.8/devguide/devguide-single.html#cdevc secure42374 . In the next major feature release (10.9), we hope to introduce another authentication scheme which should be easier to configure and administer; it is described by the functional spec attached to https://issues.apache.org/jira/browse/DERBY-866 Hope this helps, -Rick > Greetings >