Stacks Image 4000

Xanadu

Xanadu is a platform for developing Database-Driven Web Apps that use NGINX, PHP, HTML, Bootstrap, CSS, Javascript, and MySQL.

Xanadu isn't like other platforms or frameworks. We're old-school developers who use a mix of procedural and object-oriented code in a way that reflects reality. Start with a Page and add Elements. The Page Body generally contains Cards with Elements like Tables, Labels, Inputs, and Buttons. Simple.

It's been a long road. We've been developing Database-Driven Apps for decades with FileMaker and Xojo, both closed-source platforms. FileMaker rocks, but licensing has become expensive. Xojo has fantastic pricing but is perpetually buggy.

We landed on PHP because it is affordable, solid, and open-source.

It's been a while since we last updated information about Xanadu.

Xanadu has come a long way and is almost ready for us to talk about. In the meantime, this page will be under a remodel for a bit!

Xanadu Pricing

Price
  • $900 annually or renewal.
  • $450 annual renewal with an active Hosting plan.
Includes Maintenance
  • Source Code via GitHub.
  • Support via Email, unlimited.
  • Support via Zoom, up to 2 hours.
Hosting
  • $100 per month for most Web Apps.
  • Includes
    • Dev App and Production App.
    • Domains like myapp.xanweb.app.
Development and Training
  • $150/hour
  • Discuss via Zoom
  • Ballpark Estimate
  • Develop
  • Demo

Benefits

Control
  • Open Source Libraries without gatekeepers.
  • PHP is tried and tested.
  • Millions of PHP Developers. Since 2001 for us!
  • Runs on Linux using NGINX, Let's Encrypt, PHP.
Ease
  • Create MySQL Table with Fields.
  • Run Table Schema update.
  • Customize Table Schema details.
  • Run Module Generate.
  • Customize List, Cards, and Business Logic.
Flexibility
  • API Endpoint.
  • Customer Portal.
  • Web Store with a Shopping Cart.
  • Using FileMaker Data API as a data source.
  • Job Scheduler.
  • Insurance Claim Processing
CampSoftware Support
  • Support via Email or Zoom.
  • Web App Hosting.
  • Custom Development.
    • Develop Entire App
    • Add Features
    • Assist You.
    • Conversion from Excel, FileMaker, Xojo, etc.
  • One on One Coaching.

Overview (Update coming soon...)

Modules (Update coming soon...)

Home is the place to include important information to the user. This might be a list of Tasks, Calendar Events, Billable Project Items, or Sales Stats.

Currently we have a few demos:
  • Getting a Location
  • Stripe Payment Buttons
  • QRCode
  • API Request and Queue Processor
  • Time from the Server in UTC and a equivalent time in a specified Timezone.
Stacks Image 6436
Contacts is a Record Based Module that displays a record along with related records like Comms. Modules like Home are similar, except they don't typically have a Selected Record or a List.

The Menus are found on the top. Next is the Module Title with Module Action Buttons on the right. Buttons can be anywhere you'd like as well.

The Content is below the first two lines. In the Content, there is a List of Records Card with five Cards for the Details [ Contact, Comms, Info, Notes, and Other ].

Blue Plus Buttons can be found in the List to add a new Contact and also in Comms to add a new Address, Email, Web, Phone, etc. Red Minus Buttons can be found in Comms to delete a Comm.

Next to the Photo in the Contacts Card, a image can be uploaded by clicking the Blue Upload Button or Dragging and Dropping an image onto the Blue Upload Button.

The Contact Picker Button lets you search Contacts to then select a contact. It returns the Contact ID to then do something with that ID.

The Actions Button has a dropdown menu with items: Print to PDF, Print to HTML, Duplicate, and Delete.
Stacks Image 4943
Actions

Some modules have actions. Here we Add a Contact by clicking the + Button. On the right we can Select a Contact or under Actions, we can Print to PDF, Print to HMTL, Duplicate or Delete the selected Contact.
Stacks Image 5078
The user Menu is for specific options for the logged in user.

The pictures show an Admin logged in. If a non Admin was logged the first four options would not be included.
Stacks Image 4960
Stats is where you can see a bit into what is going on in the server. Stats shows:
  • Versions of the OS, PHP, and wkHTMLtoPDF
  • Disk Usage
  • RAM Usage
  • Disk Usage of each app folder
  • Processes Info
  • List of Sessions
  • List of Process Pools
Stacks Image 4978
Settings is where you can customize Xanadu to include:
  • Contact info
  • Specific formatting for Dates, Timestamps, Time, and Currency
  • Details for Sending Email ( SMTP )
  • Details for Sending SMS/Text Messages ( Twillo )
  • Details for Payment Buttons ( Stripe )
  • Other APIs like Google Maps
