Are local files (dbfs) converted to SQL files on the SQL Server when deploying?

[jmonte407]

I'm confused about the develop / Deploy stuff... Are we only working with dbfs while on the App Builder? I want to import data from our current apps into Liange... Will I be importing them into my App Builder or the SQL server... I want the data to end up in the SQL Server.... Also.. when I create a database and it's tables while in the app builder and I deploy.. wil it create the database and its tables in the SQL Server?

Thanks
Jim

[lianjasupport]

Hi Jim,

Lianja databases and tables are in exactly the same format whether used by the Lianja App Builder or the Lianja SQL Server and the Lianja App Center. The only difference is where the development product (Lianja App Builder) and the client/runtime/user products (Lianja SQL server and the Lianja App Center) have set as their default data directory. Any databases and tables you create in the Lianja App Builder, whether they are imported or created natively, can be deployed for use by the Lianja SQL Server or the Lianja App Center.

[jmonte407]

I clicked deploy... nothing went to the SQL Server... I went to Settings - Deploy ... am I supposed to have a conn string in the odbc field?

[lianjasupport]

This page explains how to Deploy your Lianja App, database and Library files to make them available to the Lianja App Center or Lianja SQL Server on the same machine: http://www.lianja.com/doc/index.php/Deploying_to_Local_Directory

[jmonte407]

Where is the "Deploy Work Surface"? I dont see it on my setup.. I even downloaded the latest RC3...

[jmonte407]

Never mind .... It worked... I re-installed everything.. and deploy did deploy to the SQL Server...

Thanks
Jim

[jmonte407]

Turns out... You must click the "Preview" first... which is confusing... Preview make one think "it's just viewing what I'm about to deploy" not "this is a step that must be done" before deploying...

[barrymavin]

Jim, it's a safety measure so you think about what you are about to do. The last thing you want is to overwrite live data. I'm also looking at improving this whole process so it automagically creates an upgrade script that will apply metadata changes and issue the corresponding alter table commands etc.

[jmonte407]

Yes.. I agree.. see whats about to be updated... On another note... Lets say I want to deploy a web app or smart device app... Using lots of javascript... Lianja SQL Server can output results in JSON... My question is .. from the browser to the IIS server.. what is going to process the requests? Do I still need asp.dll or aspx.dll or even West-Winds WC.dll? How is the mapping done? Does Lianja have some sort of server page? How is this done?

Thanks
Jim

[barrymavin]

Jim, you just build an app as normal using the standard sections. You use WebView sections to build WebViewWidgets (such as the editor or calendar have done) then it gets deployed.

The Lianja Cloud Server takes care of all of the hard work and handles all the data binding etc for CRUD database apps for you. All the database requests are done for you using ajax. Its all transparent to you. So just build an app, test it on the desktop, deploy it, setup your users and permissions/roles and you ready to go when Lianja Cloud Server ships which is quite soon.

You can use as much javascript as you want in you WebViewWidgets and Lianja includes jquery, bootstrap, knockout.js (which i personally like a lot) so you just reference them as a "library".

In fact the Lianja App Center is all written using HTML5/JavaScript using knockout.js and jquery.