Jump to content

Markus Kinzler

Moderators
  • Content Count

    568
  • Joined

  • Last visited

  • Days Won

    8

Posts posted by Markus Kinzler


  1. 37 minutes ago, Arnaud Bouchez said:

    @dummzeuch The feature matrix (page 18ff) states that FireDAC is not in CE - see "Windows/Mac enterprise database support, including MySQL, MariaDB, Microsoft SQL Server, Oracle Database, InterBase, PostgreSQL, Informix, Sybase SQL Anywhere, Microsoft Access, IBM DB2 Server, Firebird, Advantage Database, generic ODBC driver" is not checked, and also MongoDB, most/some WebBroker and DBExpress features, DataSnap and RadServer. 

    This features are missing in Pro, too. That was the fact Thomas wanted to tell you. You can access the DBMS locally but not on a "external" server (other than the machine the program is running).


  2. Quote

    turns SQLite into a real multi-user DBMS 

    Then multible users can access the db at the same time. But I wouldn't call this real muti user.

    Quote


    Advises for using an ORM - only use ORM (Object-Relation Mapping) for the simple CRUD part, but don't map your entire data model into a ORM. Doing the latter is the root cause of all complains about ORM from all the Java, C# and Delphi programmers.

     

    Especially when using a "simulated" multi user system. A DBMS server offers more than just the possibillity to access a db simultaneously. The overhead for the ORM depends on the ORM also.


  3. SQLite is great for single user or on mobile devices. But I prefer FireBird, because it's more powerful an scalable (embedded for single user; Server for multiuser; database file is interchangable).

     

    Is this the project you talking about? Look at the MARS samples. You will also find examples for database access.


  4. @Rudy Velthuis I think you misunderstood me. My concern are only about the automatic invocation.

    Quote

     

    The huge difference between this new constructor and what was previously available for records is the automatic invocation. In fact if you write something like:

    
    procedure TForm5.btnMyRecordClick(Sender: TObject);
    var
      my1: TMyRecord;
    begin
      Log (my1.Value.ToString);
    end;
    

    you’ll end up invoking both the default constructor and the destructor, and you’ll end up with a try-finally block generated by the compiler for your managed record instance.

     

     

×