v0.15.1

SQLPage is a small web server that renders your SQL queries as beautiful interactive websites. This releases brings exciting features that should make development even easier, faster, and more secure. Let's dive into the exciting innovations of version 0.15.1:

What's new ?

Forms

• Many improvements in the form component
  • Multiple form fields can now be aligned on the same line using the width attribute.
  • A reset button can now be added to the form using the reset top-level attribute.
  • The submit button can now be customized, and can be removed completely, which is useful to create multiple submit buttons that submit the form to different targets.
• Support form submission using the button component using its new form property. This allows you to create a form with multiple submit buttons that submit the form to different targets.

Maps

• Custom icons and colors for markers in the map component.
• Add support for GeoJSON in the map component. This makes it much more generic and allows you to display any kind of geographic data, including areas, on a map very easily. This plays nicely with PostGIS and Spatialite which can return GeoJSON directly from SQL queries.

Bug fixes

• Support non-string values in markdown fields. NULL values are now displayed as empty strings, numeric values are displayed as strings, booleans as true or false, and arrays as lines of text. This avoids the need to cast values to strings in SQL queries.
• Revert a change introduced in v0.15.0:
  • Re-add the systematic CAST(? AS TEXT) around variables, which helps the database know which type it is dealing with in advance. This fixes a regression in 0.15 where some SQLite websites were broken because of missing affinity information. In SQLite '1' = 1 is false but CAST('1' AS TEXT) = 1 is true. This also fixes error messages like could not determine data type of parameter $1 in PostgreSQL.
• Fix a bug where cookie removal set the cookie value to the empty string instead of removing the cookie completely.