Need suggestions

Post #231,079 by jbrabeck 10/26/05 6:24:51 PM Reply	Need suggestions County client has Paradox application that should (imho) be moved to something else. Moved because the app (I wrote it) is beginning to show its age, and is restricted to running on Windows. Means I have my work cut out. I would like the app to be browser based with SQL tables (using Paradox terminology). I have never written a browser based app, and I have not used SQL databases. Main reason client likes Paradox is because he can perform his own queries and extract reports however he wants, whenever he wants. In fact, my app has only a handful of monthly reports, the rest are adhoc reports. Current structure is client, admissions, insurance, payments, and comments with many lookup tables for Client, Admits, Ins, and Payments. And a lot of convaluted rules. Using Paradox tabbed interface with 7 tabs. Oh, and this is a multi user app, with up to 10 users on at any given time. Which SQL database would work AND be easy for me to learn, and be able to show client how to perform adhoc reporting? What browser app tool? Database is currently on a Novell server. Client is looking to move to Linux. Any and all suggestions are appreciated. TIA Joe A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"
Post #231,083 by boxley 10/26/05 7:00:57 PM Reply	something like this? [link\|http://www.freemed.info/freemed/main.php\|http://www.freemed.info/freemed/main.php] thanx, bill "the reason people don't buy conspiracy theories is that they think conspiracy means everyone is on the same program. Thats not how it works. Everybody has a different program. They just all want the same guy dead. Socrates was a gadfly, but I bet he took time out to screw somebodies wife" Gus Vitelli Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org]
Post #231,152 by jbrabeck 10/27/05 10:18:58 AM 10/27/05 10:19:19 AM Reply	Good start But my client is the county detox. The "clients" are admitted, many times more than once. Billing is made to either client's insurance company or to the county making the referral. Rates are either daily or hourly, itemized or summarized, and based upon whether insurance co or county, with different rates for each county. And that's just scratching the surface for information that's tracked. But I'd like something like the FreeMed web site. A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!" Edited by jbrabeck Oct. 27, 2005, 10:19:19 AM EDT Expand All History
Post #231,186 by boxley 10/27/05 12:59:13 PM Reply	hmm, ok another link [link\|http://www.care2x.org/\|http://www.care2x.org/] and another [link\|http://www.tucows.com/preview/332670\|http://www.tucows.com/preview/332670] only joking sheesh thanx, bill "the reason people don't buy conspiracy theories is that they think conspiracy means everyone is on the same program. Thats not how it works. Everybody has a different program. They just all want the same guy dead. Socrates was a gadfly, but I bet he took time out to screw somebodies wife" Gus Vitelli Any opinions expressed by me are mine alone, posted from my home computer, on my own time as a free american and do not reflect the opinions of any person or company that I have had professional relations with in the past 49 years. meep questions, help? [link\|mailto:pappas@catholic.org\|email pappas at catholic.org]
Post #231,259 by jbrabeck 10/27/05 11:01:05 PM Reply	I'll have to send the 2d link to client. He'd like it. A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"
Post #231,084 by Steve Lowe 10/26/05 7:05:23 PM Reply	LAMP Linux, Apache, MySQL, PHP\|Perl\|Python [link\|http://www.onlamp.com/\|http://www.onlamp.com/] [link\|http://en.wikipedia.org/wiki/LAMP_%28software_bundle%29\|http://en.wikipedia....oftware_bundle%29] :) -- Steve [link\|http://www.ubuntulinux.org\|Ubuntu]
Post #231,103 by tuberculosis 10/26/05 10:30:29 PM Reply	PostgreSQL You know you're soaking in it. [link\|http://www.postgres.org\|http://www.postgres.org] "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush
Post #231,106 by broomberg 10/26/05 10:44:35 PM Reply	Agreed Much better than MySQL. Syntax is much closer to Oracle, the industry standard, so it is a great place to learn. On the other hand, all kinds of goodies if you don't care about porting your code later on.
Post #231,154 by folkert 10/27/05 10:47:28 AM 10/27/05 11:36:42 AM Reply	Postgresql also has much better (err damn my brain!) function support to "emulate" Column triggers. Needless to say, LAMP should LAPP. ( Linux, Apache, PostgresQL, [ Perl \| Python \| PHP ] ) -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* Freedom is not FREE. Yeah, but 10s of Trillions of US Dollars? SELECT * FROM scog WHERE ethics > 0; 0 rows returned. Edited by folkert Oct. 27, 2005, 11:36:42 AM EDT Expand All History
Post #231,158 by drewk 10/27/05 11:20:40 AM Reply	Anyone looked at MySQL 5 yet? Just saw the announcement about it. Looks like they just added a lot of the big stuff. Wonder how it's going to compare to Postgres now. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #231,167 by folkert 10/27/05 11:39:53 AM Reply	I have done the "build it and they will die" Routine with MySQL5. It's not ready, still. I couldn't connect to it properly with older tools. Though I wasn't really trying that hard. I guess I come from "the existing working implementations, should still work after an upgrade" camp. But then, I also like to break things. -- [link\|mailto:greg@gregfolkert.net\|greg], [link\|http://www.iwethey.org/ed_curry\|REMEMBER ED CURRY!] @ *i_wethey* Freedom is not FREE. Yeah, but 10s of Trillions of US Dollars? SELECT * FROM scog WHERE ethics > 0; 0 rows returned.
Post #231,169 by broomberg 10/27/05 11:59:07 AM Reply	I think MySQL has the same attiude that MS has on software Whip something up. Seems to work. Get it out there. Hype the speed. Get users to try stuff. Get users who don't know any better to be wowed. Get complaints from knowledgeable users who are familier with other systems. Try to steal features from other systems. Realize that the new features are incompatible with the old features, and decide to partially implement the new features in an attempt not to break the old features. Fuck it up. Break the old while not providing the new. Scramble. Pull out the new, attempt to put the old back in. Declare the old baseline as the standard, and ignore the rest as long as possible. Repeat the cycle. Remember, MySQL is a commercial entity 1st, and is market driven. Postgres is more of a well designed academic exercise that has spawned several commercial spin-offs. Things get put in because they are good to have, not because that satisfy a marketing need. So it is developed in a steady non-rushed fashion. Features "feel" right. It always has very high-end capabilities (log based hot-backup, moment in time queries satisfied against the log, not the changing data, etc) that blew away MySQL, and the SQL dialect done not end up surprising Oracle users, since they seems to have developed almost in tandem. And now there is a vendor that took that Oracle aspect a bit further, and is attempting an almost complete emulation, ie: [link\|http://www.enterprisedb.com/\|http://www.enterprisedb.com/]. I'd suggest taking a look at it if you are an Oracle/Postgres fan.
Post #231,170 by drewk 10/27/05 12:10:35 PM Reply	Biggest thing I wanted from Postrgres that it didn't have Replication. MySQL has had master/slave replication working for several years at least. People kept posting white papers and proof-of-concept demos of multi-master replication for Postgres, but I've never seen anyone say it works for real. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #231,171 by broomberg 10/27/05 12:28:10 PM Reply	We have something working here Might be very specific to the users / tables involved. Not my project though, so I'm clueless.
Post #231,172 by broomberg 10/27/05 12:31:16 PM Reply	They claim it is in there, but no idea if it is correct for your usage. [link\|http://www.enterprisedb.com/edb-db.do\|http://www.enterprisedb.com/edb-db.do]
Post #231,201 by tuberculosis 10/27/05 1:50:47 PM Reply	Among other things, mysql isn't free as in beer. Also, 2 phase commit/mvcc support is recent and thus unproven IMO. "Whenever you find you are on the side of the majority, it is time to pause and reflect" --Mark Twain "The significant problems we face cannot be solved at the same level of thinking we were at when we created them." --Albert Einstein "This is still a dangerous world. It's a world of madmen and uncertainty and potential mental losses." --George W. Bush

Welcome to IWETHEY!