Sciter : GUI Application with Golang using HTML/CSS

Update : 25-12-2019

This is the words from Sciter's Web site,

Sciter brings a stack of web technologies to desktop UI development. Web designers and developers can reuse their experience and expertise in creating modern looking desktop applications. Various GUI frameworks offer different UI declaration and styling languages, such as QML and XAML (Microsoft WPF). On the contrary, Sciter allows using time proven, robust, and flexible HTML and CSS for GUI definition and GPU accelerated rendering.
Before using sciter I already tried other alternatives but none of them was satisfactory as an example first i tried andlabs/ui libraryi already have written a post on it. You can read it on post gui programming with golang.  But this library is still under construction and has no support for production apps.
Secondly, I go for electron but the problem was my simple calc like the app was of size 150mb. Which is 15mb of go and other was the electron. 
Before some time I found another alternative, s…

Easy way deploy and manage mysql database to linux server

Let assume that you have setup the linux server with mysql. Now you want to deploy the database to the server you have created on your developement enviroment. 

You development enviroment may be windows or mac or linux with the gui but server are run only cli.

So it is necessary to know the easy way to deploy database to the server with just cli

Importing the mysql database to mysql using the cli

1) Export the sql file of the database from your development enviroment.

2) Copy the sql file to the serve using the sftp.

3) Now import the sql file to you mysql using this comman snippet

    $ mysql -u [username] -p < [path/to/your/sql/file] 

    $ password : [your password ] [will be invisible on screen]

After sucessfull import of sql file your database will ready to be used.

Note that if there is any error during the import than it will print the error on the screen but in case of successful import it will not generate any response.

Now to access the database deployed on the server you may use the phpmyadmin. But it come at the cost of php. Your production application might not using the phpmyadmin. 

To overcome this you can use another approch to access the remote mysql server using the mysql client.

Remote Mysql Connection

To enable the remote access for the mysql remote access you have to enable the remote access to the user run this command

GRANT ALL PRIVILEGES ON *.* TO '[username]'@'[host]' IDENTIFIED BY '[password]'

Here [username] is the user name for which you want to enabel the remote access. and [host] is the host for which you want to enable the remote acess. 
[host] may be an ip address or the dns name of host.

After this step you can connect to the remote mysql server using your local mysql client

Mysql clients

For windows : mysql workbench
For Mac : sequelPro
For Linux  : mysql workbench


  1. Another easier way to deploy a PHP and MySQL website to a server is by using a platform like Cloudways web hosting for PHP. With this platform, users can launch a managed servers on cloud in just one click with PHP and MySQL already installed on it.


Post a Comment

Popular posts from this blog

Sciter : GUI Application with Golang using HTML/CSS

setup hyperledger fabric on windows 10

Apache : setup basic auth with apache in windows