Creating full-stack web applications based on database schema for free!

Today, we’re excited to announce the free pricing plan for our CRUD tool. That means that more customers than ever before can use Flatlogic for creating a proper CRUD React/Vue/Angular web application based on the database schema.

What can you do with the free plan for the CRUD tool

You can expect the same features and functionality whether you choose our Paid access or Free option. But obviously with some limitations:

Create up to 10 applications on different technology stacks: React, Vue, Angular, Node.js, Laravel, PostgreSQL, MySQL
Create a full-fledged CRUD application (up to 3 database entities) with code written using best practices
Download or push source code to Github an unlimited number of times
Preview the code before downloading/pushing it on Github
Get updates on libraries used in your app stack
Host instantly your application demo and see the latest deployment logs

Free vs Paid access to the CRUD tool: Choose what you need

Since launching Flatlogic, we see constant growth in the creation of CRUD applications. But we understand that not all of our users need the full functionality of the CRUD tool. We also understand that in the modern world of developer tools, before investing huge resources in mastering new tools, you want to get some value here and now for free – with this motivation we introducing a free plan for creating CRUD applications.

Thus the free plan fits your needs. If you:

Want quickly prototype the CRUD app

Want to test or get familiar with new technologies before investing much time in them
See the best practice on how to organize modern CRUD apps using best practices
Prefer to use starter kits/boilerplates while starting CRUD web applications

And while our Professional plan has always offered a more enhanced way to create CRUD applications, it also required additional steps to understand your needs before getting access.

Now, you can sign up for a free account for a CRUD tool, create applications in minutes, and understand without any hassle whether Flatlogic fits your needs or not.

Create a CRUD app for free!

The post Creating full-stack web applications based on database schema for free! appeared first on Flatlogic Blog.

Flatlogic Admin Templates banner

Generate Full-Stack Web Apps Based on Database Schema

Hello! Flatlogic has added one more important feature: ready-made web application scheme integration. Check out our release notes to learn more about our latest product enhancements.

Previously, Flatlogic web app generator allowed you to model a database schema from scratch. We received a lot of requests from our users who had already modelled DB schemas and found it inconvenient to manually remodel the schema in Flatlogic schema editor.

To eliminate this obstacle and increase our users’ satisfaction, we are introducing a new platform feature: Creating the web app schema from a SQL dump. The feature supports both Postgres and MySQL dialects and identifies tables and column types, also trying to discover relations based on index, reference and constraint information. “users” table is automatically added to the DB model to preserve web app user management functionality. If the “users” table already exists in the imported DB, the column lists of the two tables are merged. SQL import is invoked by simply uploading the SQL dump file, literally in one click.

We recommend that you choose “Structure only, no data” mode when dumping the SQL from your database, otherwise the data dump will result in unnecessary volume uploads which sometimes could be huge and even lead to upload failure.

After the successful file upload and schema import, the schema editor allows you to review and edit the schema, and correct names and column types in case those were not identified correctly by the SQL dump parser. Also you can add one-to-many (relation one) and many-to-many (relation many) relation types if such were not discovered automatically.

Flatlogic schema editor also allows you to extend your existing DB schema while keeping all the data intact by applying our generated migrations feature.

Enjoy this new feature and model Admin web apps for your existing database literally in one click!

Click here to learn more about upcoming features. Here you’ll see some info about Flatlogic plans and some points from the roadmap.

The post Generate Full-Stack Web Apps Based on Database Schema appeared first on Flatlogic Blog.

Flatlogic Admin Templates banner

What is Node.js?

NodeJS is a backend JavaScript runtime environment (RTE) designed in 2009 by Ryan Dahl, that is used to build server-side applications like websites and internal API services. Node.js is also a cross-platform stack, meaning that applications can be run on such operating systems as macOS, Microsoft Windows and Linux.

Node.js is powered by Google’s Chrome JavaScript engine V8, with web applications event-driven in an asynchronous way. Also, Node.js uses the world’s largest ecosystem of open source libraries – npm (The Node Package Manager).

The npm modules idea is a publicly available set of reusable components, which are available through simple installation via an online repository, with both version and dependency management.

The architecture of Node.js work

Node.js has a limited set of thread pools of requests processing.
Node.js queues requests as they come in.
Then comes the Single-Threaded Event Loop – the core component that waits indefinitely for requests.
The loop picks up the request in the queue as it arrives and verifies if it requires an I/O blocking operation.
If the request doesn’t have a blocking I/O operation, the loop processes it and sends a response.
If the request appears to have a blocking operation, the loop creates a thread from the internal thread pool to control the request.
As soon as the blocking task is handled, the event loop continues monitoring blocking requests and queues them. That’s called a non-blocking nature.

Why use Node.js

Single-Threaded Event Loop Model. Node.js uses a ‘Single-Threaded Event Loop Model’ architecture that manages multiple requests submitted via clients. While the main loop of events is performed by a single thread, the I/O work in the background is performed by separate threads because the I/O operations in the Node API are asynchronous (non-blocking design) to fit into the event loop. 

Performance. Through Google Chrome’s V8 JavaScript engine on which the work is built Node.js allows us to run the code faster and easier.

High scalability.  Applications in Node.js are very scalable because they work asynchronously. Node.js operates in a single thread when one request is submitted, processing begins and is ready to prepare for the next request. When ready, it sends the request back to the client.
NPM package. 

Global community. NodeJs has an enormous global community that actively communicating on GitHub, Reddit, and StackOverflow. Community members also share completely free tools, modules, packages, and frameworks with each other.

Extended hosting options. Node.js deployments occur via PaaS providers such as AWS and Heroku. Thus, NodeJs minimizes the number of servers required to host an application, ultimately reducing page load times by 50%.

Who uses NodeJs

Node.js enables to build the business solutions due to which you have an edge over competitors, e.g.:

IoT apps;
Data Streaming, etc.

Node.js is quite popular it is used for development by both global companies and startups, below are examples of the most popular of them: 


How to create your application on Node.js backend using Flatlogic Platform

1 Step. Choosing the Tech Stack

In this step, you’re setting the name of your application and choosing the stack: Frontend, Backend, and Database.

2 Step. Choosing the Starter Template

Then you’re choosing the design of the web app.

3 Step. Schema Editor

In this part you will need to know which application you want to build, that is, CRM or E-commerce, also in this part you build a database schema i.e. tables and relationships between them.

If you are not familiar with database design and it is difficult for you to understand what tables are, we have prepared several ready-made example schemas of real-world apps that you can build your app upon modification:

E-commerce app;
Time tracking app;
Books store;
Chat (messaging) app;

Flatlogic Platform offers you the opportunity to create a CRUD application with the Node.js backend literally in a few minutes. As a result, you will get DataBase models, Node.js CRUD admin panel, and API.

The post What is Node.js? appeared first on Flatlogic Blog.

Flatlogic Admin Templates banner