MailgunX - Send Emails via Mailgun. Open Source.

in , ,

MailgunX is an implementation of the Mailgun (https://www.mailgun.com ) API by Rackspace. This is far superior to using SMTP socket as it is faster.

Highlights:

Easily send email messages using Mailgun by creating an instance of Mailgun.SendEmail thread class. Emails are sent in the background via thread.

We will add additional Mailgun functionality over time as needed in our projects.

See: https://github.com/1701software/MailgunX

MIT Licensed

SQLdeLite version 2. iOS Compatible! Open Source.

in , ,

SQLdeLite is an open source library that allows you to speed up your database development with Xojo.

Highlights:

  • Single drop in module that speeds up your development.
  • Automatically uses SQL prepared statements mitigating SQL injection attacks and speeding up database performance.
  • Quickly and easily create SQL queries by using variables representing the properties of your objects. These variables are converted to the bounded parameters in prepared statements.
  • No more string concatenation for your SQL!
  • Dynamic objects that allow for any number of properties without having to define each one in the IDE. Now it's much faster to handle your query parameters and results.
  • Built on top of the new Xojo framework. 
  • Full support for iOSSQLiteDatabase on iOS! You can use the same business logic between projects despite using different database backends.
  • Full support for all Xojo supported databases. Enable databases that require plugins by setting the appropriate constant to True (example: PLUGIN_MSSQL_ENABLED).
  • Full support for cubeSQL. Make sure to enable support by changing the PLUGIN_CUBESQL_ENABLED constant to True.
  • Valentina database is also supported by virtue of the SQLdeLite.ParameterizeSQL() method. This converts your SQL query into a Valentina compatible query with bound parameters.

The library does not expose any new database classes nor requires the usage of custom database adapters (as in "Active Record" from BKeeney Software). The module extends the built-in Xojo databases classes and provides you with two additional methods. These methods replace the default SQLSelect() and SQLExecute() methods for your database of choice.

Why use over ActiveRecord?

  • ActiveRecord can only load a record via it's primary key which is forced to be an integer. It has the ability to load an object from a RecordSet which SQLdeLite can also do automatically (see the Advanced Features topic below).
  • ActiveRecord is not available on iOS. SQLdeLite runs everywhere Xojo runs: Console, Desktop, Web, and iOS without any modifications. 
  • ActiveRecord requires you to use their database specific adapters. SQLdeLite extends the Xojo native databases .
  • ActiveRecord requires code generation using the commercial ARGen product or hand building your database classes. SQLdeLite can use classes or dynamic objects via SQLdeLite.Record.
  • SQLdeLite is HALF the size contained inside a single module.
  • SQLdeLite is built on top of the new Xojo framework and ready for the future.

=========================

Read more and download from GitHub at: https://github.com/1701software/SQLdeLite

Scheduling cubeSQL Backups

in ,

Many customers have asked us how to schedule backups of cubeSQL on their ServerWarp / 1701 Hosting Xojo optimized servers. The trick is to add a schedule and then navigate to the 'Databases' pane in 'cubeSQL Admin'. You can select a database from the list and then in the menu there is a 'Manage Schedules' option to attach schedules to individual databases.

For a step-by-step guide to how to do this I direct you to the excellent blog post with screenshots from SQLabs regarding this issue: 

http://www.sqlabs.com/blog/2012/08/cubesql-and-schedule-backups/ 

As always let us know if you have any questions about your cubeSQL hosting. Remember we are the only host that provides complimentary unlimited connections licenses to cubeSQL Server by SQLabs. cubeSQL Server is multi-user SQL Server powered by SQLite. It allows you to manage databases, encrypted databases, users, permissions, backup schedules, etc. You can access your SQLite databases using Xojo plugins, PHP, or their new REST API. Hit us up if you have any questions about cubeSQL, cubeSQL hosting, or the best Xojo web hosting available on the market.