Skip to content

v0.3.0 - September release 2016
Compare
Choose a tag to compare
@thyb thyb released this 06 Oct 23:10
· 18 commits to master since this release
0.3.0
80675bf

We're happy to introduce some core database features included in the September release :

MySQL Support

You can now connect your Materia application to a MySQL database.

image

We're excited to now handle these 3 Relational Database Management System which cover most use cases: MySQL, PostgreSQL and SQLite

New JSON display mode for inspect your query results

Sometimes the table display mode is not enough to really understand the result of a query, especially for queries containing lots of columns. For this very reason, we're excited to introduce a new JSON display mode which helps understand your data and how you will access them in your front-end.

json-display

Relation support in the query builder

Unleash the power of relational database using JOIN queries directly within the Query Builder !

Look how easy I can access my data :

relation

Relation support in the query builder is one of our greatest improvement this month and enable so many new things directly in the editor without having to write your own Javascript/SQL query.

Since this new version, you can select in your queries (bellow your fields) the entities associated to the selected entity to access their data and make complex queries.

Ordering queries

You can now order the results of the FindAll queries like the ORDER BY statement in SQL.

order-by2

The default query list is now ordered by the primary key.

We're stopping our support for the magic fields createdAt and updatedAt

As you could see in the previous animations, these 2 fields: createdAt and updatedAt are not present anymore !

We were adding magic fields behind the scene (createdAt and updatedAt) to know basic information like when the row was created and when the row has been updated for the last time. We felt it was a bit disturbing for new users and we stop supporting them anymore. When you'll upgrade to v0.3, Materia Designer will ask you to sync your application with the database to remove these fields.

Lots of bug fixes and little improvements

  • Fix - Windows: New files were not added to the file tree in Overview (#40)
  • Add: Ask for confirmation when leaving an edited file without save (#53)
  • Fix: rename field related to a relationship (#52)
  • Fix: New entity, query, endpoint and files are now indexed in the search engine (#44)
  • Fix: Lots of remove action wasn't asking for confirmation - now they do (#26)
  • Add: Files are now indexed in the search engine (#45)
  • Fix: Clean the console of warnings (#22)
  • Fix: Help menu (#41)
  • Fix: Windows 32bit version

We hope you'll enjoy the September release as we've enjoyed to release this version to you ! Be prepared, the next monthly release will be massive !

Assets 5
Loading