June Newsletter Tip or Trick - TWO of them!

[cbenassi]

This month's Newsletter includes not one, but TWO tips! Servoy would like to thank Jose Ramos from Sybase iAnywhere for tip one: Personal Database Server vs. Network Database Server; and David Workman from Data Mosaic for tip two: Accordion Tab Panels.

TIP #1: Personal Database Server vs. Network Database Server
Your Servoy installation includes two versions of the SQL Anywhere database server: the personal server and the network server. Depending on your application, using one version over the other may be more suitable.

If you look in the folder 'sybase_db', you will find the database server binaries. The personal server is 'dbeng10' and the network server is 'dbsrv10'. By default, when Servoy starts it opens its repository databases using the network server. This is controlled in the file 'servoy.properties' using the attribute 'nativeStartupLauncher':

nativeStartupLauncher=Sybase_db/dbsrv10|@sybase_db/sybase.config\#DYLD_LIBRARY_PATH\=sybase_db

To use the personal server, you simply change 'dbsrv10' with 'dbeng10' before launching Servoy.

So what are the differences between the personal and network servers?

The personal server does not support client/server communications across the network (TCP/IP), and so it is designed to operate in environments where same-machine access to the database is appropriate. Embedded database applications are a good example of where you would find the personal server. Since there is no need for other computers to access the database, the personal server is a better choice. In this case, only the application that is running on the same machine can access the database. Another example is a remote application that synchronizes its data to a central database using MobiLink. The remote application needs a remote database, which is typically opened by the personal server.

There are some technical limitations to be aware of when using the personal server. As mentioned, it does not support client/server communications across the network. It is also restricted to ten simultaneous connections and to a single CPU. The network server does not have these restrictions.

The network server is what you would use for client/server communications across the network. It is perfect for multi-user database scenarios where a number of users will be accessing the same database from a variety of locations.

To recap, use the network server for your Servoy solutions, but consider using the personal server if you are developing an embedded database application or if you want to develop a solution that has data synchronization capabilities.


TIP #2: Accordion Tab Panels
To read the complete tip click here - http://www.servoymagazine.com/home/2008 ... cordi.html


Thank you for your contribution!