[dba-Tech] Write once run everywhere

[Jim Lawrence]

Hi Paul:

Before I forget to mention it there is one more component that must be installed and setup for Electron. It is NodeJS...a superfast database connector that runs between your frontend (Electron) and your backend database. It supports all major database but for brevity, I have chosen an example that connects to MS SQL. Below is a quote on its pluses and minuses:

"Node.js uses a single process to handle multiple requests. A single process tends to use less memory than multiple processes. That is why they required less servers.

In practice, since Node.js is based on JavaScript asynchronous programming, as long as the requests execute mostly I/O operations, like database access, network access, file system access, most of the time the CPU will be just waiting, rather than executing work.

That is fine for pure I/O based processing. For more CPU intensive requests, like for instance image processing that you do when you rescale uploaded images for instance, the CPU processing would become significant and the single process approach of Node.js would not be good anymore, as the Web server would be choking frequently, with all requests being stopped every time a request requires image processing or other CPU intensive tasks done by Node.js." (In the rare occasions that CPU heavy processes are required I would suggest using the old tried and true favourite, ADO or ADO.Net as these connectors are built into every Windows version, they may be slow but they are reliable under all conditions...though a lot of graphic work is now being performed, on the desktop, using the JavaScript's new canvas feature.)

To install NodeJS and how to connect it to your MS SQL server here is a very good set of instructions from Microsoft. For Windows desktops/servers:

https://www.microsoft.com/en-us/sql-server/developer-get-started/node/windows/
http://bit.ly/2KkvJHA

...and for Ubuntu (my current favourite Linux version):

https://www.microsoft.com/en-us/sql-server/developer-get-started/node/ubuntu/
http://bit.ly/2jSp0tn

There are instruction for setting up, MacOS, Redhat Enterprise Linux and SUSE Linux Enterprise Server, as well.

It is really easy to install and works with the Electron framework frontend.

Jim  

----- Original Message -----
From: "Discussion of Hardware and Software issues" databaseadvisors.com>
To: "Discussion of Hardware and Software issues" databaseadvisors.com>
Cc: "Paul Hartland" <paul.hartland at googlemail.com>
Sent: Friday, May 11, 2018 9:00:56 AM
Subject: Re: [dba-Tech] Write once run everywhere

I need to look into this, sounds very good

On Fri, 11 May 2018, 16:57 Jim Lawrence, <accessd at shaw.ca> wrote:

> I have been doing some playing with the new Electron App. It is a way to
> build complex application, once compiled, can run on any desktop. The apps
> built by this application can run from your desktop and not only use the
> local features but can be extended off through the web.
>
> https://electronjs.org/
>
> Here is a video for learning how to use the Electron framework named:
> Learn Electron in Less than 60 Minutes - Free Beginner's Course:
>
> https://www.youtube.com/watch?v=2RxHQoiDctI
>
> Be able to build a stand-alone desktop application that can run across the
> internet without a browser, that can be written on a Microsoft VB Studio
> editor.
>
> Aside: the VB studio editor is based on the Electron framework (but used a
> different compile engine than ATOM), using TypeScript‎, ‎JavaScript‎, ‎CSS,
> NodeJS etc and its compiled code will run on all platforms.
>
> https://en.wikipedia.org/wiki/Visual_Studio_Code
> http://bit.ly/2I8cK6D
>
> Note: the VB studio editor supports coding in over 50 languages! (Just
> about every language listed the goalkicker website...)
>
> ...the entire source code can be downloaded used in any application or
> just viewed for learning purposes:
>
> https://github.com/Microsoft/vscode
>
> Below is a link to a few popular apps that have been written in Electron:
>
> https://brainhub.eu/blog/7-famous-desktop-apps-using-electron/
> http://bit.ly/2KaPy4f
>
> Have fun
> Jim
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com