BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  middleware for mysql          BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (General) View previous topic :: View next topic   Author Message Bob D. Guest Posted: Mon May 21, 2007 4:16 am    Post subject: middleware for mysql Hello, I have a server application that connects to a mysql server and a client software that connects to server and exchange data using TCP/IP. what I want is to directly execute mysql queries like SELECT * FROM .... from client. Means: CLIENT -> connects -> SERVER -> connects -> MYSQL instead of CLIENT -> connects -> MYSQL I'm using CrLab MyDac components. Does anyone done something similar? Or any idea how can I create such thing? Thanks! Back to top Matt Harward Guest Posted: Mon May 21, 2007 7:28 am    Post subject: Re: middleware for mysql Bob D. wrote: Quote: Hello, I have a server application that connects to a mysql server and a client software that connects to server and exchange data using TCP/IP. what I want is to directly execute mysql queries like SELECT * FROM .... from client. Means: CLIENT -> connects -> SERVER -> connects -> MYSQL instead of CLIENT -> connects -> MYSQL I'm using CrLab MyDac components. Does anyone done something similar? Or any idea how can I create such thing? Thanks! I own 4 component sets that would do what you want... Asta: I wouldn't recommend this anymore. It's kind of the grandfather of middleware in the Delphi space. They've branched off into a bunch of other technologies and, imo, the core Asta middleware product hasn't kept up with the competition (understatement). www.astatech.com. RTC (Real Thin Client): Author is very active in the forums and developing the RTC components. Good remoting capabilities and now offers support for a data access tier through a third party (which I haven't tried). Very good component set... but not my first choice for what you want to do. www.realthinclient.com. kbmMW: You should get a lot of good feedback from users recommending this one. It's another very good product with active support. Focuses on middleware data servers. It's good enough (and has a stellar reputation) that I've kept my license current since the very first beta. Still not my first choice... but you wouldn't go wrong selecting it. Very flexible pricing to fit a variety of needs (including, I believe, no-cost licenses). Extensive database and platform support (definitely one of it's strong points), including .net. www.components4developers.com. RemObjects: Far and away my favorite tools for n-tiered development in Delphi. Excellent object model that works exactly how I think. I think this is the most Delphi-like implementation available. This is another one that I've been with since before the first release. It's an outstanding product that's not only very accessible for beginners, but offers superb enterprise-level functionality as well. I use it all the time with MySQL and MyDAC (native support for MyDAC). The downside is it's pricier than the others. In my case, it's worth it. Imo, hands down, the best Delphi middle-tier implementation. Extensive database support and excellent .net support. www.remobjects.com. Hope this helps, Matt Harward Back to top Tony Caduto Guest Posted: Mon May 21, 2007 8:05 am    Post subject: Re: middleware for mysql Matt Harward wrote: Quote: I own 4 component sets that would do what you want... Depending on how complex the queries are you could easily roll your own middleware server using any good TCP/IP library like Synpase or even Indy. You would simply send the query to the middle server from the client using the sendstring/writestring(depending on tcp/ip library) and then send the data back to the client. You could send it back as XML or even as a simple tstringlist commatext and then load it into any type of dataset you wanted on the client side. I created a full featured IM client/server setup this way and it worked great. I first used Firebird as the database the middle server talked to then moved to PostgreSQL and it was a simple matter(took about 1 hour) of replacing the Firebird components(IBO) with PostgreSQL ones (Zeos) Later, -- Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL and MySQL http://www.amsoftwaredesign.com Back to top Mike Orriss Guest Posted: Mon May 21, 2007 8:12 am    Post subject: Re: middleware for mysql Matt Harward wrote: Quote: I use it all the time with MySQL and MyDAC (native support for MyDAC). The downside is it's pricier than the others. In my case, it's worth it. Imo, hands down, the best Delphi middle-tier implementation. Extensive database support and excellent .net support. www.remobjects.com. Thanks for those kind words. Very good to see at a time when the whole company is in overdrive to ship Data Abstract 'Vinci' (our latest and greatest) next month. See the Vinci entries (10 as I write) in blogs.remobjects.com/blogs for previews of a few of the new and updated features. -- Mike Orriss General Project Manager www.remobject.com Back to top Bob D. Guest Posted: Mon May 21, 2007 8:12 am    Post subject: Re: middleware for mysql Sorry, but ThinDAC requires RTC SDK? Im confused Thanks "Dmitry Arefiev" <darefiev@da-soft.com> wrote in message news:4651233e (AT) newsgroups (DOT) borland.com... Quote: Hello Bob CLIENT -> connects -> SERVER -> connects -> MYSQL You can consider to use ThinDAC. From readme: "ThinDAC" is a component library for CodeGear Delphi and C++ Builder, allowing to build N-tier data handling applications. "ThinDAC" is built on top of "RealThinClient SDK" and "AnyDAC". "RealThinClient SDK" is used as a middleware framework. "AnyDAC" is used at client side, as a base for "ThinDAC" client dataset. Actually, ThinDAC will perform exactly what you need. And it is simple, fast and reliable. And you can consider to use AnyDAC at server side, and use the same skill at client and server sides. Regards, Dmitry -- Dmitry Arefiev - www.da-soft.com AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase ASA, DbExpress, ODBC freeware data access engine ThinDAC - multitier data access engine Back to top Bob D. Guest Posted: Mon May 21, 2007 8:12 am    Post subject: Re: middleware for mysql Not really, very complex queries and I want to handle and display them directly in grids. The model you say is the current implementation and it is painful to maintain it. Thanks anyway :) "Tony Caduto" <tony.caduto@gmail_dot_com> wrote in message news:46510c65$1 (AT) newsgroups (DOT) borland.com... Quote: Matt Harward wrote: I own 4 component sets that would do what you want... Depending on how complex the queries are you could easily roll your own middleware server using any good TCP/IP library like Synpase or even Indy. You would simply send the query to the middle server from the client using the sendstring/writestring(depending on tcp/ip library) and then send the data back to the client. You could send it back as XML or even as a simple tstringlist commatext and then load it into any type of dataset you wanted on the client side. I created a full featured IM client/server setup this way and it worked great. I first used Firebird as the database the middle server talked to then moved to PostgreSQL and it was a simple matter(took about 1 hour) of replacing the Firebird components(IBO) with PostgreSQL ones (Zeos) Later, -- Tony Caduto AM Software Design Home of Lightning Admin for PostgreSQL and MySQL http://www.amsoftwaredesign.com Back to top Dmitry Arefiev Guest Posted: Mon May 21, 2007 8:12 am    Post subject: Re: middleware for mysql Hello Bob Quote: CLIENT -> connects -> SERVER -> connects -> MYSQL You can consider to use ThinDAC. From readme: "ThinDAC" is a component library for CodeGear Delphi and C++ Builder, allowing to build N-tier data handling applications. "ThinDAC" is built on top of "RealThinClient SDK" and "AnyDAC". "RealThinClient SDK" is used as a middleware framework. "AnyDAC" is used at client side, as a base for "ThinDAC" client dataset. Actually, ThinDAC will perform exactly what you need. And it is simple, fast and reliable. And you can consider to use AnyDAC at server side, and use the same skill at client and server sides. Regards, Dmitry -- Dmitry Arefiev - www.da-soft.com AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase ASA, DbExpress, ODBC freeware data access engine ThinDAC - multitier data access engine Back to top Bob D. Guest Posted: Mon May 21, 2007 8:12 am    Post subject: Re: middleware for mysql Very very helpful! Thanks :D "Matt Harward" <mharward (AT) phatrock (DOT) com> wrote in message news:465103e2$1 (AT) newsgroups (DOT) borland.com... Quote: Bob D. wrote: Hello, I have a server application that connects to a mysql server and a client software that connects to server and exchange data using TCP/IP. what I want is to directly execute mysql queries like SELECT * FROM .... from client. Means: CLIENT -> connects -> SERVER -> connects -> MYSQL instead of CLIENT -> connects -> MYSQL I'm using CrLab MyDac components. Does anyone done something similar? Or any idea how can I create such thing? Thanks! I own 4 component sets that would do what you want... Asta: I wouldn't recommend this anymore. It's kind of the grandfather of middleware in the Delphi space. They've branched off into a bunch of other technologies and, imo, the core Asta middleware product hasn't kept up with the competition (understatement). www.astatech.com. RTC (Real Thin Client): Author is very active in the forums and developing the RTC components. Good remoting capabilities and now offers support for a data access tier through a third party (which I haven't tried). Very good component set... but not my first choice for what you want to do. www.realthinclient.com. kbmMW: You should get a lot of good feedback from users recommending this one. It's another very good product with active support. Focuses on middleware data servers. It's good enough (and has a stellar reputation) that I've kept my license current since the very first beta. Still not my first choice... but you wouldn't go wrong selecting it. Very flexible pricing to fit a variety of needs (including, I believe, no-cost licenses). Extensive database and platform support (definitely one of it's strong points), including .net. www.components4developers.com. RemObjects: Far and away my favorite tools for n-tiered development in Delphi. Excellent object model that works exactly how I think. I think this is the most Delphi-like implementation available. This is another one that I've been with since before the first release. It's an outstanding product that's not only very accessible for beginners, but offers superb enterprise-level functionality as well. I use it all the time with MySQL and MyDAC (native support for MyDAC). The downside is it's pricier than the others. In my case, it's worth it. Imo, hands down, the best Delphi middle-tier implementation. Extensive database support and excellent .net support. www.remobjects.com. Hope this helps, Matt Harward Back to top marc hoffman Guest Posted: Mon May 21, 2007 10:03 pm    Post subject: Re: middleware for mysql Bob, Quote: Maybe you can ship different versions with different options for all kind of needs? That's certainly not a bad idea, and something we'll consider - thanx for the suggestion. In the mean-time, why don't you drop me a mail to sales (AT) remobjects (DOT) com, and i'll see what we can work out, based on your needs? Yours, -- marc hoffman Chief Architect RemObjects Software http://www.remobjects.com and the fifty-two daughters of the revolution turn the gold to chrome Back to top Danijel Tkalcec Guest Posted: Tue May 22, 2007 4:43 am    Post subject: Re: middleware for mysql Bob D. wrote: Quote: Sorry, but ThinDAC requires RTC SDK? Im confused ThinDAC extends the RealThinClient SDK with DataSet descendant components for the Client side and "drivers" for a variety of direct database access components on the Server side, building a "missing link" between your database and your clients. IOW, ThinDAC is a database layer for the RealThinClient SDK. Anyone who plans to use the RealThinClient SDK for developing applications which require direct database access (client showing a dataset with editable rows from the server), should consider getting a ThinDAC license. It will considerably reduce your development time. Best Regards, Danijel Tkalcec, Team RTC http://www.realthinclient.com Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Thirdparty Tools (General) All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.