Integrate simplesat with Netlify

“Simplesat is a simple sat database for people who don't want to learn SQL to create and manage their SAT/SMT problems. It's built on top of Node, Express, Postgres, and Sequelize.” [2]

Integration of simplesat and Netlify

In this section, I will explain how simplesat integrates with Netlify.

• Create a new project

First, let's create new Netlify project.

$ netlify init # answer questions from the command $ cd /project_name # change directory name $ git init # initialize Git repository $ npm init # initialize npm package $ composer init # initialize Composer package

• Deployment via Netlify

In this section, I will explain how simplesat deploys through Netlify.

After finish creating a project, let's go to the project directory. $ cd /project_name .

And now, we have to update our composer.json file. We have to add the fplowing line after the "require" . { ... } :

"require-dev". { "simplesat/simplesat-netlify". "~0.1.0" },

And now, let's install it. $ composer update . And when we get prompt to install dependency require-dev:[email protected]^0.1.0 by simplesat/simplesat-netlify , press y . This will complete the installation of simplesat. And let's add its service providers in config/app.php . Add the fplowing lines after the 'providers' array:

// ... 'providers' => [ // ... SimplesatSimplesatNetlifyProvidersNetlifyServiceProvider::class, ] // ...

Now, we have to install the Netlify Command Line Interface (CLI. The official website is https://cli.netlify.com/. We can install it using either Yarn or npm . $ yarn global add netlify-cli $ npm install -g netlify-cli . Then you have to log in to Netlify account. $ netlify login . After that, we have to create a new site. We can do that by running this command. $ netlify create . After that, we have to choose our Git provider. $ netlify projects:set [email protected]:user/repository.git . And then, wait until it completes all steps. As of writing, it took 33 seconds on my computer (Mac Book Air 2012. Finally, we can deploy our project using this command. $ netlify deploy . And wait until it completes all steps. As of writing, it took 15 seconds on my computer (Mac Book Air 2012. After all steps are completed, you should see an Output like this. Site deployed at https://<your_site>.netlify.com/ Clicking on the link above should take you to your project deployment page on Netlify itself. You can see a screenshot of this page in Figure 3 below. Figure 3. Project Deployed on Netlify Now let's access our web app and play around with its features. You can access your project via its URL on Netlify dashboard (http://sat-simplestudio.netlify.com/ as of writing. or directly via its IP address (https://1m3rcs3p6ywfd8nu7kobcgzmjzt5n9f.netlify.com/ as of writing. Here is a picture of playing around with the web app on SatSimplestudio before playing around with it on your own computer. Figure 4. Playing Around with Web App Before We Play Around With it Our Own Computer It looks like it works fine for me! Let's check the server logs on Netlify to see what happened behind the scene when we deployed our project. Here is a picture of this server logs (http://sat-simplestudio.netlify.com/logs/#). Figure 5. Server Logs on Netlify I think it's kind of interesting to see what happened there. First, with the help of JSDom, we run a HTTP server on port 8080 (it was automatically chosen by Netlify), and then use PUT method to upload our files into a temporary directory (these files were actually downloaded from our local computer, not uploaded directly from our local computer), and then it does something called copy-assets (I guess it copies some assets into a temporary directory; I'm not sure because I am not familiar with Netlify's process), and then uses scp to upload them into a real directory (you can see that by clicking on the links. of your Netlify project (you can see that by clicking on the links. And here is a picture of my web app running locally. Figure 6. My Web App Running Locally I can see that my web app is running on port 3001 . So let's check the server logs again and see how server runs locally. Figure 7. Server Logs Running Locally Cop! There are no error message so far! Cop! There are no error message so far! How about if we edit our HTML file? Let's come back our home page and click on Edit button in the right side bar. Figure 8. Editing the Home Page We can type anything into the text area and click Save button in the right side bar or just hit enter key or type escape key to close the editor window immediately and save the changes made in this window automatically without spamming into the text area later. So let's try editing some files in our projects under public directory and see how it works. For example, here is my main HTML file (index.html). <!DOCTYPE html> <html> <head> <title>My First SatSimplestudio</title> </head> <body> <h1>Hi!</h1> My name is <span id="name"></span>. <script src="main.js"></script> </body> </html> And here is my JavaScript file (main.js). window.onload = function(. { document.getElementById("name".innerHTML = "John Doe"; }; Now let's come back to our home page and edit the name inside span element. Once done editing, click on Save button in the right side bar or just hit enter key or type escape key to close the editor window immediately and save the changes made in this window automatically without spamming into the text area later. If everything goes well, we should be able to see our updated name both in our web app and in Netlify server logs. Figure 9. My Name Updated Everywhere To test if my name really updates everywhere, I will edit my name in index.html file again and click on Save button in the right side bar or just hit enter key or type escape key to close the editor window immediately and save the changes made in this window automatically without spamming into the text area later again. Figure 10. My Name Updated Again Note that even though I changed my name many times, at most one entry was put into server logs (you can click on any item in output list to jump to its detail view and if you're interested in how exactly things were done behind the scene when you edited anything in your project, you can click on any item in "Relevant actions" list. Note that even though I changed my name many times, at most one entry was put into server logs (you can click on any item in output list to jump to its detail view and if you're interested in how exactly things were done behind the scene when you edited anything in your project, you can click on any item in "Relevant actions" list. At last, I will update everything from my local computer instead of editing it one by one from my browser. Here is my updated main HTML file (index2.html). <!DOCTYPE html> <html> <head> <title>My Second SatSimplestudio</title> </head> <body> <h1>Hi!</h1> My name is <span id="name">John Doe</span>. <script src

The process to integrate simplesat and Netlify may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.