SQLite Database Fields

Databases are a critical part of most Web and WebApps. They have the ability to store and retrieve information. Thorium Builder's Database Widgets are designed to work easily with Web Project Databases and WebApps Project Databases.

Note that if your project is not selected as a Web Project With Database or WebApp With Database , as shown above, you will see no widgets listed in the Database Widget Area.

The Database Text Field Widget

The Database Text Field Widget is used to display textual data from the database. It is generally embedded in a Database Displayer Widget, but can also be embedded in a Database Repeater Widget.

When first dropped into the Page Editor, the Database Text Field Widget appears as above. The {text} will vary depending on what field of text you have chosen to display from the database. Double-click on the widget, to access its advanced properties.

Advanced Property Settings
...
Single Line (No Wrap)

If the text content is long, then you can choose between the 2 options:keep the field on one line (no wrap) or extend the field in order to display all the text.

Text Contents displayed as Web Links

If the field contains a Web address, select this button so that the field will automatically generate a web link from the text content.

Field Name

The name of the database field to be displayed. Database fields can be chosen from the standard field selections or you can define a custom field.

...

The Database Image Widget

The Database Image Field Widget is used to display an image from the database. It is generally embedded in a Database Displayer Widget, but can also be embedded in a Database Repeater Widget.

...

Double-click on the widget, to access its advanced properties.

Advanced Property Settings
Image display

The size of the container that will display the images is responsive (adjust with device screen size). A fixed display is the ratio between height and width. It is not responsive.

Display Ratio

The ratio can be from 1:1 (Square) to 21:9.

Show on Zoom

I am a lead If that option is selected, an Image Zoom page will popup when the user touches the image.

The Database Audio Widget

The Database Audio Widget is used to play audio files.

...

When first dropped into the Page Editor, the Database Audio Widget appears as above. Double-click on the widget, to access its advanced properties.

IMPORTANT:
The supported audio file formats at the time of this writing are:
 1. Ogg
 2. MP3
 3. AAC

Advanced Property Settings
Show Controls

If selected, the Audio player is shown with its controls as shown. (play, pause…)

When enabled, this option specifies that video controls should be displayed on the video player.

The Database Video Widget

The Database Video Widget is used to play video files.

Advanced Property Settings
Display Ratio

I am a lead The size of the container that will display the component is responsive with a fixed display ratio between height and width.The ratio can be from 1:1 (Square) to 21:9 (Wide).

Show Controls

When enabled, this option specifies that video controls should be displayed on the video player.

Auto Play

The video will automatically start the the web page loads.

Muted

When checked or ticked this option specifies that there will be no audio sound with the video.

The Database Map Widget

The Database Map Widget is used to display map locations.

...

When first dropped into the Page Editor, the Database Map Widget appears as above. Double click on the widget to open the Advanced Properties Window.

Advanced Property Settings
Display Ratio

The size of the container that will display the component is responsive with a fixed display ratio between height and width.The ratio can be from 1:1 (Square) to 21:9 (Wide).

View Mode

There are four options for View Mode:

  • 1. Terrain: show only the physical features of the land area of the map.

  • 2. Roadmap : show only the road map on the map.

  • 3. Satellite: Show only the satellite view.

  • 4. Satellite - hybrid: Show both the terrain and the roadmap.

Style

The Map field can be displayed using a number of styles as shown above.

Note that the Default setting doesn’t add any style to Google Map view.

Zoom Level

The Map Zoom Level slider allows you to set the amount of zoom that a user can zoom in/out on the map. The Zoom Level can be set from from zero (no zoom) to 18 (a large amount of zoom).

Copyright©  Nymphide Lab 2020 - All Rights Reserved 

...