469,319 Members | 2,329 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,319 developers. It's quick & easy.

Database developers: Am I nuts???

bartonc
6,596 Expert 4TB
I am a one-man development team.
A little over a year ago I began development of an automated data collection application.
I had already been using MySQL to persist data in very simple applications and chose that RBDMS for this project. The overall hierarchy is not very complex: With the state (of the US) at the top and collected data at the bottom, there are 4 levels in between (report cover sheet data is stored for Agency, Park, Trail and Segment).

I've built the entire package, from hardware to UI, query to printed page, by my self. Now, just as I am nearing completion (data reports are looking good and cover sheets have been started) [trying to forget that I have to build the installer], my customer has asked my to support one or more zero configuration DBs. I've been connected to the MySQL DB using ODBC for a while now and told the customer that it shouldn't be too much trouble to run on any DB that the could throw my way.

I've been working with SQLite3 and Access for a day or so and I'm beginning to think that I may be out of my mind?

Opinions???
Oct 13 '07 #1
9 1268
Scott Price
1,384 Expert 1GB
Which part do you want an opinion on? The *out of your mind* part?? :-) Or the other, *less important*, part? LOL

Seriously, though, what does the customer mean when he/she says that they want you to support zero config db's? In what way do they expect the product to support those db's? Are you talking about building a new UI within those other products, or a new 'back-end' to work with your already built UI?

Regards,
Scott

When all's said and done, more is said than done.

For some people, it's easier to talk than think.
Oct 14 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
Are you having problems creating odbc connections to the databases?
Oct 14 '07 #3
bartonc
6,596 Expert 4TB
Are you having problems creating odbc connections to the databases?
Nope. That was the easy part. Getting a handle on the nuances between SQL implementations it my current struggle.
Oct 14 '07 #4
bartonc
6,596 Expert 4TB
Which part do you want an opinion on? The *out of your mind* part?? :-) Or the other, *less important*, part? LOL
Yea, this part.
Seriously, though, what does the customer mean when he/she says that they want you to support zero config db's?
I just discovered that JET 4.0 is installed on all XP systems. All the "configuration" that is required is naming the data source in the ODBC control panel (assuming that the database exists - which it would). The same is true of SQLite3 after the ODBC driver is registered with the system, just drop the DLL into the app installation folder.
In what way do they expect the product to support those db's? Are you talking about building a new UI within those other products, or a new 'back-end' to work with your already built UI?
I'm building a single app. I picture a Home/Enterprise type of arrangement. The product would ship with the ZCDBs and a recommendation that security and robustness would be increased by installing an enterprise RBDM (MySQL). I'm thinking that I can do this in a single software package. Maybe I'll detect which DB is connected by which queries fail and select from a set of queries based on the result of that (50% thinking, 50% talking, 50% action).
Oct 14 '07 #5
Scott Price
1,384 Expert 1GB
First of all, let me say that I do not envy you at all!!

I'd have to think a bit on the rest of it... *Thinking out loud* Can you configure your install process to capture which version of the DB engine that the end-user chooses? OIC... Hmmm, Zero Configuration would mean the end-user doesn't get to look at/choose from any options.

I'd say the customer is more nuts than the developer :-)

Regards,
Scott
Oct 14 '07 #6
bartonc
6,596 Expert 4TB
First of all, let me say that I do not envy you at all!!

I'd have to think a bit on the rest of it... *Thinking out loud* Can you configure your install process to capture which version of the DB engine that the end-user chooses? OIC... Hmmm, Zero Configuration would mean the end-user doesn't get to look at/choose from any options.

I'd say the customer is more nuts than the developer :-)

Regards,
Scott
Thanks, Scott. I appreciate the input.

And I like your idea: The install process would (once I no longer do it by hand) be allowed to do some configuration.
When I speak of "zero config", I'm talking about all the database administration issues: How many users? Passwords. Buffer sizes? Backup!, etc. that are generally dealt with by someone who has at least some idea of what it take to be a DBA.
Oct 14 '07 #7
Scott Price
1,384 Expert 1GB
Thanks, Scott. I appreciate the input.

And I like your idea: The install process would (once I no longer do it by hand) be allowed to do some configuration.
When I speak of "zero config", I'm talking about all the database administration issues: How many users? Passwords. Buffer sizes? Backup!, etc. that are generally dealt with by someone who has at least some idea of what it take to be a DBA.
Gotcha.. I was a little confuzzled about what you were meaning by that.

Good luck on the rest of it :-)

Regards,
Scott
Oct 14 '07 #8
bartonc
6,596 Expert 4TB
Gotcha.. I was a little confuzzled about what you were meaning by that.

Good luck on the rest of it :-)

Regards,
Scott
In the heart of it as we speak. Now I remember what my struggle was yesterday:
All the ODBC drivers return slightly different error message formats. So, for now, I'm just throwing the raw message up instead of formatting it nicely.

Hmmm. I'll have to let that one brew a little longer.
Oct 14 '07 #9
MMcCarthy
14,534 Expert Mod 8TB
In the heart of it as we speak. Now I remember what my struggle was yesterday:
All the ODBC drivers return slightly different error message formats. So, for now, I'm just throwing the raw message up instead of formatting it nicely.

Hmmm. I'll have to let that one brew a little longer.
LOL

No sure how you're going to solve that one. Unless they all use the same error code numbers.
Oct 14 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by democratix | last post: by
2 posts views Thread by Chloe Crowder | last post: by
9 posts views Thread by Fresh Air Rider | last post: by
9 posts views Thread by Wayne Smith | last post: by
8 posts views Thread by situ | last post: by
8 posts views Thread by mouac01 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by Gurmeet2796 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.