Stacks Image 5231
To create a Login, a User is needed where you can set Contact Info, Privileges, and Authentication including replacing a password.
Stacks Image 5241
We always want the user to know what is going on. Here we edit a User Full Name which immediately Saves followed by a Name Update in the Header and User List. The Name Update shows a Cloud icon indicating it started, an intentional pause for a few seconds, followed by the completion message and run time.
Stacks Image 5259

Module Generation

Add MySQL Tables for Tickets and Tickets Messages to create a Bug Tracking Ticketing System.
  • Tickets will have a related list of Ticket Messages.
  • Record Modification fields begin with "Mod".
  • Xanadu Keys begin with "UUID". The Primary Key is "UUID{TableName}"

Tickets Table

Stacks Image 6060

TicketMessages Table

Stacks Image 6074
Run Schema Update
  • Found under the Developer Menu.
  • Updates the Modules Table from the SQL Tables.
  • Updates the Schema Table from each SQL Table for each Column.
Stacks Image 6227
Edit Schema
  • Edit the GroupName for each Column.
  • Format is Card Order, Card Title, Column Order.
  • On generation, Columns with the same Card Title will be placed on the same Card.
Image
Generate Module
  • Define the Tables with the Module Name, Table Name, Plural Name, Singular Name, and Defined Font Awesome Icon.
  • Generate Modules for the Parent Table and Related Table.
  • Check the Result Log. 
	// Modules
	$tableContacts = new \xan\khan( 'Contacts', 'Contacts', 'Contacts', 'Contact', "FI_CONTACTS" );
	$tableTickets = new \xan\khan( 'Tickets', 'Tickets', 'Tickets', 'Ticket', 'FI_TICKETS' );
	$tableTicketsMessages = new \xan\khan( 'TicketsMessages', 'TicketsMessages', 'Tickets Messages', 'Ticket Message', 'FI_MESSAGES' );
	
	// Generate
	$tableTickets->generate( [ $tableContacts ], [ $tableTicketsMessages ] );
	$tableTicketsMessages->generate( [ $tableContacts, $tableTickets ], [] );
	
	// Result
	$khanResultMsg[ '$tableTickets' ] = $tableTickets->result;
	$khanResultMsg[ '$tableTicketsMessages' ] = $tableTicketsMessages->result;
Load Module
  • Below is the generated Tickets Module after populating some fields.
  • The Ticket List and Ticket Detail come from Tickets Module.
  • The related Tickets Messages come from the TicketsMessages Module.
  • TicketsMessages wouldn't normally be included in the Navigation as a related table.
Image

Schema Attributes

Once a SQL Table is created, you can run the Schema Update which will set many of the following:
  • TableName, DatabaseName, IsDefined, ColumnOrder, GroupName, ColumnName, LabelEN
  • EleFormatAs, EleType, EleAlign, InputMode, DataType, LengthChars, LengthInteger, LengthDecimal
  • LabelENTooltip, EleChoicesValues, EleChoicesDisplay, EleOtherLabel, EleClearLabel, EleWidth, EleHeight
  • IsFindable, IsIndexFullText, IsMod, IsKey, IsKeyPrimary, IsKeyForeign, SelectAs
  • UpdatedTS, ModTSCreated, ModFlag.
Image
Image

Process

Our Development Flow is simple. Develop, Test, Push to Production, and Push to GIT.

We use PHPStorm and love it. PHP Storm, you can connect to FTP Servers, GIT Servers, and MySQL. I'm sure there are many more things that you can connect to, but this is all we've needed. We create two websites, one for development and one for production. Both are added to PHPStorm as separate connections. Then, we connect GIT to github.com and connect MySQL to the MySQL Server.

Questions and Answers

Q: Can you add a feature for me?
A: That depends on what you need! :) Seriously, just ask and we'll try!
Q: Why don't you use FileMaker?
A: We did use FileMaker for years! Unfortunately, the licensing made selling apps with FileMaker too expensive. We used FileMaker Runtime, but it was deprecated. We hoped to use FileMaker WebDirect, but FileMaker changed the WebDirect per user price to the same price as FileMaker Pro or FileMaker Go user. FileMaker just priced it self out. :(
Q: Why don't you use Xojo aka REAL Studio aka REALbasic?
A: We tried Xojo. While developing Desktop Apps [ Mac, Windows, Linux ] works well, not so much for Web Apps. When developing Xanadu with Web 1.0 would encounter a Xojo bug here and there, the IDE wouldn't crash too much, but over time the quality decreased. Xojo deprecated Web 1.0 with the release of Web 2.0. We were excited for responsive apps and a refresh. Unfortunately, it took Xojo a while, and once released, Web 2.0 sure didn't feel ready. I love Xojo and the pricing model. I'd pay double or even triple, but there are too many bugs in Xojo to deal with. Check out the forums at https://forum.xojo.com and https://ifnotnil.com to read more.