Personally, I think there's no comparison between Derby and SQLite.
Derby's an actual database with all the bells and whistles, but still
a really compact size. SQLite is an extremely fast database-like system
with a much smaller subset of features and SQL compliance. Plus, if
you're writing in
Hi Folks,
This is something I seem to struggle with every time I write a new db
application. I feel like I design the database logically, but somewhere
in the application code, I always seem to define constants that directly
mirror what's in my database. I'm interested in how other people deal
Been there done that... this is what I do now to make making changes
easy.
1. Define tables the normal way but don't include any constraint
definitions in the table definition.
2. Define all constraints(foreign keys etc.) as separate alter table
commands. with easy to use
If you don't have access to the input stream, then this method won't
help too much. However, if you do, Java 1.4.2 has a ProgressMonitor
class that can pop open after a specified amount of time with a progress
bar. It also has a ProgressMonitorInputStream which can wraps the input
stream.
ry
I usually have a version table in my database that only contains one
row--what version of the schema I'm using. Then, when then application
first opens the database connection, I query the table to see if I need
to upgrade the schema. Since I know what the tables used to look like in
the old
This sounds like a great idea to me.
On 2/20/06, Daniel John Debrunner [EMAIL PROTECTED] wrote:
2) Now start the command line processor
c:\ ij
Dan, expanding on your previous idea, what if we add a class to
derbytools.jar as it's default run class that just switches on the
As with everything in databases, performance depends on what you're
doing. (What follows is general database information, not Derby
specific.) If you have a query like:
select bannerbannerid
from SSiteRequest
where BANNERBANNERID=6
and WEBSITESWEBSITEID=10
and USERSUSERID=1
then the composite
I would look into a SimpleDateFormat object. It can handle text-to-date
and date-to-text conversions pretty easily.
ry
Bernt M. Johnsen wrote:
Nicolas Dufour wrote (2005-09-26 08:16:14):
Hello
First of all, I would thank the work behind derby : it's a really