Synopse Open Source

2013-04-22

TDataSet... now I'm confused

By AB4327-GANDI, 2013-04-22. Pascal Programming

You perhaps know that I'm not a big fan of the TDataSet / RAD DB approach for end-user applications.
They are easy to define, almost no code to write, and you are able to publish a working solution very fast.

But it is a nightmare to debug and maintain. I prefer the new DataBinding feature, or... of course... ORM!
In mORMot, we have some auto-generated screens, and in our roadmap, we forcast to use some auto-binding features, using a KISS by-convention MVC pattern.

For some users, we made a ORM / TDataSet conversion unit.
And we discovered that TDataSet has a weird, and very misleading definition of its AsString property, for Unicode versions of Delphi.

2013-04-02

Two videos about EXTjs client of mORMot server

By AB4327-GANDI, 2013-04-02. Open Source › mORMot Framework

Two nice videos, posted by a framework user. The first one presents a remote RESTful access of a SQLite3 database, hosted by a mORMot server: After one post in the forum, warleyalex was able to easily add remote filtering of the request: In addition to the previous video about security (by which the […]

2013-03-28

Adding some generic-based methods to mORMot

By AB4327-GANDI, 2013-03-28. Open Source › mORMot Framework

We have just added a TSQLTable.ToObjectList<T: class>() method. I want to add some generics-based methods to mORMot, for newer versions of Delphi. What do you think of it? Have you some method prototypes to propose? My first concern is that FreePascal does not offer the same syntax. I suppose […]

2013-03-27

Introducing TSQLTable.Step() method

By AB4327-GANDI, 2013-03-27. Open Source › mORMot Framework

We have just added TSQLTable.Step(), FieldBuffer() and Field() methods, handling a cursor at TSQLTable level, with optional late-binding column access.

It allows to retrieve results from a TSQLTable / TSQLTableJSON result sets within a "cursor-like" orientation.
That is, no need to specify the row number, but write a simple while aList.Step do ... loop.

Of course, you should better use TSQLRecord.FillPrepare most of the time, and access the data from a TSQLRecord instance.
But it can be very useful, e.g. when working on a custom JOINed SQL statement.

2013-03-26

Delphi is just a perfect fit for the average programmer

By AB4327-GANDI, 2013-03-26. Pascal Programming

On the Embarcadero forums, some user did have a perfectly sane reaction, about a non obvious integer type cast like Int64Var := Int32Var*Int32Var, which may overflow.

We've got to stop becoming, as one poster put it, "human pre-compilers" for Delphi.
The compiler ought to have the common sense to not need the programmer to cast the two integer values.

I respectfully think just the opposite.
;)

Such a type cast is part of the language grammar.
If you know the grammar, you will know how it will be compiled.

To be honest, you have the same in all languages, with more or less range checking, optimization, and implicit conversion.
This is why I like Delphi: it can be mastered by any programmers, whereas truly mastering Java or .Net needs a genius.

Delphi is just... human...

2013-03-25

SynProject tool 1.18

By AB4327-GANDI, 2013-03-25. Open Source › SynProject documentation and versioning

We have uploaded an updatetd compiled version of our Open Source SynProject tool in SynProject.zip. Synopse SynProject is an open source application for code source versioning and automated documentation of software projects. Licensed under a GPL license. Main feature is a new (better-looking?) […]

2013-03-23

Download latest version of sqlite3.dll for Windows 64 bit

By AB4327-GANDI, 2013-03-23. Open Source › mORMot Framework

Update: We now build the amalgamation file with mingw and release the latest version of SQLite3, from this direct SQLite3-64.7z link, as soon as it is published on the SQLite3 site. Up to now, there is no official Win64 version of the SQlite3 library released in http://sqlite.org.. It is in fact […]

2013-03-13

x64 optimized asm of FillChar() and Move() for Win64

By AB4327-GANDI, 2013-03-13. Pascal Programming

We have included x64 optimized asm of FillChar() and Move() for Win64 - for corresponding compiler targets, i.e. Delphi XE2 and XE3. It will handle properly cache prefetch and appropriate SSE2 move instructions. The System.pas unit of Delphi RTL will be patched at startup, unless the NOX64PATCHRTL […]