Hi; A recently retired programmer has taken me under his wing and we're bidding a government contract together. His background is low-level languages and databases whereas I'll be doing the high-level stuff and the Internet applications. The job involves building an intranet that must be secure and an extranet: both of which access common records through a database (probably MySQL). This is for the Department of Motor Vehicles (DMV). My partner was running out of town when he grabbed me to tell me about this, so I only jotted down what was essential for my involvement. It includes: * Ability to pay for any traffic violation online * Fee-based title record search * Ability to view/print records of past transactions * Ability to print official receipts online * Provide online registration approval and payment * Ability to change profile information * Ability to request personal DMV driving record * Ability to support multiple languages * Make online appointment schedules * Renew driver's license online * Capable of efficiently handling millions of records It also includes the ability for law enforcement officials to access records, communicate the same to the court via VPN, etc. My question is, is Zope the appropriate vehicle (forgive pun) for such a project? TIA, beno
I have built a similar app ( secure intranet + extranet ) with Zope and MySQL, but your hit rates are likely to be much higher than what I see. So Sybase or Oracle may be a better choice for you - if that is prohibitive from a cost viewpoint try Postgres or MySQL with one of the transactional storages(innoDB ...) although I have not used either and have no real world data on transactional storages in MySQL. Zope will definitely make the app development part of the job much faster and simpler. - not sure about the "ability to support multiple languages" part - I do know that more recent versions of Python have been Unicode aware. Nitin Borwankar -- Statistics show that most people are in the majority, while fewer are in the minority Nitin Borwankar nitin@borwankar.com beno wrote:
Hi; A recently retired programmer has taken me under his wing and we're bidding a government contract together. His background is low-level languages and databases whereas I'll be doing the high-level stuff and the Internet applications. The job involves building an intranet that must be secure and an extranet: both of which access common records through a database (probably MySQL). This is for the Department of Motor Vehicles (DMV). My partner was running out of town when he grabbed me to tell me about this, so I only jotted down what was essential for my involvement. It includes:
* Ability to pay for any traffic violation online * Fee-based title record search * Ability to view/print records of past transactions * Ability to print official receipts online * Provide online registration approval and payment * Ability to change profile information * Ability to request personal DMV driving record * Ability to support multiple languages * Make online appointment schedules * Renew driver's license online * Capable of efficiently handling millions of records
It also includes the ability for law enforcement officials to access records, communicate the same to the court via VPN, etc. My question is, is Zope the appropriate vehicle (forgive pun) for such a project? TIA, beno
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
nitin@borwankar.com schrieb:
So Sybase or Oracle may be a better choice for you - if that is prohibitive from a cost viewpoint try Postgres or MySQL with one of the transactional storages(innoDB ...) although I have not used either and have no real world data on transactional storages in MySQL.
I have, in a small scale (my master thesis), and what I experienced so far looks good; I'd recommend InnoDB if it has to be MySQL, it handles transactions, foreign keys and locks very well. But if the amount of data is going to be *really* huge, you (beno) should also have a look at Oracle or other commercial DBMS which are supported reliably by Zope. Probably they aren't faster (MySQL surely is optimized for speed, at least on small/medium sized DBs) but IMHO it can handle large DBs better and has possibilities for clustering. For futher planning, urgently try to get figures (working hours, cost, amount of data, data flow-through and so on), and if they are only rough estimations in the first phase of analyzing! This will help you to get the right point of view on the requirements ot your app... Martin
nitin@borwankar.com wrote Zope will definitely make the app development part of the job much faster and simpler. - not sure about the "ability to support multiple languages" part - I do know that more recent versions of Python have been Unicode aware.
There's a number of different approaches available to do multilingual in Zope - e.g. ZBabel. Anthony, who wrote his own before ZBabel was done :-/ -- Anthony Baxter <anthony@interlink.com.au> It's never too late to have a happy childhood.
At 04:43 PM 1/15/2003 -0800, you wrote:
I have built a similar app ( secure intranet + extranet ) with Zope and MySQL, but your hit rates are likely to be much higher than what I see. So Sybase or Oracle may be a better choice for you - if that is prohibitive from a cost viewpoint try Postgres or MySQL with one of the transactional storages(innoDB ...) although I have not used either and have no real world data on transactional storages in MySQL.
Hmm. I've heard excellent results about the scalability of MySQL. Perhaps I'll put out a feeler there.
Zope will definitely make the app development part of the job much faster and simpler.
That's what I thought too. Thanks for the confirmation.
- not sure about the "ability to support multiple languages" part
Nor are we, actually! I'm proposing we write the whole thing in XML. That way, we can easily write XSLT stylesheets for whatever purpose, including *to support multiple languages*. Thanks ;) beno
so what i am reading is that you are bidding on a contract yet you don't have any idea what it is that you are building or what tools you are going to use? that sounds like a recipe for disaster to me... you are asking questions that should have been answered long before bidding on this contract. jens On Wednesday, Jan 15, 2003, at 19:18 US/Eastern, beno wrote:
Hi; A recently retired programmer has taken me under his wing and we're bidding a government contract together. His background is low-level languages and databases whereas I'll be doing the high-level stuff and the Internet applications. The job involves building an intranet that must be secure and an extranet: both of which access common records through a database (probably MySQL). This is for the Department of Motor Vehicles (DMV). My partner was running out of town when he grabbed me to tell me about this, so I only jotted down what was essential for my involvement. It includes:
* Ability to pay for any traffic violation online * Fee-based title record search * Ability to view/print records of past transactions * Ability to print official receipts online * Provide online registration approval and payment * Ability to change profile information * Ability to request personal DMV driving record * Ability to support multiple languages * Make online appointment schedules * Renew driver's license online * Capable of efficiently handling millions of records
It also includes the ability for law enforcement officials to access records, communicate the same to the court via VPN, etc. My question is, is Zope the appropriate vehicle (forgive pun) for such a project? TIA, beno
At 08:02 AM 1/16/2003 -0500, you wrote:
so what i am reading is that you are bidding on a contract yet you don't have any idea what it is that you are building or what tools you are going to use? that sounds like a recipe for disaster to me... you are asking questions that should have been answered long before bidding on this contract.
Hmm. Well, let's put it this way. The guy who's taking me under his wing in this process wrote the original code we'll be replacing, was in charge of the programming for the whole department, and just recently retired. *He's* leading, thank you. As far as what tools we're going to use, I assume you give this some consideration before you jump in, don't you? Well, I am no different. Actually, the *recipe for disaster* would be to do the contrary, would it not? We have not yet bid on the contract. Now, would you care to address the question? Here it is again: A recently retired programmer has taken me under his wing and we're bidding a government contract together. His background is low-level languages and databases whereas I'll be doing the high-level stuff and the Internet applications. The job involves building an intranet that must be secure and an extranet: both of which access common records through a database (probably MySQL). This is for the Department of Motor Vehicles (DMV). My partner was running out of town when he grabbed me to tell me about this, so I only jotted down what was essential for my involvement. It includes: * Ability to pay for any traffic violation online * Fee-based title record search * Ability to view/print records of past transactions * Ability to print official receipts online * Provide online registration approval and payment * Ability to change profile information * Ability to request personal DMV driving record * Ability to support multiple languages * Make online appointment schedules * Renew driver's license online * Capable of efficiently handling millions of records It also includes the ability for law enforcement officials to access records, communicate the same to the court via VPN, etc. My question is, is Zope the appropriate vehicle (forgive pun) for such a project? TIA, beno
participants (5)
-
Anthony Baxter -
beno -
Jens Vagelpohl -
Martin Gebert -
nitin@borwankar.com