References for FreePascal & Lazarus lazarus / 13-General ---------------------------------------------------------------------- mWaltari · 2007-12-10 12:23 Hello, Our Production Manager wants some kind of references, in which FP&L; is used. He does not believe that there is no big enough projects done with it. Specially he needs some kind of DB-application reference (handled DB- rows / day etc)... Does anyone have good references. -Tommi Prami- ---------------------------------------------------------------------- Marc · 2007-12-10 13:21 See http://www.freepascal.org/gallery.html and http://wiki.freepascal.org/Lazarus_Application_Gallery ---------------------------------------------------------------------- acakadut · 2007-12-10 13:27 maybe u can start in this http://wiki.lazarus.freepascal.org/Projects_using_Lazarus ---------------------------------------------------------------------- bee · 2007-12-11 04:33 I had built a web based application (CGI-based) using FPC, Laz, and PWU. The application receives xls files from users, save them to mySQL database, and generate some kind of report and analysist. For xls file handling, I'm using modified FlexCel from TMS. Currently, the application serves 442 users with concurrent hits about 200-300 users. The database now grows up to 50 million records. The server machine using Linux (FC4) with Apache. Until this second, it all runs well. ---------------------------------------------------------------------- antonio · 2007-12-11 12:00 Siages, an ERP application, http://siages.solis.coop.br/ . I have some small projects, like LazPad, http://br.geocities.com/antoniog123456/ . ---------------------------------------------------------------------- piper62 · 2007-12-13 01:30 Hi, we have a hospital information system developed with FPC/Lazarus and ZeosLib. This runs very well and holds at the moment for the first hospital 50.000 person base data with approx. 3.5 Million records of medical data. I can't provide benchmark information at the moment but I can say this: I decided to make a re-design of a web based hospital information system which was developed in PHP/Javascript because it was much to complicated to maintain it. We could do with a team of 3 developers over 75% of the functionality of the old system (development time over three years) within 7 months! And the code is readable and maintainable!!! Regards, Tibor ---------------------------------------------------------------------- tatamata · 2007-12-13 15:02 I finished a program for production planning and optimization, it will be published  on internet soon. The program imports data about products, bills of materials, orders and material stocks from ERP systems such as SAP R/3 and get you tools for interactive simulation of production orders, materials shortages etc. You can play with bills of materials, materials stocks etc adn immidiately see what you can produce and what you can't produce and why. It enables interactive simulation of different production scenarios. It is intended to boost production planning in dynamic manufacturing companies that have lot of products, small batches, often change production schedules and priorities or have other problems with production planning on daily basis. It is accomplished with Lazarus/Firebird embedded/ZeosLib. Regards, Zlatko ---------------------------------------------------------------------- Phil · 2007-12-13 18:52 Quote from: "piper62"I decided to make a re-design of a web based hospital information system which was developed in PHP/Javascript because it was much to complicated to maintain it. Tibor, Are you starting a counter-trend, moving from Web app to desktop app? Thanks. -Phil ---------------------------------------------------------------------- piper62 · 2007-12-13 22:08 Hi Phil, not in general but I see in the area where I work a re-thinking about the requirements and the mid-/long-term maintainance and costs. And also the usability of the software. From my experience in the health information science field and the pharmaceutical industry there are a lot of systems where we have no need for strict web-based applications. The efforts you have to do to get a similar functionality in a web-app compared to a desktop-app, especially developed with a system like lazarus are extremely high. We had the problem with our hospital information system, it was not maintainable any more! Not to speak about th catastrophic situation with the different and every time changing features of the webbrowsers... I only say "Javascript". We have a module for dynamic formdesign where the users can design their own database connected forms. This works with drag-n-drop but only in some browsers under some conditions... terrible! And the time to do something like that!!! With Lazarus something like this is a dream!!!!!!!!!! Now we make installations terminalserver based and we use normally Linux with FreeNX. With that we have also in larger installations with remote places no problems. Performs very well! And where is the difference: to have a webbrowser or to have the NXClient on the machine? But I get real desktop applications with all the features AND the development is much more efficient - as I think. I can't scientifically proof it at the moment ;-) So, at all if you see that as an counter-trend, then Yes! Regards, Tibor ---------------------------------------------------------------------- Phil · 2007-12-14 18:12 Quote from: "piper62"So, at all if you see that as an counter-trend, then Yes! Tibor, Have you looked at using VCL for PHP to create the user interface for a Web app? It has classes, properties and events that are very simiilar to VCL/LCL components. Works fine on my Mac with Apache: http://www.qadram.com/vcl4php/ Thanks. -Phil ---------------------------------------------------------------------- chrnobel · 2008-01-08 11:51 Hi Bee Quote from: "bee"I had built a web based application (CGI-based) using FPC, Laz, and PWU. The application receives xls files from users, save them to mySQL database, and generate some kind of report and analysist. For xls file handling, I'm using modified FlexCel from TMS. Currently, the application serves 442 users with concurrent hits about 200-300 users. The database now grows up to 50 million records. The server machine using Linux (FC4) with Apache. Until this second, it all runs well. Just out of curiosity - which hardware are you using? And do you use the SDS database for controlling the logged in users? /Christian ---------------------------------------------------------------------- ssamayoa · 2008-01-19 01:05 Quote from: "Phil" Have you looked at using VCL for PHP to create the user interface for a Web app? It has classes, properties and events that are very simiilar to VCL/LCL components. Works fine on my Mac with Apache: I bought that piece of %&@! I expected a superb product (I have 7+ years of experience with Java web technlogies 3 of then with JSF and 10+ with Delphi) but, for me, the product was a total disapointment. Regards. ---------------------------------------------------------------------- bee · 2008-01-19 03:10 @chrnobel: > Just out of curiosity - which hardware are you using? Just a Xeon 2.1 GHz with 1 GB memory, nothing special. > And do you use the SDS database for controlling the logged in users? Yes. ---------------------------------------------------------------------- Phil · 2008-01-19 14:17 Quote from: "ssamayoa"I expected a superb product (I have 7+ years of experience with Java web technlogies 3 of then with JSF and 10+ with Delphi) but, for me, the product was a total disapointment. Please tell us more about your experiences with Delphi for PHP. Had you ever used PHP before? What didn't you like about the product? Thanks. -Phil ---------------------------------------------------------------------- ssamayoa · 2008-01-19 18:32 Quote Please tell us more about your experiences with Delphi for PHP. Had you ever used PHP before? What didn't you like about the product? Nope, I never used PHP before. What I expected about d4php was something like JSF with the easy data access model of Delphi (dataset > datasource > ui) writen in php. In a nut shell: - No data conversion / validation (numeric, date, etc.) - No edit / display mask. - DB grid too primitive. - AJAX server events uses a lot of CPU. Regards. ---------------------------------------------------------------------- Phil · 2008-01-19 21:47 Quote from: "ssamayoa"[Nope, I never used PHP before. What I expected about d4php was something like JSF with the easy data access model of Delphi (dataset > datasource > ui) writen in php. In a nut shell: - No data conversion / validation (numeric, date, etc.) - No edit / display mask. - DB grid too primitive. - AJAX server events uses a lot of CPU. Seems like Delphi for PHP has the same data access model as Delphi Pascal. So, for example, a UI control such as a DBGrid has a DataSource property, which in turn has a DataSet property. Isn't that your "dataset > datasource > ui"? Please explain what "something like JSF" means. Thanks. -Phil