<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Vihar Kurama on Medium]]></title>
        <description><![CDATA[Stories by Vihar Kurama on Medium]]></description>
        <link>https://medium.com/@vihark?source=rss-4ce24554e1d2------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*1G8gQRqf6hDjQZVBKno2Mg.png</url>
            <title>Stories by Vihar Kurama on Medium</title>
            <link>https://medium.com/@vihark?source=rss-4ce24554e1d2------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 03:16:41 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@vihark/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Introducing Plane: Simple, Extensible, Open-Source Project Management Tool]]></title>
            <link>https://medium.com/better-programming/introducing-plane-simple-extensible-open-source-project-management-tool-d56dfac886ed?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/d56dfac886ed</guid>
            <category><![CDATA[project-management]]></category>
            <category><![CDATA[agile]]></category>
            <category><![CDATA[open-source]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[productivity]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Thu, 04 May 2023 02:27:19 GMT</pubDate>
            <atom:updated>2023-05-04T13:59:39.168Z</atom:updated>
            <content:encoded><![CDATA[<h4>Manage issues, sprints, and product roadmaps with peace of mind</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*PP8Q0QDyD_jiDVIMoILiKA.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@fantasyflip?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Philipp Katzenberger</a> on <a href="https://unsplash.com/wallpapers/desktop/mac?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p><a href="https://dub.sh/plane-github">Plane</a> is a simple, extensible, open source project and product management tool powered by AI. It allows users to start with a basic task-tracking tool and gradually adopt various project management frameworks like Agile, Waterfall, and many more.</p><p>In this article, I will explain some of the main features of Plane and how they can help you plan your big projects or products more effectively and quickly.</p><h3>Plane Architecture</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*larpRTVfu9PYkf67HDw7rQ.png" /><figcaption>Plane Architecture Diagram</figcaption></figure><p>Plane is built using a carefully selected tech stack, comprising Next.js for the frontend and Django for the backend. We utilize PostgreSQL as our primary database and Redis to manage background tasks. Additionally, our architecture includes two microservices, Gateway and Pilot. Gateway serves as a proxy server to our database, preventing the overloading of our primary server, while Pilot provides the interface for building integrations. We have also developed an AI service based on OpenAI, incorporating LangChain as an interface.</p><p>Selecting the appropriate tech stack for Plane was a challenging task. Initially, we planned to write all of our REST APIs in Node.js. However, we pivoted from this idea due to issues encountered with warm/ cold lambda and ORMs on Vercel. We found that building REST APIs were faster and more reliable when using fewer Node packages. Although our decision was purely opinion-based, we are satisfied with the outcome.</p><p>Currently, Plane Cloud is hosted on Vercel for frontend deployment and on Amazon EC2 for backend services. You can self-host your own version of Plane using our Docker images or Docker Compose, which are readily available in our repository.</p><h3>Setting up Plane</h3><p>Setting up the Plane server is a breeze! You can easily do it by running a simple command using docker-compose from your terminal. Whether you prefer working on your local machine or cloud provider, Plane server is packaged as a Docker container.</p><pre>git clone https://github.com/makeplane/plane<br>cd plane<br>./setup.sh localhost<br>docker-compose up</pre><p>Plane is also on DockerHub, and you can install it with one command.</p><p>To run a Plane server on your local machine and listen on port 80, use the following command:</p><pre>docker run -e NEXT_PUBLIC_API_BASE_URL=&quot;&lt;http://localhost&gt;&quot; -e DATABASE_URL=&quot;&lt;EXTERNAL_DATABASE_URL&gt;&quot; -e REDIS_URL=&quot;&lt;EXTERNAL_REDIS_URL&gt;&quot; -p 80:80 makeplane/plane</pre><ul><li>Add -e DATABASE_URL=postgresql://user:pwd@host:port/db to use an external PostgreSQL.</li><li>Add -e REDIS_URL=redis://user:pwd@host:port to use an external Redis.</li></ul><h3>Workspaces and Projects</h3><p>It’s very easy to get your team started on Plane. After signing up, you can create a workspace and invite your team. Then, you can create projects within the workspace and add your team members to them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JATbl_8L-lWAf_b-fpq97w.gif" /><figcaption>Workspace Settings on Plane</figcaption></figure><p>Self-hosters can configure their email services by configuring ENV keys and using all the emailing features on Plane.</p><h3>Issues</h3><p>Issues are the fundamental building blocks of Plane, similar to blocks in Notion. All of your activities on Plane are linked to issues, enabling you to complete tasks assigned to you.</p><p>As soon as you start a project, you can begin creating issues by pressing the keyboard shortcut key C . You can use the I&#39;m Feeling Lucky option located just below the title to allow AI to generate a description, or you can click on the AI button to prompt for a description.</p><p>You can view all the issues in a project using three different views: List, Kanban, and Calendar. The List and Kanban views are simple to understand. The Calendar view shows the issues with due dates, which gives you a better idea of the deadlines.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Ch6mWBaw-RRTEshMF9sYlw@2x.png" /><figcaption>Creating Issue on Plane</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fBUgwM06zyjErGEfcqiZNg.gif" /><figcaption>List, Kanban, and Calendar Views on Plane</figcaption></figure><h3>Issue Detailing</h3><p>Plane’s simple UI makes it easy to add issue details. You can access a rich text editor with markdown and image upload support to add all the resources and information needed to complete your issue.</p><p>On the right-hand sidebar, you can find all the issue sub-properties like state, estimate, priority, due date, assignee, and collaboration tools to help you prioritize issues.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TcP5hGOf2YxQSb1eIrroBQ@2x.png" /><figcaption>Issue Detail on Plane</figcaption></figure><h3>Cycles</h3><p>In Plane, a cycle is a specific period during which a team works on completing items on their backlog. Typically, by the end of the cycle, the team would have built and implemented a new version of their project or product.</p><blockquote><em>Only one cycle can be active at a given time, while the others can be in a draft, upcoming, and completed state.</em></blockquote><p>Creating cycles and adding issues inside them is very easy. You can use the shortcut key Q to create a new cycle. Inside the cycle, you can create new or bulk-add issues from the backlog with just a few clicks.</p><p>To plan the scope, you can utilize the burndown chart and the Assignees and Labels scopes in the right-hand sidebar.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aMq44oDa15dIVUJOXbFf2g.png" /><figcaption>Active Cycles on Plane</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/1*9g9AK70OOEk6WP7AI55gUg.gif" /><figcaption>Adding Issues to Cycle on Plane</figcaption></figure><h3>Modules</h3><p>Modules are smaller, focused projects that help you group and organize issues within a specific time frame. They allow you to break down your work into manageable chunks and track progress toward specific goals or objectives.</p><p>When building Plane, we categorized all the integrations and importers into two modules. This helped us keep track of the number of integrations and importers shipped within a given time frame.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*uuoVgwZ_vEDO2bOeQdnwaw@2x.png" /><figcaption>Planning Modules on Plane</figcaption></figure><h3>Views</h3><p>Plane’s Views allow you to customize your issue properties by adding filters and grouping them according to your preferences. You can apply these customizations to Lists or Kanban views or create and save them separately to share with your team.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HHtSwXBwCQgrvooFsrYdnw@2x.png" /><figcaption>Creating Views on Plane</figcaption></figure><h3>Pages</h3><p>Pages in Plane allow you to take notes quickly during stand-ups or meetings and convert them into issues with just a few clicks. Think of Pages as an AI-powered notepad that you can use to enhance your writing or add descriptions to your issue blocks with the help of GPT.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OZpMM7WEvNmEN6Jv4wz4Cg@2x.png" /><figcaption>Pages on Plane</figcaption></figure><p>You can move blocks from Pages to issues and sync them to copy all the descriptions to the issues automatically.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_gwJ1jtj0MXtrzUJC_586A@2x.png" /><figcaption>Syncing Issues on Plane</figcaption></figure><h3>Settings and Preferences</h3><p>Plane offers a wide range of customizations, including updating your workflows and working with your favourite themes.</p><ul><li><strong>Members</strong>: Add and manage team members with four levels of permissions: Owner, Admin, Member, and Viewer.</li><li><strong>Themes</strong>: Choose from four pre-built themes — light, dark, light contrast, and dark contrast modes.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*7WlzmJYSY9EqgURVHjQdAQ@2x.png" /><figcaption>Dark Mode on Plane</figcaption></figure><ul><li><strong>Manage workflows</strong>: Add an unlimited number of states and organize them based on your preferences.</li><li><strong>Manage Labels</strong>: Create custom labels and grouped labels to better organize your issues.</li><li><strong>Estimate</strong>: Create custom estimate points for your issues with up to six levels.</li></ul><p>Everything, open-source, so you can customize based on your requirements.</p><h3>Keyboard-First Approach</h3><p>By using shortcuts and the command menu, you can work more efficiently in Plane.</p><p>The command menu provides a global search feature allowing you to navigate any page or issue within seconds. Additionally, while working on issues, you can update all the properties with the command menu without even touching your mouse.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*TO9bL271B0lOmVfr1wXTCQ@2x.png" /><figcaption>Command Menu on Plane</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/777/1*zU9yE8ZxLsPFoZWj06sghg@2x.png" /><figcaption>Updating Issue Properties using Command Menu</figcaption></figure><h3>Integrations and Importers</h3><p>Plane currently offers two integrations — GitHub Sync and Slack.</p><ul><li>GitHub Sync allows users to connect any GitHub repository to a Plane project, enabling cross-synchronization of issues between Plane and GitHub in both directions.</li><li>Slack integration lets users send notifications to preferred channels whenever issues are updated or created. You can even create issues using Slack commands directly from Slack.</li></ul><p>Plane currently offers two importers, JIRA and GitHub. With these importers, you can easily bring in all the issues, sprints, and epics to Plane by simply setting up tokens.</p><p>Currently, these integrations and importers are only available on the cloud version. We plan to open-source our SDKs shortly so the community can request or contribute integrations as needed.</p><h3>What’s Next?</h3><p>In this post, I have highlighted some of the core features of Plane. In upcoming posts, we will discuss the AI features and the highly requested Plane Analytics feature more.</p><p>We are still in the early stages of development, and we appreciate the community’s feedback and support. In the meantime, I encourage you to visit the <a href="https://docs.plane.so/">Plane Official Docs</a> to learn more about the various features Plane offers developers and users.</p><p>If you like this project and wish to contribute, you can open new issues or send new pull requests in the project’s <a href="https://github.com/makeplane/plane">GitHub repository</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=d56dfac886ed" width="1" height="1" alt=""><hr><p><a href="https://medium.com/better-programming/introducing-plane-simple-extensible-open-source-project-management-tool-d56dfac886ed">Introducing Plane: Simple, Extensible, Open-Source Project Management Tool</a> was originally published in <a href="https://betterprogramming.pub/">Better Programming</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[10 Open-Source Projects For Web Developers In 2023]]></title>
            <link>https://medium.com/geekculture/10-open-source-projects-for-web-developers-in-2023-b972ac745ff?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/b972ac745ff</guid>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[open-source]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[saas]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Thu, 02 Feb 2023 22:02:26 GMT</pubDate>
            <atom:updated>2023-02-08T09:03:42.522Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wW0w3NORKgwhKfipq1L9bg.png" /></figure><p>Open source and devs are an open love affair that closed source doesn’t like. For those of you who don’t like declarations like that, ↓ is a set of metrics from Boston Consulting Group that should start warming you up.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_RS3o42OKLDC9-kOXjZuTQ.jpeg" /></figure><p>Stats irrespective, if you write code for web dev, you are wondering about the latest and greatest in open source in 2023. So, wonder no more and dive right into the ten tools you should pitch to your boss.</p><p>☝🏻 Factors in consideration when I came up with this list,</p><ul><li>Popularity</li><li>Community contributions</li><li>Support cadence</li><li>Speed of releases</li><li>New feature development</li><li>Security</li></ul><h3>Novu</h3><p><em>https://novu.co</em></p><blockquote>📢 In Novu’s words, “Novu is the open-source notification infrastructure for products. Add a notification center for your React, Vue, and Angular apps 🚀</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/880/0*pbEorfBtm1PN-1OR.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~16K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 3/5</li><li>Speed of Release: 3/5</li><li>Support cadence: 5/5</li></ul><p>Developing a notification layer is a common task when designing a new application. It typically starts with sending a simple email, but you may manage hundreds of notifications across multiple channels as the application grows. This can be a time-consuming and complex process. That’s where Novu comes in. Novu is an infrastructure development platform that helps developers build and deploy cloud-native applications. Its goal is to make it easier for developers to create meaningful, transactional communication between their product and its users.</p><p><strong>Pros</strong></p><ul><li>Easy to set up and integrate</li><li>Single API for all messaging providers (Email, SMS, Push, Chat)</li></ul><p><strong>Cons</strong></p><ul><li>No ORM-based configuration</li><li>No pricing plans on cloud-managed service</li></ul><p>Novu offers an easy-to-use API and a focus on developer experience. This means that developers can easily integrate notifications into their applications without worrying about the underlying infrastructure.</p><p>With Novu, you can,</p><ul><li><strong>Connect different Providers:</strong> Use a built-in collection of popular providers — Sendgrid, Mailgun, Twilio, and many more. Add the API key, and you’re ready to go.</li><li><strong>Set Multiple Notification Channels</strong>: Novu supports many notifications, including email, SMS, push notifications, and more. This means you can reach your users through their preferred channels and ensure that your messages are delivered.</li><li><strong>Use Dynamic Templates</strong>: Select channels, add content with {{dynamic}} syntax, and custom rules to control the delivery of notifications.</li><li><strong>Track Feed</strong>: Novu provides a notification activity feed that monitors every outgoing message associated with its relevant metadata.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://www.courier.com/">Courier</a></li><li><a href="https://www.magicbell.com/">Magicbell</a></li></ul><h3>Appsmith</h3><p><a href="https://www.appsmith.com/"><em>https://www.appsmith.com/</em></a></p><blockquote>📢 In Appsmith’s words, “Low code project to build admin panels, internal tools, and dashboards. Integrates with 20+ databases and any API.”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*am4OXPvDw3Sj1BML.jpeg" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~24.7K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 4/5</li><li>Speed of Release: 5/5</li><li>Support cadence: 5/5</li></ul><p>Appsmith is a low-code platform that allows developers to create software applications without writing extensive code. It provides a visual interface for building and connecting various components, such as forms, buttons, and data sources. This allows developers to prototype and builds functional applications with minimal effort rapidly.</p><p><strong>Pros</strong></p><ul><li>Several pre-built widgets to build any internal tool interface in just minutes.</li><li>Enterprise features — Advanced VCS, Audit Logs, Custom Branding, SSO.</li><li>Several self-hosted deployment options.</li></ul><p><strong>Cons</strong></p><ul><li>Responsive UI for mobile devices (Coming soon on their Roadmap)</li></ul><p>With Appsmith, you get,</p><ul><li><strong>Pre-built Widgets</strong>: Appsmith comes with a library of prebuilt widgets that you can use to build your application. These widgets include buttons, tables, forms, and charts with advanced properties like pagination, in-line editing, and events.</li><li><strong>Native integrations</strong>: Appsmith makes it easy to connect to your preferred databases and tools with over 20+ native integrations. These include popular options like Postgres, MongoDB, and Airtable, as well as the ability to connect to almost every API using the RESTful API or GraphQL plugin.</li><li><strong>JavaScript code support</strong>. You can use JavaScript inside {{ }} anywhere in Appsmith. You can reference every entity in Appsmith as a JavaScript variable and perform all JavaScript functions and operations on them.</li><li><strong>Version control with Git:</strong> This feature on Appsmith allows multiple developers to add their work in a git branch, raise a pull request for code reviews, integrate with CI/CD pipelines, and provide a commit history to go back to a previous version if something were to go wrong.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://retool.com/">Retool</a></li><li><a href="https://www.dronahq.com/">DronaHQ</a></li><li><a href="https://www.superblocks.com/">Superblocks</a></li></ul><h3>Supabase</h3><p><a href="https://supabase.com/"><em>https://supabase.com/</em></a></p><blockquote>📢 In Supabase words, “Supabase is an open-source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*TFiWVgWxPlo3reYz.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~44K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 4/5</li><li>Speed of Release: 5/5</li><li>Support cadence: 4/5</li></ul><p>In recent times, the competition between databases has evolved. After three decades of growth and improvement, Postgres has gained a reputation for dependability and high performance, making it a popular choice among businesses of all sizes. Oracle has compromised the open-source nature of MySQL, and with the increasing popularity of cloud storage, Postgres has become a leading open-source database option. The rise of Supabase, a Postgres-based alternative to Google’s Firebase, reflects the trend of open-source options challenging proprietary ones.</p><p><strong>Pros</strong></p><ul><li>Full Postgres database with Instant REST</li><li>It comes with email/social authentication</li></ul><p><strong>Cons</strong></p><ul><li>Its SDK only works with JS (Support for other languages is still in beta)</li><li>Security policies are limited in Real-time</li></ul><p>With Supabase, you can,</p><ul><li><strong>Set</strong> <strong>Database</strong>: The heart of most applications is storing data and providing users with fast, easy access. To achieve this, Supabase relies on PostgreSQL, an open-source, relational database. This tech enables Supabase to deliver a seamless experience storing, retrieving, and managing data within your applications.</li><li><strong>Configure</strong> <strong>Auth:</strong> Supabase makes integrating all major social apps easy, giving you various options for authenticating your application’s users. But if you prefer a more traditional approach, Supabase also supports email-password authentication.</li><li><strong>Write</strong> <strong>Edge Functions</strong>: Sometimes, you need to perform certain tasks asynchronously or run operations on the backend of your application. Supabase offers edge functions to handle these types of use cases. Deploying edge functions is easy, and Supabase distributes them globally to ensure that all users have a consistent, fast experience.</li><li><strong>Set-up</strong> <strong>Storage</strong>: As an administrator, the Supabase platform allows you to manage files from your browser easily. You can search, upload, view, and delete files with a few clicks. Supabase storage integrates seamlessly with PostgreSQL and provides a simple JavaScript API for you to use.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://firebase.google.com/">Firebase</a></li></ul><h3>Supertokens</h3><p><a href="https://supertokens.io/">https://supertokens.io/</a></p><blockquote>📢 In Supertokens words, “Open source alternative to Auth0 / Firebase Auth / AWS Cognito”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*lMCf7dWDjLfltE925AmFnw@2x.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~8K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 4/5</li><li>Speed of Release: 3/5</li><li>Support cadence: 4/5</li></ul><p>Supertokens is an open-source authentication platform that provides secure and scalable solutions for managing user authentication and authorization in web and mobile applications. One of the main benefits of using a library like supertokens for authentication is that it can save developers significant time and effort. Instead of writing the entire authentication system from scratch, developers can use the pre-existing and thoroughly tested code provided by supertokens. This can reduce the potential for errors and security vulnerabilities in the authentication process. Additionally, the open-source nature of supertokens means that developers have access to the source code, which allows them to customize and extend the library as needed to fit the specific needs of their project.</p><p><strong>Pros</strong></p><ul><li>Modular architecture makes the setup simple.</li><li>It provides an override feature that enables you to customize authentication fully and flows on both your front end and back end.</li></ul><p><strong>Cons</strong></p><ul><li>No not support many popular languages like Java and Php, and they do not have pre-built UI for popular frontend frameworks like Angular and Vue.</li><li>Lacks enterprise features like SCIM provisioning, admin, and organization support.</li></ul><p>In addition to its core authentication features, SuperTokens also offers a comprehensive, end-to-end solution for managing user sessions. With this solution, it’s easy to implement advanced features like synchronizing session data across multiple devices or limiting the number of devices a user can log in to. These capabilities can help you build more secure and functional applications, and SuperTokens makes it easy to implement them.</p><p>SuperTokens comes with,</p><ul><li><strong>Fully customizable UI for Auth</strong>: Supertokens comes with pre-built UI components when integrated, making it easy to implement authentication in your application. And the best part is that these UI components are fully customizable, so you can tailor them to match the look and feel of your application.</li><li><strong>Session Management</strong>: It provides a robust session management system that allows you to easily create, verify, refresh, and revoke user sessions with a high level of security.</li><li><strong>Role Management</strong>: Supertokens also includes a role management system that enables you to easily assign users to specific roles and control what actions they are allowed to perform within your application. This is accomplished by giving roles to sessions, so you can fine-tune different users’ access levels.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://auth0.com/">Auth0</a></li><li><a href="https://www.okta.com/">Okta</a></li></ul><h3>Appwrite</h3><p><a href="https://appwrite.io/"><em>https://appwrite.io/</em></a></p><blockquote>📢 In Appwrite’s words, “A complete backend solution for your [Flutter / Vue / Angular / React / iOS / Android / <em>ANY OTHER</em>] app”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*AhjCAOLXtJxBHy-olQxhzg.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~28K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 3.5/5</li><li>Speed of Release: 3/5</li><li>Support cadence: 4/5</li></ul><p>Appwrite is a popular open-source Backend-as-a-Service (BaaS) platform that provides various tools and features for building modern, feature-rich applications. It is an excellent solution for developers looking for a BaaS platform that is open-source and highly customizable. With Appwrite, you can easily set up a backend for your application and take advantage of features like real-time databases, file storage, serverless functions, and more.</p><p><strong>Pros</strong></p><ul><li>Better documentation for self-hosting instances.</li><li>Easy to get started.</li></ul><p><strong>Cons</strong></p><ul><li>• No managed option so it’s not fully serverless, but still a better option than building your own backend from scratch if you have legal requirements to host the BaaS yourself.</li><li>You have to handle web server security</li></ul><p>With Appwrite, you can,</p><ul><li><strong>Set-up</strong> <strong>Auth</strong>: Appwrite provides a complete user management system that allows developers to easily add authentication and authorization to their applications.</li><li><strong>Manage</strong> <strong>Data Storage</strong>: Appwrite offers a flexible and scalable solution that allows developers to easily store, retrieve, and query data.</li><li><strong>Write</strong> <strong>Functions</strong>: Appwrite provides a function’s runtime that allows developers to create custom backend logic and integrations without maintaining servers.</li><li><strong>Configure webhooks</strong>: You can receive an SMS notification when a new user registers for your app. You can also use webhooks to trigger actions such as purging the cache when one of your app’s documents is updated.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://firebase.google.com/">Firebase</a></li></ul><h3>Astro</h3><p><a href="https://astro.build/"><em>https://astro.build/</em></a></p><blockquote>📢 In Astro’s own words, “Astro is a website builder tool for the modern web — powerful developer experience meets lightweight output.”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/902/1*PlqHd8ak16gF_PcSD04VPg@2x.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~24K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 4/5</li><li>Speed of Release: 3/5</li><li>Support cadence: 4/5</li></ul><p>Astro is a new framework for building websites that allows you to use a JavaScript framework that outputs zero-JavaScript static site. By default, Astro delivers no JavaScript to the client and renders components into HTML. This helps to speed up the website’s performance, as more JavaScript can lead to slower loading times. If you do need to use JavaScript on your website, Astro offers the option to use partial hydration through client directives. These directives allow you to specify when and how a component should be hydrated or have JavaScript added to it.</p><p><strong>Pros</strong></p><ul><li>The Pattern provides all of the benefits of component-based architecture, such as reusability and maintainability.</li><li>Websites are SEO-friendly because all static content is rendered on the server.</li></ul><p><strong>Cons</strong></p><ul><li>There is not a lot of debate on the subject (Astro’s Island architecture).</li><li>A lot of frameworks claim to support the pattern, which makes it difficult to choose between them.</li></ul><p>One of the great things about Astro is that it supports popular component libraries like React/Preact (JSX), Svelte, Vue, and web components, making it easy for developers who are already familiar with these tools to get up and running quickly.</p><p>Astro pitches itself as,</p><ul><li><strong>Content-focused</strong>: Astro was designed for building content-rich websites. This includes most marketing sites, publishing sites, documentation sites, blogs, portfolios, and some eCommerce sites.</li><li><strong>Server-first</strong>: Astro leverages server-side rendering over client-side rendering as much as possible. This is the same approach traditional server-side frameworks — PHP, Ruby on Rails, etc. — have been using for decades. But you don’t need to learn a second server-side language to unlock it.</li><li><strong>Fully flexible</strong>: Astro is an all-in-one web framework with everything you need to build a website. Astro includes a component syntax, file-based routing, asset handling, a build process, bundling, optimizations, data fetching, and more.</li></ul><h3>Nhost</h3><p><a href="https://nhost.io/"><em>https://nhost.io/</em></a></p><blockquote>📢 In Nhost own words, “The Open Source Firebase Alternative with GraphQL.”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*N2TtJ5CPNtcKGlj2GoiLtA.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~24K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 4/5</li><li>Speed of Release: 3/5</li><li>Support cadence: 4/5</li></ul><p>In recent years, GraphQL has gained significant hype as an alternative to REST APIs. GraphQL is a query language that allows clients to request specifically shaped data from a server, leading to more efficient and flexible communication between client and server.</p><p>Nhost is a cloud-based backend platform that utilizes GraphQL to enable developers to build and deploy serverless applications faster. Nhost provides a range of features that make it easy to build scalable and feature-rich applications, including user management, data storage, serverless functions, real-time communication, and more.</p><p><strong>Pros</strong></p><ul><li>Provides instant Realtime GraphQL API based on your tables and columns in the database.</li><li>Supports serverless functions.</li></ul><p><strong>Cons</strong></p><ul><li>Real-time options are limited.</li></ul><p>One of the key benefits of using Nhost is that it allows developers to take advantage of GraphQL without worrying about the complexities of setting up and maintaining their own GraphQL server.</p><p>With Nhost, you can set up,</p><ul><li><strong>Auth</strong>: Nhost provides a complete user management system that easily adds authentication and authorization to your application. This includes support for popular authentication methods such as email/password, social login, and more.</li><li><strong>Serverless Functions</strong>: Nhost enables you to create custom backend logic and integrations without the need to maintain servers. This makes it easy to add custom functionality to your application and scale it as needed.</li><li><strong>Real-Time GraphQL API</strong>: Nhost includes a real-time communication engine that allows you to manage subscriptions to sync data in real-time.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://firebase.google.com/">Firebase</a></li></ul><h3>Hoppscotch</h3><p><a href="https://hoppscotch.io/"><em>https://hoppscotch.io/</em></a></p><blockquote>📢 In Hoppscotch own words, “Hoppscotch is light-weight, web based API development suite. It was built from the ground up with ease of use and accessibility in mind providing all the functionality needed for API developers with minimalist, unobtrusive UI. It is free-to-use and as an added perk completely Open Source!”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZoUTyLbUQak_MZl4UZ03iQ@2x.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~49K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 4/5</li><li>Speed of Release: 3/5</li><li>Support cadence: 4/5</li></ul><p>Hoppscotch is an open-source API testing tool that helps developers test and debugs their APIs quickly and easily. It is a lightweight tool that can be used to send HTTP requests and analyze the responses from the API.</p><p><strong>Pros</strong></p><ul><li>Lightweight and fast.</li><li>Documentation generator.</li><li>Support for WebSocket also allows SSE, <a href="http://socket.io/">Socket.IO</a> and MQTT</li></ul><p><strong>Cons</strong></p><ul><li>Little documentation</li><li>Missing features for test automation</li><li>Need to add some features by CLI.</li></ul><p>One of the critical features of Hoppscotch is its simplicity. It has a straightforward and intuitive interface that makes it easy for developers to get started with API testing. It also includes various features that make it easy to customize and automate API tests, including support for variables, environment management, and more.</p><p>Hopscotch comes with,</p><ul><li><strong>REST and GraphQL Support</strong>: Hoppscotch supports both REST and GraphQL APIs, making it a versatile tool that can be used to test APIs built using a wide range of technologies.</li><li><strong>Realtime Platform</strong>: Hoppscotch includes a real-time platform that allows developers to test and debug their socket or channel connections. This makes it easy to identify and fix issues as they arise.</li><li><strong>API Documentation</strong>: Hoppscotch allows developers to create comprehensive API documentation quickly and easily. This can be especially useful for helping other developers understand and use your API.</li><li><strong>PWA Support</strong>: Hoppscotch includes support for Progressive Web Apps (PWAs), making it easy for developers to test and debug the APIs used by their PWAs.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://www.postman.com/">Postman</a></li></ul><h3><strong>NocoDB</strong></h3><p><a href="https://www.nocodb.com/">https://www.nocodb.com/</a></p><blockquote>📢 In NocoDB own words, “Turns any MySQL, PostgreSQL, SQL Server, SQLite &amp; MariaDB into a smart-spreadsheet.”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3VLOaouZ_koDJyQ0FDaPbw.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~33K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 5/5</li><li>Speed of Release: 5/5</li><li>Support cadence: 4/5</li></ul><p>NocoDB is an open-source project that provides a web-based platform for building and managing online databases. It is designed to be easy and flexible, allowing users to create custom databases and workflows to meet their specific needs.</p><p><strong>Pros</strong></p><ul><li>Assign and track tasks, third-party integration available</li><li>Turn your SQL database into a smart spreadsheet</li></ul><p><strong>Cons</strong></p><ul><li>No cloud version (open in private beta)</li></ul><p>One of the key features of NocoDB is its customizable data model. Users can create custom database tables and define the fields and relationships between them. This allows users to model their data in a way that makes sense for their specific use case.</p><p>With NocoDB, you can</p><ul><li><strong>Set-up rich spreadsheet interface</strong>: Comes with several operations that allow for the configuration of a full spreadsheet feature, including CRUD operations, view permission types, and the ability to share bases and views.</li><li><strong>Set-up Automations</strong>: NocoDB includes support for automations, which allows you to automate repetitive tasks and workflows. This can help you save time and improve efficiency when working with your data.</li><li><strong>Configure</strong> <strong>Headless API</strong>: NocoDB includes a headless API that allows you to programmatically access and manipulates your data. This can be especially useful for developers who want to build custom integrations or applications that work with NocoDB.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://www.airtable.com/">Airtable</a></li></ul><h3>Strapi</h3><p><a href="https://strapi.io/"><em>https://strapi.io/</em></a></p><blockquote>📢 In Strapi own words, “The most advanced open-source headless CMS to build powerful APIs with no effort.”</blockquote><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*D6CmCWaZo9VpgjQfaRbJSA.png" /></figure><p>🔎 <strong>How they do on five for this list</strong></p><ul><li>~51K GitHub ⭐</li><li>Values for community contributions: 4/5</li><li>Values for new feature development: 5/5</li><li>Speed of Release: 5/5</li><li>Support cadence: 4/5</li></ul><p>Strapi is an open-source content management system (CMS) that allows developers to build and manage APIs for content-rich applications. It is designed to be easy and flexible, allowing developers to quickly build and deploy APIs for their applications.</p><p><strong>Pros</strong></p><ul><li>Rapid and scalable</li><li>Built-In authentication system</li><li>Multiple workflows for automations</li></ul><p><strong>Cons</strong></p><ul><li>Difficult to migrate existing APIs</li><li>TypeScript support Is limited</li></ul><p>One of the key features of Strapi is its plugin-based architecture. Strapi includes a range of plugins that allow developers to easily add functionality to their APIs, such as support for file uploads, email sending, and more. These plugins can be easily installed and configured, making it easy to customize the functionality of your API.</p><p>In addition to its plugin architecture, Strapi also includes a user-friendly admin panel that allows developers and content editors to manage their content easily. This includes support for creating and managing content types and previewing and publishing content.</p><p>With Strapi, you get,</p><ul><li><strong>GraphQL or RESTful</strong>: Strapi allows developers to choose using GraphQL or RESTful APIs, depending on their needs. This makes it a flexible platform that can be used to build APIs for various applications.</li><li><strong>Webhooks</strong>: Strapi includes webhooks support, allowing developers to trigger custom events and actions based on certain conditions. This can be especially useful for building integrations and automating workflows.</li><li><strong>Authentication &amp; Permissions</strong>: Strapi includes a user management system that allows developers to easily add authentication and authorization to their APIs. This includes support for popular authentication methods such as email/password, social login, and more.</li><li><strong>Internationalization</strong>: Strapi includes support for internationalization, which allows developers to build APIs that support multiple languages easily. This can be especially useful for building applications that cater to a global audience.</li></ul><p><strong>Closed source alternative</strong></p><ul><li><a href="https://www.contentful.com/">Contentful</a></li></ul><p>Thanks for reading this one! I would love to hear your thoughts and your list of open-source projects.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b972ac745ff" width="1" height="1" alt=""><hr><p><a href="https://medium.com/geekculture/10-open-source-projects-for-web-developers-in-2023-b972ac745ff">10 Open-Source Projects For Web Developers In 2023</a> was originally published in <a href="https://medium.com/geekculture">Geek Culture</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Open Source Projects Which Can Redefine Web Development in 2022]]></title>
            <link>https://medium.com/better-programming/5-open-source-projects-which-can-redefine-web-development-in-2022-567e7e2a6d12?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/567e7e2a6d12</guid>
            <category><![CDATA[front-end-development]]></category>
            <category><![CDATA[web-development]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[open-source]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Tue, 11 Jan 2022 16:38:33 GMT</pubDate>
            <atom:updated>2022-12-09T18:52:39.618Z</atom:updated>
            <content:encoded><![CDATA[<h4>Appsmith, Supabase, Appwrite, Plasmic, and Hasura</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Qb7WexnDZkvblFqz6_dUHg.png" /><figcaption>Image by author</figcaption></figure><p>Over the past few years, open-source projects have been an essential driving force behind modern web development. In the beginning, <strong><em>jQuery</em></strong> was the most popular project in the world.</p><p>But today, we have several popular projects like React, Vue, Next.Js, Django, Express, etc. These projects improved the way we dealt with the frontend, backend and made it easier to implement new and innovative features.</p><p>This year, we are likely to see some significant innovations in web development, especially with low-code, which can reduce development time and be easily scaled. These innovations will come from big players, some from startups, and some from <strong>open-source</strong> projects gaining popularity over the past few years. In this blog, I’ve rounded up five (listed in alphabetical order) of the most promising open-source web development projects that are definitely going to make a bigger splash this year!</p><h4><a href="https://www.appsmith.com/">Appsmith</a></h4><p>Stars: 24k | <a href="https://github.com/appsmithorg/appsmith">GitHub Repository</a> | <a href="https://discord.com/invite/rBTTVJp">Community</a></p><p><a href="https://www.appsmith.com/">Appsmith</a> is an open-source framework to quickly build any custom business software like admin panels, internal tools, dashboards, and more with pre-built UI widgets that connect to any database, GraphQL or REST API, controlling everything with Javascript.</p><p>Such software is often used in pretty much every organization (as well as for hobby projects). Often, developers spend countless hours on something like React or Angular to create these applications.</p><p><a href="https://www.appsmith.com/">Appsmith | Open-Source Low-Code Application Platform</a></p><p>Today, Appsmith has over 15+ Datasources and 35+ UI widgets. It’s great for teams and individuals who love to build personal or customizable internal apps hosted on their own platforms. Appsmith also offers a free cloud community edition with all the essential features needed to build a perfect internal tool.</p><blockquote><strong><em>How can Appsmith re-define web dev?</em></strong></blockquote><blockquote><em>Almost every organization or individual needs an internal application at some point; instead of building everything from scratch, this open-source low-code tool is the best go-to solution. It will cut development costs, save time, and let developers and businesses focus on more important things.</em></blockquote><h4><a href="https://appwrite.io/"><strong>Appwrite</strong></a></h4><p>GitHub Stars: 15.3k+ | <a href="https://github.com/appwrite/appwrite">GitHub</a>| <a href="https://discord.com/invite/GSeTUeA">Community</a></p><p>Appwrite is an open-source, end-to-end backend server for frontend and mobile developers that allows you to build apps much faster. Its goal is to abstract and simplify everyday development tasks behind REST APIs and tools, helping developers build advanced apps faster.</p><p><a href="https://appwrite.io/">Appwrite - Built for the first solocorn</a></p><p>This beautiful framework will save a considerable amount of developers time by bootstrapping all the backend needs, including database, storage, users, geo and localization, functions, console, privacy, and security. Today, the Appwrite server is packaged as a Docker container that you can easily set up using a simple docker-compose command from your terminal, either on your local machine or any cloud provider.</p><p>The Appwrite team plans to launch a cloud version to cut down all the additional configurations needed for self-hosting.</p><pre><strong>How can Appwrite re-define web dev? </strong></pre><pre>Developing and maintaining a backend-end is not an easy task. In 2022, relying on tools like Appwrite is the best way to ship applications faster. This not only saves time but gives developers complete control on the backend on the scale with very simple customizations.</pre><h4><a href="https://hasura.io/">Hasura</a></h4><p>Stars: 25k+ | <a href="https://github.com/hasura/graphql-engine">GitHub</a> | <a href="https://hasura.io/community/">Community</a></p><p>Hasura doesn’t need much of an introduction, it’s been here for a while, and is definitely one of the most loved projects in the open-source community.</p><p>The Hasura GraphQL Engine is a blazing-fast GraphQL server that gives you instant, realtime GraphQL APIs over Postgres, with webhook triggers on database events and remote schemas for business logic.</p><p><a href="https://hasura.io/">Instant GraphQL APIs on your data | Built-in Authz &amp; Caching</a></p><p>So if you need a super-fast GraphQLAPI engine without writing any code, Hasura is the go-to solution. Over the last year, Hasura has become strong with its features like serverless functions, fine-grained access control, admin UI &amp; migrations, and many more!</p><p>Hasura can run anywhere, from your local machine to the Heroku free tier to a server on Amazon, Google, or Microsoft. It is used and loved by technologists working for some of the world’s largest enterprises &amp; most exciting startups.</p><pre><strong>How can Hasura re-define web dev? </strong></pre><pre>Hasura is already a well-established tool for building powerful GraphQL APIs. In 2022, based on my experience and connections, several developer communities plan to migrate to GraphQL-based backends for their speed and scalability.</pre><h4><a href="https://www.plasmic.app/"><strong>Plasmic</strong></a></h4><p>Stars: 950+ | <a href="https://github.com/plasmicapp/plasmic">GitHub</a></p><p>Plasmic lets non-developers visually build pages and other presentational content, which developers can then render into existing websites and web application codebases.</p><p>Plasmic accepts logic, data, and behaviour with custom code for more complex digital component interactions. Depending on the framework you’re using, you can also extend Plasmic by creating your own UI components in it.</p><p><a href="https://www.plasmic.app/">Plasmic | Build powerful apps fast- without the limits</a></p><p>Designers, marketers, product managers, and more can use Plasmic to create pages — from landing pages to content pages to page templates; this saves a lot of time and back and forth communication between teams. Simply put, Plasmic can be a developer-friendly Webflow alternative that gives full control over the frontend.</p><p>The most common use case is consuming Plasmic designs like CMS content over an API. Still, you can also generate code into your codebase or even publish pages to platforms like Shopify. Plasmic ultimately aims to be the most versatile builder and integrate into any environment.</p><pre><strong>How can Plasmic re-define web dev? </strong></pre><pre>Plasmic can be a revolutionary product for the web. It empowers marketers, designers, content teams to ship applications directly and free up developers from pixel-pushing. While it’s easy to start with, Plasmic gives you tools never before seen in any design tool or page builder to let you create maintainable front ends at scale.</pre><h3><a href="https://supabase.com/"><strong>Supabase</strong></a></h3><p>Stars: 26.3K+ | <a href="https://github.com/supabase/supabase">GitHub</a> | <a href="https://discord.supabase.com/">Discord</a></p><p>Supabase is an open-source alternative to Firebase and is designed to allow for a quick setup of your backend. It primarily focuses on providing the four essentials at scale: Database (Postgres), Auth, File Storage, and auto-generated APIs.</p><p>All these can be easily set up and put in use directly from their excellent dashboard without writing any piece of code. Off-course these can be customized and tailored accordingly by adding our code-flavour.</p><p><a href="https://supabase.com/">Supabase | The Postgres Development Platform</a></p><p>Not just that, Supabase also comes with a Client, which makes it simple for developers to build secure and scalable products. If you’re new and getting started, I recommend <a href="https://egghead.io/courses/build-a-saas-product-with-next-js-supabase-and-stripe-61f2bc20">this</a> free course on egghead.</p><p>Today Supabase can either be on the cloud version or self-hosted on our own infrastructure using Docker. More details <a href="https://supabase.com/docs/guides/hosting/overview">here</a>. Not just the product, Supabase has great documentation and community. They open-source almost everything they build, even their UI library, Dashboard!</p><pre><strong>How can Supabase redefine web dev? </strong></pre><pre>Supabase is the best open-source alternative to Google’s Firebase and offers some great features that other real-time database solutions just don’t have. With this, developers can spend more time on focusing more the product rather than configuring the backend.</pre><p>Thanks for reading this one! I would love to hear your thoughts.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=567e7e2a6d12" width="1" height="1" alt=""><hr><p><a href="https://medium.com/better-programming/5-open-source-projects-which-can-redefine-web-development-in-2022-567e7e2a6d12">5 Open Source Projects Which Can Redefine Web Development in 2022</a> was originally published in <a href="https://betterprogramming.pub/">Better Programming</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Created My Own Stock Index Tracker with Time-Series Charts using Low-Code]]></title>
            <link>https://javascript.plainenglish.io/how-i-created-my-own-stock-index-tracker-with-time-series-charts-using-low-code-2e53cad5549f?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/2e53cad5549f</guid>
            <category><![CDATA[stock-market]]></category>
            <category><![CDATA[low-code]]></category>
            <category><![CDATA[programming]]></category>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[software-development]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Thu, 23 Dec 2021 06:42:41 GMT</pubDate>
            <atom:updated>2022-01-11T08:31:00.839Z</atom:updated>
            <content:encoded><![CDATA[<p>A step-by-step tutorial to build any dashboard or tracker with time-series charts using low-code!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5hks5c7coEa_TvXSLKfu2A.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@nampoh?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Maxim Hopman</a> on <a href="https://unsplash.com/s/photos/stock-market?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>I recently started investing and came across a product called Smallcase. The way it works is — experts create a diversified long-term portfolio of stocks &amp; ETFs and manage it on a timely basis for you. I really love the idea of how stocks can be added into portfolios or baskets to reduce market volatility. Unfortunately, at the moment, this product is only available for Indian investors and that led me to create an app, where I could create a portfolio, and also create a custom index on top of it, with features to compare benchmarked indices like Dow Jones / S and P.</p><p>Building this kind of application from scratch would have taken me a lot of time; I would have had to choose a front-end framework, configure a database, and work on different visualizing frameworks to build time-series charts. With <a href="https://www.appsmith.com/">Appsmith</a>, I was able to build this app in just a few hours. If you don’t already know, Appsmith is an open-source low code framework to build internal apps. In this blog, I will take you through the steps I followed to create the app.</p><p>First, let me share the specs of the app in a little more detail.</p><p>With this application, you can do the following:</p><ol><li><strong>Track stocks</strong>: Set filters on what stocks should be tracked, throughout the day by default or create specific lists.</li><li><strong>Make your own baskets</strong>: Create customized stock portfolios as baskets.</li><li><strong>Time-series charts to compare performances</strong>: Create a custom index for these portfolios and compare them with benchmark indexes using time-series charts.</li><li><strong>Notify</strong>: Send notifications and triggers when there are fluctuations in the market.</li></ol><p>In this blog, I will also dive into building some nifty time-series charts and build our stock index tracker that can compare with S&amp;P 500, Dow Jones, and NASDAQ.</p><p>Here are a few screenshots of the application:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*eUSGbXqnNUP6ueid" /><figcaption>Image by Author | Screenshot of Custom Index Tracker on Appsmith</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Vl_Vx7kdz8NJxHrg" /><figcaption>Image by Author | Screenshot of Custom Index Tracker on Appsmith — 2</figcaption></figure><p>Now, let’s get started!</p><h3>What All Did I Use to Build This Application?</h3><blockquote>TLDR; I’ve used <a href="https://www.appsmith.com/">Appsmith</a>, <a href="https://www.fusioncharts.com/charts/stock-charts">Fusion Charts</a> on Appsmith, APIs from <a href="https://marketstack.com/">MarketStack</a>, <a href="https://www.alphavantage.co/documentation/">Alphavantage</a>, and Google Sheets as the backend to build this application.</blockquote><p>This application primarily uses Appsmith, an open-source low-code tool that can connect to any database, API, or GraphQL to build admin panels, dashboards, and internal tools. Appsmith also supports charting options; it has an in-built extension that uses Fusion Charts to create data visualizations; this made it much easier to build my own time-series charts. To pull all the stock data and prices in real-time, I’ve utilized free APIs from MarketStack and Alphavantage.</p><p><em>(Please remember to generate your own API keys if you’re following this tutorial to build a similar app! To know more about generating your own API keys, read this blog)</em></p><p>I’ve used Google Sheets as my backend to watchlist stocks and store customized stock portfolios and baskets.</p><h3>Creating Baskets to Group and Track Stocks</h3><p>The first step to creating portfolios, or as I like to call them, “baskets,” is to build a user interface. Through this, a form can take in our portfolio name, time created, and a logo for easy viewing… and some vanity! 😎</p><p>It took me less than 5 minutes to create this with Appsmith and Google Sheets; here’s how I did it:</p><p>Note: I’ve used the Cloud Version (Community Edition, which is free) of Appsmith; you can build this either on a local version using Docker or a self-hosted version of Appsmith.</p><ul><li>Sign-up for a new free account on appsmith.com</li><li>Click on the + icon next to Datasources and choose Google Sheets as Datasource.</li><li>Authorize your Google Account, and create a new query by hitting the NEW API button after the data source is saved.</li><li>Renamed the query name to assBasket, as we’ll need to access query names on the UI.</li><li>I created a new google sheet with the following columns:</li></ul><pre>Basket Name<br>Basket Image URL<br>Basket Create On</pre><ul><li>Copied the URL of google sheets and pasted it under the SpreadSheet URL property.</li><li>Set the Query Type to Insert Sheet Row</li></ul><p>With this, our query is ready. Next, to build UI on Appsmith, you can just drag and drop widgets from the library on the right side of the screen. Appsmith’s canvas is quite responsive, and you can even drag widgets between two other widgets, and it will auto-resize, saving you valuable time! I added a container widget so that our app looks unified; we even have an option to add colors to this if we want to stylize the background a little more. I then dropped a text widget to set the app’s name and a button widget.</p><p>Here’s how it looks:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Wvp1hro9C7szrMW-" /><figcaption>Image by Author | Screenshot of Page 1 Custom Index Tracker</figcaption></figure><p>Neat, yeah?</p><p>Next, since we want there to be a form to create new baskets, we should get the button to open a modal. To do this, click the settings icon on the button widget to see the property pane.</p><blockquote>Property pane is where we can configure all the properties of the widgets. You can open this, by simply clicking on the widget, and you’ll see it docked on the right sidebar, just as shown in the above screenshot.</blockquote><p>We need to update the onClick property of the button and set it to open a new modal. You can create it there or drag and drop a modal widget onto the canvas. Both options work. You do you.</p><p>Next, we need three types of inputs for the form, so I added three input widgets to this modal. You can set the labels as follows:</p><pre>Basket Name<br>Basket Image URL<br>Basket Create On</pre><p>Here’s a Loom on how it looks like:</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.loom.com%2Fembed%2F6b495a92e85545a18346ee554b6090df&amp;display_name=Loom&amp;url=https%3A%2F%2Fwww.loom.com%2Fshare%2F6b495a92e85545a18346ee554b6090df&amp;image=https%3A%2F%2Fcdn.loom.com%2Fsessions%2Fthumbnails%2F6b495a92e85545a18346ee554b6090df-00001.gif&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=loom" width="1240" height="930" frameborder="0" scrolling="no"><a href="https://medium.com/media/cfed18aef465b9ec54f1628ea56ac255/href">https://medium.com/media/cfed18aef465b9ec54f1628ea56ac255/href</a></iframe><p>Things look in great shape so far, in order to be able to track the index of the portfolios based on created time, I thought it was best to use a pre-installed library on Appsmith since it’s not possible to track this manually. I used moment.js to do this.</p><p>We can set the Basket Created On default value to:</p><pre>{{moment().format(“MM ddd, YYYY HH:mm:ss a”)}}</pre><p>This will save time when the portfolio is created.</p><p>On Appmsith, we can write JS anywhere across the platform to add customization using the moustache {{ }} bindings. It also comes with the moment.js library; hence, calling the function will save time when these portfolios are created.</p><p>Lastly, I opened the buttons property-pane and set the onClick property to run a query and choose addBasket query.</p><p>With this, my UI is all set; lastly, I went back to addBasket query and set the Row Object to the following:</p><pre>{<br> &quot;Basket Name&quot;:{{Input1.text}},<br> &quot;Basket Image URL&quot;: {{Input2.text}},<br> &quot;Basket Create On&quot;: {{Input3.text}}<br>}</pre><p>Note that we will be collecting the values from the Input widgets and passing them to the Google Sheets via the addBasket query.</p><p>Next, to display all our baskets on this page, we need to create a new API. I created another one called getBasket, from the Google Sheets datasource. I updated the query method to Fetch sheet row list everything from the excel sheet. Here’s a screenshot:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*ju7FBAz0YgMkuRQ1" /><figcaption>Image by Author | Screenshot of getBasket query</figcaption></figure><p>Next, we have to bind our queries to the UI widgets. This part can be done like this:</p><ul><li>Open the property pane of List1 widget, and set the Items to {{getBasket.data}}</li><li>Inside the list widget, select the image and set the image property to {{currentItem[“Basket Image URL”]}}</li><li>Set the text widget properties to {{currentItem[“Basket Name”]}}, and Basket Created On: {{currentItem[“Basket Create On”]}}</li></ul><p>This is how it looks now:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*EF-oKgfLsrfkhFPq" /><figcaption>Image by Author | Screenshot of getBasket query</figcaption></figure><p>Here’s what we’ve been able to do till now:</p><ul><li>Added functionalities to add a new portfolio/basket and list them on Appsmith.</li></ul><p>Now, we will work on adding stocks inside these portfolios. For this, it would be best to create a new page to search for stocks and add them to baskets.</p><p>Let’s create a new page; you can choose the option on the left sidebar and name it as ‘Basket Page’. The idea is to redirect to this page from Page1 and filter all the stocks present in the basket.</p><p>But how do we filter stocks? Usually, we do on a regular backed to consider an id and filter based on it. Similarly, on Appsmith, while navigating to Basket Page, I stored the value of the basket page to filter and display data on the Basket page.</p><p>I can use the code snippet I mentioned below on a new button widget placed on the list widget. So, when clicked, it should save the selected item on the list, redirect to the basket page, and filter accordingly.</p><p>We need to the button’s onClick property to:</p><pre>{{<br>(function () {<br>    storeValue(&quot;selectedBasket&quot;, List1.selectedItem[&quot;Basket Name&quot;]);<br>    navigateTo(&quot;Basket Page&quot;) })() <br>}}</pre><p>Here, we need to use the storeValue from Appsmith to store the basket name in a variable named selectedBasket, the List1.selectedItem copies the data from the selected list item.</p><p>Next, we need to use the <strong>navigateTo </strong>function to redirect to a new page.</p><h3>Adding Stocks into Baskets</h3><p>Before we add any stocks into our portfolios, we’ll have to ensure that this page filters my stocks according to the selected basked from page one. So let’s add a container and a text widget to display the Basket name.</p><p>Note that this value comes from the global store, so on the Text property from Text widget’s property pane, we will have to bind value from the Appsmith store, and this can be done with a simple line:</p><p>{{appsmith.store.selectedBasket}}</p><p>Alright, the next cool feature for us to add is a search function. This way, we can easily search for stocks and add them to baskets; for this, we need to add another button and modal with the following fields:</p><ul><li>An input widget</li><li>A button labbeld as Seach</li><li>A table widget to list out all the results</li><li>A select widget to add them to the list of baskets I created</li></ul><blockquote>The table widget definitely deserves high praise. It allows us to add filters and sort results. We can add relevant stocks based on where they are listed on. For example, I could simply search NASDAQ, which filters stocks listed there. If you want to know everything that you can do with a table widget, you’ve got to check out this detailed blog.</blockquote><p>Before I tell you how I built this, here is how it looks like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*zm1Y_6UlZkjmDUsc" /><figcaption>Image by Author | Screenshot of Basket Page UI</figcaption></figure><p>The search feature works with a simple API from Stockdata, to integrate this, I followed the following steps:</p><ul><li>Click on the + icon next to the Datasources</li><li>Select Create New API, and paste the following URL:</li></ul><pre>https://api.stockdata.org/v1/entity/search?search={{stockcode.text}}&amp;api_token=YOUR_API_HERE</pre><ul><li>Rename the API query to stockSearch</li></ul><p>To get this working, make sure you add API token from Stockcode here. Please note that I use moustache bindings here. This adds the values I’m searching for from the input widget dynamically. Now, let’s head back to the modal and update the names of the widgets.</p><p>I renamed the widget names to the following, to make it easy while pushing data onto sheets:</p><p>Input Widget: stockcode</p><p>Table Widget: stockSearchTable</p><p>Now, the search API takes the value from the input widget, and on the table widget, we can bind the results from the API for the following functionalities:</p><ul><li>Set the buttons onClick property to run a query and choose stockSearch query.</li><li>Bind the stockSearch query to the table widget, using {{ stockSearch.data }}</li></ul><p>Next, we want to select which basket we want to add the searched stock to; for this, I just copied my API (getBaskets) from Page1, and bound it onto the selected widget with the following code:</p><pre>{{<br>getBaskets.data.map((row) =&gt; <br>  {<br>    return {<br>      label: row[&quot;Basket Name&quot;],<br>       value: row[&quot;Basket Name&quot;]<br>    }<br>  })<br>}}</pre><p>Last, we need to save all this information onto a Google Sheet, so let’s create a new spreadsheet under the same Google Sheet and create a new API from the connected data source. I named this sheet Watchlisted Stocks and named the query addtoBasket.</p><p>These are the columns I have on my Google Sheet:</p><pre>symbol <br>name<br>type<br>exchange<br>exchange_long<br>mic_code<br>country<br>watch_listed_on<br>basket</pre><p>Now, on the query to collect all this information, we have to update the Row Object to the following:</p><pre>{<br>&quot;symbol&quot;: &quot;{{stockSearchTable.selectedRow.symbol}}&quot;,<br>&quot;name&quot;:&quot;{{stockSearchTable.selectedRow.name}}&quot;,<br>&quot;type&quot;:&quot;{{stockSearchTable.selectedRow.type}}&quot;,<br>&quot;exchange&quot;:&quot;{{stockSearchTable.selectedRow.exchange}}&quot;,<br>&quot;exchange_long&quot;: &quot;{{stockSearchTable.selectedRow.exchange_long}}&quot;,<br>&quot;mic_code&quot;: &quot;{{stockSearchTable.selectedRow.mic_code}}&quot;,<br>&quot;country&quot;:&quot;{{stockSearchTable.selectedRow.country}}&quot;,<br>&quot;watch_listed_on&quot;: {{moment().format(&#39;MMMM Do YYYY, h:mm:ss a&#39;)}} ,<br>&quot;basket&quot;: {{Select1.selectedOptionValue}}<br>}</pre><p>With this last step, our watchlist will be ready. However, in order to show it on the page, we have to add a new table widget. Wait, I still had to pull all the watchlisted stocks from the google sheets. This is pretty straightforward, I create a new query from the GSheets datasource, set the method to Fetch Sheets Row, copy my GSheets URL, and update my Sheet Name to Watchlisted Stocks.</p><p>Now, we have to bind it on the new table widget, but here, it should only filter stocks that are added to this basket or portfolio, I do this by using a simple transforming when binding using the following code snippet:</p><pre>{{ <br>    getStocksfromBaskets.data.filter((item) =&gt; {<br>       return item.basket == appsmith.store.selectedBasket<br>    }) <br>}}</pre><p>As you can see, we’re now filtering our stocks based on the selectedBasket value from the Appsmith store that we saved while redirecting!</p><p>We now have all the portfolios and stocks ready. <br>Now it’s time for data visualization!</p><h3>Building Time Series Charts and Tracking Index</h3><p>As mentioned, Appsmith’s chart widget comes with the Fusion Chart configuration, which makes it much easier to build time-series charts. The other thing I love about this is, I can even create candlestick charts for the stocks I watchlisted inside the application. These charts are used by traders to determine possible price movement based on past patterns.</p><p>First, let me show you how to fetch details of all the stock prices, using the MarketStack API:</p><ul><li>Inside the basket page, I created a new API (marketStackAPI), with the following URL:</li></ul><pre>http://api.marketstack.com/v1/eod?access_key=YOUR_API_KEY&amp;symbols={{appsmith.store.current}}&amp;date_from=2021-11-01&amp;date_to=2021-12-12</pre><p>Note: I’m filtering the data from 2020–11–01 to 2021–12–12, you can update this API accordingly based on your requirements.</p><p>In the API, as you can see, I have added an Appsmith store variable named current; this is to dynamically fetch the stock prices of the symbol or stock we wanted to analyze or add to our tracker.</p><p>Now, we need to write a code snippet under JS Objects, that stores all the data for all the stocks that are there inside my portfolio.</p><p>This is what I’ve used:</p><pre>export default {<br> <br>getBasketGraph: () =&gt; {</pre><pre>let stocks = getStocksfromBaskets.data.filter((item) =&gt; <br>item.basket == appsmith.store.selectedBasket)<br>  <br>  let stockcodes = stocks.map(item =&gt; item.symbol)<br>  <br>  let allStockData = [];<br>  <br>  stockcodes.map((item, index)=&gt; {<br>    storeValue(&quot;current&quot;, item);<br>     marketStackAPI.run(()=&gt; {<br>     let tempData = marketStackAPI.data;<br>     allStockData.push(tempData.data);<br>    }, () =&gt; {}, { allStockData });<br>  })<br>  <br>  storeValue(&quot;allStockData”, allStockData)<br>  <br>  return appsmith.store.allStockData;<br> }<br>}</pre><p>Here is what this code snippet does:</p><ul><li>Stores all the symbols that are present in the basket in the stockcodes variable</li><li>Iterates through the stockcodes array and stores all the stock prices in a new variable allStockData</li><li>Returns the store variable when the function is executed</li></ul><p>To create a time series chart, we need to drag and drop a new chart widget onto the canvas, below the table widget.</p><p>This is how it looks like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*51lM8wcJ_xOD-hHE" /><figcaption>Image by Author | Chart Widget on Appsmith</figcaption></figure><p>It comes with a default configuration, so we will have to change the type to a Custom Chart to configure our data onto this. We will need to follow a particular format in order to do this. Here’s the basic config for Fusion Charts:</p><pre>{<br>  &quot;type&quot;: &quot;&quot;,<br>  &quot;dataSource&quot;: {<br>    &quot;chart&quot;: { },<br>    &quot;data&quot;: [ ]<br>  }<br>}</pre><p>Here, we need to pass in three parameters, the chart configuration, data, and the categories that need to be displayed on the x-axis. Here’s the updated code:</p><pre>{<br>    &quot;type&quot;: &quot;MultiAxisLine&quot;,<br>    &quot;dataSource&quot;: {<br>        &quot;chart&quot;: {<br>            &quot;xaxisname&quot;: &quot;Date&quot;,<br>            &quot;vdivlinealpha&quot;: &quot;&quot;,<br>            &quot;labeldisplay&quot;: &quot;ROTATE&quot;,<br>            &quot;theme&quot;: &quot;fusion&quot;<br>        },<br>        &quot;categories&quot;: [</pre><pre>{<br>                &quot;category&quot;: {<br>                    {<br>                        marketStackAPI.data.data.reverse().map((row, index) =&gt; {<br>                            return {<br>                                &quot;label&quot;: moment(row.date).format(&quot;LL&quot;),<br>                            }<br>                        })</pre><pre>}<br>                }<br>            }<br>        ],<br>        &quot;axis&quot;: [{<br>                &quot;title&quot;: &quot;Price&quot;,<br>                &quot;dataset&quot;: [{<br>                        &quot;seriesname&quot;: &quot;Apple&quot;,<br>                        &quot;data&quot;: {<br>                            {<br>                                marketStackAPI.data.data.map((row, index) =&gt; {<br>                                    return {<br>                                        &quot;value&quot;: row.close,<br>                                    }<br>                                })</pre><pre>}<br>                        }<br>                    },<br>                }<br>            ]<br>        }<br>    }</pre><p>Finally, this is how our graph will look like with the aforementioned configurations:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*kd-ozBtXC9XV_bQz" /><figcaption>Image by Author | Charts from Custom Index</figcaption></figure><p>Additionally, I also created a list, that tells us the index value with simple math:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*pGAd3-dHkcKlT-wR" /><figcaption>Image by Author | Custom Index and Predictions with Simple Math</figcaption></figure><p>Imagine having your own custom app terminal to track all your stock indexes in one place. If you’re into crypto, you can extend this app to even have a crypto tracker.</p><p>I hope that you had success following this tutorial and building your own app. If you got stuck somewhere, I’d be happy to help you out :)</p><p><em>More content at </em><a href="http://plainenglish.io/"><strong><em>plainenglish.io</em></strong></a><em>. Sign up for our </em><a href="http://newsletter.plainenglish.io/"><strong><em>free weekly newsletter</em></strong></a><em>. Get exclusive access to writing opportunities and advice in our </em><a href="https://discord.gg/GtDtUAvyhW"><strong><em>community Discord</em></strong></a><em>.</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2e53cad5549f" width="1" height="1" alt=""><hr><p><a href="https://javascript.plainenglish.io/how-i-created-my-own-stock-index-tracker-with-time-series-charts-using-low-code-2e53cad5549f">How I Created My Own Stock Index Tracker with Time-Series Charts using Low-Code</a> was originally published in <a href="https://javascript.plainenglish.io/">JavaScript in Plain English</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[A Simple Dashboard to Manage Newsletter with Low-Code]]></title>
            <link>https://codeburst.io/want-to-automate-your-apps-use-zapier-to-connect-specialized-platforms-2f5a0662f51f?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/2f5a0662f51f</guid>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Wed, 15 Dec 2021 07:14:17 GMT</pubDate>
            <atom:updated>2021-12-23T18:43:53.518Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/995/0*AAmrR5VlNJBM9kEB.jpg" /></figure><p>Automation has become the ‘it’ thing in the world of business. The need for organizations to cut costs has forced them to improve internal processes to provide improved service while also conserving time. Unfortunately, it’s not always easy for teams to streamline everything internally because they often seem like complicated processes — but there are ways around this. Using Appsmith, developing internal tools can cut costs, time and even improve your workflow by connecting services across specialized platforms with Zapier.</p><p>Zapier has thousands of apps and services that can meet almost all your business automation needs. Integrating Appsmith into the mix opens up a whole new dimension. In this way, you’ll have a more efficient system in which you can connect anything from, say, a MailChimp email campaign to a Google form with data from your ERP or CRM systems delivered within the app!</p><p>In this blog, we will be looking at adding automation to <a href="http://appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=internal_tools&amp;utm_campaign=weeklyblog&amp;utm_term=internal_tools">Appsmith</a> applications using <a href="https://zapier.com/"><strong>Zapier</strong></a>.</p><p>Let’s get started!</p><h3>Building Internal Tools with Appsmith</h3><p>Appsmith is a powerful platform to build admin panels, dashboards, crud apps, and internal tools. It allows us to create these applications with little to no coding required. We can build apps that integrate with just about any service you can think of. Today, Appsmith has more than 15+ data source integrations; a few popular ones include Postgres, MongoDB, Google Sheets. That’s one of the best things about Appsmith — it’s completely customizable. But if you want to build apps with Appsmith, you will likely be doing some coding in JavaScript. Yes, we can use JS anywhere across the Appsmith applications to bind, transform and create actions to the data. In terms of UI, Appsmith provides more than 25 widgets with a wide range of styling options. While it’s not hard to use Appsmith to build apps, you will need to start building them to get to the next level with Appsmith.</p><p>Now, let’s build a simple newsletter application that can help collect contacts from Appsmith and send Emails using Sendinblue via Zapier.</p><h3>Building UI on Appsmith</h3><p>The idea of our newsletter is to collect emails from users and to maintain campaigns on Appsmith. Let’s get started by following the below steps:</p><ol><li>Create a new account on <a href="https://www.appsmith.com/"><strong>Appsmith</strong></a> (it’s free!), if you are an existing user, log in to your Appsmith account.</li><li>Create a new application by clicking on the Create New button under the Appsmith dashboard.</li><li>We’ll now see a new Appsmith app with an empty canvas and a sidebar with two directories: Datasources and Widgets.</li><li>Click on the + icon next to the widgets section and drag and drop a container widget onto the canvas.</li><li>Next, bring in a form widget inside the container and two input widgets inside the form.</li><li>We can configure widgets and their properties by clicking on the cog icon on the top right. This will open a property pane where we can update all the widgets settings.</li><li>Now set the form labels to name and email.</li><li>Additionally, you can add a text widget to add aesthetics to our application; the following is how the UI looks like:</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*sMOoIn05VrErjEGJ.jpeg" /></figure><p>Excellent, our UI is now ready; let’s create a new Zapier workflow to connect to SendInBlue and manage our newsletter.</p><h3>Set Up Zapier with Appsmith</h3><p>Excellent, our UI is now ready; let’s create a new Zapier workflow that can connect to SendInBlue and manage our newsletter.</p><ul><li>First, create a free account on Zapier and select create custom workflow option from the dashboard.</li><li>On Zapier, every action on the workflow is named on Zap; to establish a connection between Zapier and Appsmith, let’s create a Webhook.</li></ul><blockquote><strong>Webhooks are essentially a way to create a communication channel. It allows you to listen to an event and run a command or take any action you want. Here, the event will be triggered by an API call from Appsmith.</strong></blockquote><ul><li>Now open the Appsmith app, click on the + icon next to the Datasource section from the sidebar, and choose Create New API.</li><li>Copy the webhook URL from Zapier and set the request type to POST. For ease, let’s also rename the query to <strong>addContact</strong>.</li><li>Here, we also need to send the data from the Form widget we had created earlier; now, let’s use their names to collect data and pass them in the Webhook.</li><li>Navigate to the Body tab on the API and paste the following code snippet:</li></ul><pre>{<br>&quot;name&quot;:&quot;{{Input1.text}}&quot;,<br>&quot;email&quot;:&quot;{{Input2.text}}&quot;<br>}</pre><ul><li>This code snippet will send the information from the Input widgets to Appsmith.</li><li>Lastly, set the button onClick property to execute a query and set it to <strong>addContact</strong>.</li><li>Now, on Zapier, hit the test button and send a request by filling the form on Appsmith and hitting the API. We should see the successful response on Zapier.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*E9X03x5_-5Km1WHI.jpeg" /></figure><ul><li>Next, click on the <strong>+</strong> icon beneath the zap to add a new workflow. Select the SendInBlue Zap from the list.</li><li>We will need to authenticate with SendInBlue from Zapier to access the workflow; for this, you can either create a new account or log in with your existing credentials.</li><li>Next, set the Action type to <strong>Add or Update in Sendinblue</strong> and fill in the details related to Email; here, we can also use the data sent from the Webhook. In the following screenshot, we select the EMail field data to be the email received from the webhook.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*id6cWpCaZBWumxM6.jpeg" /></figure><ul><li>Similarly, you can add a Send Transactional Email in Sendinblue action to the workflow using the Seninblue Zap.</li></ul><p>With this, whenever a new user subscribes to the Newsletter, he receives a confirmation Email and will be added to the contact list on Sendinblue.</p><p>And just like that, we could configure and build an entire Newsletter manager without writing code. This application can be extended in multiple ways, such as creating new email campaigns, filtering contacts, blocking users, and many more! The entire demo app of this tutorial can be found <a href="https://app.appsmith.com/applications/618a2f0b8e98010f12d9008a/pages/618a2f0b8e98010f12d9008c"><strong>here</strong></a>. This is just one example of how you can automate your apps on <a href="http://appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=internal_tools&amp;utm_campaign=weeklyblog&amp;utm_term=internal_tools">Appsmith</a>!</p><p>We hope that you will have a better idea of how to leverage automation in your Appsmith applications. For more information on automating your Appsmith applications, please contact me anytime at <a href="https://appsmith.hashnode.dev/vihar@appsmith.com"><strong>vihar@appsmith.com</strong></a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=2f5a0662f51f" width="1" height="1" alt=""><hr><p><a href="https://codeburst.io/want-to-automate-your-apps-use-zapier-to-connect-specialized-platforms-2f5a0662f51f">A Simple Dashboard to Manage Newsletter with Low-Code</a> was originally published in <a href="https://codeburst.io/">codeburst</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to Run Manual Jobs in Gitlab CI/CD]]></title>
            <link>https://vihark.medium.com/how-to-run-manual-jobs-in-gitlab-ci-cd-dec8ceac6711?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/dec8ceac6711</guid>
            <category><![CDATA[gitlab]]></category>
            <category><![CDATA[appsmith]]></category>
            <category><![CDATA[jenkins]]></category>
            <category><![CDATA[ci-cd-pipeline]]></category>
            <category><![CDATA[github]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Tue, 14 Dec 2021 05:14:09 GMT</pubDate>
            <atom:updated>2021-12-14T05:14:09.657Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*1drm3ABlj59e2FRR.jpeg" /></figure><p>Gitlab is eating the world, or so we thought till we moved to GitHub as an open-source company. That should tell you enough about our love for Gitlab, but there is one thorny problem with Gitlab CI that didn’t have a solution in any pricing tier. It’s the ability to trigger CI jobs with custom parameter values manually. This article will explore the benefits and drawbacks of manual jobs, potential workarounds, and finally, how using Gitlab API and forms, we can get around this problem.</p><h3>Why are manual jobs important in CI/CD?</h3><p>Although CI is primarily aimed to be continuous (I didn’t see that coming, did you?), there is still a precious place for manual triggering of jobs in a CI pipeline. This becomes especially apparent when we consider parameters in the build process. For example, you are working on a separate branch that does a PoC of a new feature. You want to ensure that the CI can handle the codebase in this branch but don’t want to push your official organization. So, if your build script took parameters (with sane defaults, of course) that can be configured to have the image pushed to your personal organization, you’ll be able to test it to your heart’s content. What’s more, you can even run the Docker image and check all is in order. Basically, you don’t break the app.</p><p>Another simple example would be when you have a specific set of servers you want to push your changes to from a specific branch in your repo. This is a case of CD, with finer control. You can use the same deploy pipeline but set the branch and server(s) variables and run this job to get the desired outcome. This becomes incredibly useful as the organization scales and has multiple branches, teams, and servers, especially in this age of mono-repos.</p><p>If you’re a pipeline wizard, you can probably spin off a new script each time for these jobs and run these scripts each time, but a more practical solution would be to use a pipeline template and have a few variables (set defaults for a standard run) that can be populated for manual runs. This is where Gitlab comes a bit short.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*A6OuiyDcPp86F_xl" /></figure><p><em>I have no idea what I am doing here!</em></p><h3>How do I run manual jobs using GitLab?</h3><p>If you’re willing to compromise on everything else Gitlab has to offer, Jenkins is your go-to for CI/CD and boy does it ship with an out-of-the-box manual job runner. But of course, who wants to compromise on all the other awesome stuff from Gitlab?</p><p>The biggest inconvenience stems from the fact that Jenkins and Gitlab are two separate systems. It’s up to the developer to ensure that these two talk to each other well and stay on good terms. For example, If the source code on Gitlab moves from being a Java project to a Golang project, the Jenkins build jobs must be configured to stop using Maven and start using go. Having Gitlab be the integrated solution for both your source code and your CI pipelines is just too convenient. The overheads of running Jenkins and Gitlab will just make your team grumble much more than usual.</p><p>Let’s say you do end up integrating with Jenkins, are you sure this is enough for you to sacrifice all of Gitlab’s CI/CD efficiencies for?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/582/0*XcVPNOFKSim8Z4ZB" /></figure><p><em>Do you want to integrate this with your repo?</em></p><h3>Manual Jobs For Gitlab</h3><p>Assuming you haven’t ripped apart your Gitlab instance and installed Jenkins, and you’re still asking yourself “So how does one trigger manual jobs for Gitlab?”, the main (and surprisingly the simplest) suggestion is to build a form for each job and use Gitlab API to trigger it — from the discussion for this issue from <a href="https://gitlab.com/gitlab-org/gitlab-foss/-/issues/24935">four years ago</a> (remember, Google is your friend). Why don’t we give that a shot? Sounds simple enough, right?</p><pre>&lt;!doctype html&gt;<br>&lt;html lang=en&gt;<br>  &lt;head&gt;<br>    &lt;meta charset=utf-8&gt;<br>    &lt;title&gt;Gitlab CI Trigger&lt;/title&gt;<br>  &lt;/head&gt;<br>  &lt;body&gt;<br>    &lt;form method=post action=&#39;gitlab-api-endpoint&#39;&gt;<br>      &lt;p&gt;<br>        &lt;label for=branch&gt;Branch&lt;/label&gt;<br>        &lt;select id=branch name=branch&gt;<br>          &lt;option value=master&gt;master&lt;/option&gt;<br>          &lt;option value=&#39;feature/one&#39;&gt;feature/one&lt;/option&gt;<br>          &lt;option value=&#39;feature/two&#39;&gt;feature/two&lt;/option&gt;<br>          &lt;option value=&#39;bug/that-nasty-bug&#39;&gt;bug/that-nasty-bug&lt;/option&gt;<br>        &lt;/select&gt;<br>      &lt;/p&gt;<br>      &lt;p&gt;<br>        &lt;input type=checkbox id=debug name=debug&gt;<br>        &lt;label for=debug&gt;Print debug output&lt;/label&gt;<br>      &lt;/p&gt;<br>      &lt;p&gt;<br>        &lt;label for=reason&gt;Reason for trigger&lt;/label&gt;<br>        &lt;input name=reason id=reason&gt;<br>      &lt;/p&gt;<br>      &lt;p&gt;<br>        &lt;button type=submit&gt;Run pipeline!&lt;/button&gt;<br>      &lt;/p&gt;<br>    &lt;/form&gt;<br>  &lt;/body&gt;<br>&lt;/html&gt;</pre><p>We’re not even getting started here 😰</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/354/0*ux61qM-qibBOp88X" /></figure><p>Voila? 🤔</p><p>But a few things to remember before we deploy that in production. You need to update the branch list whenever that changes, which is almost every day. Also, remember to add or remove any parameters along with your build pipeline. Every time you run a manual job, you essentially have to rebuild this file, or scope all potential manual jobs and have files ready. This is really inconvenient.</p><p>Beyond just being inconvenient, this method doesn’t scale. Even if you maintain this HTML form as part of your source code, it still warrants a significant maintenance effort. You don’t want to spend time building/debugging/fixing/maintaining your pipeline-runner, you want to build the software you are actually working on.</p><h3>The better way to manage CI/CD workflows</h3><p>Fear not, Appsmith is here. While not an official workaround, <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=gitlab&amp;utm_campaign=weeklyblog&amp;utm_term=gitlab">appsmith</a> makes it incredibly easy to create your forms and set up the API needed to run manual forms. Building the form will be easier than in Jenkins, API calls can be managed gracefully in the interface, AND you can build a job runner that looks like this in 10 minutes.</p><p>We’ve built a small tutorial to walk you through how we create a manual pipeline to deploy your code on multiple production servers. Let’s get started!</p><blockquote>Appsmith is an open-source cloud or self-hosted platform to build admin panels, CRUD apps and workflows. Appsmith helps you speed up application building through fast UI creation, and making you write code only when necessary.</blockquote><p>Here’s a video to get you started!</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2FCYdeJcD4I8A%3Ffeature%3Doembed&amp;display_name=YouTube&amp;url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DCYdeJcD4I8A&amp;image=https%3A%2F%2Fi.ytimg.com%2Fvi%2FCYdeJcD4I8A%2Fhqdefault.jpg&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=youtube" width="854" height="480" frameborder="0" scrolling="no"><a href="https://medium.com/media/d4d25c612c86d28490fdf8b39f5c8979/href">https://medium.com/media/d4d25c612c86d28490fdf8b39f5c8979/href</a></iframe><p>We’ll be building a dashboard on <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=gitlab&amp;utm_campaign=weeklyblog&amp;utm_term=gitlab">Appsmith</a> to simplify and manage a simple CI/CD workflow that allows developers to deploy software by selecting a specific branch and server.</p><p>Additionally, we’ll create options to</p><ul><li>View a Specific CI/CD Workflow</li><li>Cancel a Running Workflow</li><li>Retry a Failed Workflow</li><li>Delete a Workflow</li><li>Save Workflow History</li></ul><p>This dashboard is going to be created entirely using Appsmith and the Gitlab API.</p><p>We’ll be using a <a href="https://gitlab.com/confidence2/ci_cd/-/tree/master">Gitlab</a> repository named ci_cd to follow along and set up workflows. It’s a basic “Hello World!” Node.JS application that is deployed to multiple servers on Heroku. We have our .gitlab-ci.yml file configured in such a way as to run two jobs. The first job is to perform a test with the npm test command, and the second is t deploy our app onto Heroku using a ruby gem called dpl.</p><p>The entire workflow is configured dynamically so that it can be deployed to any Heroku server given a Heroku &lt;app-name&gt; and an &lt;api-key&gt;. To hide these key’s we’ll be setting these out in our environment variables to the workflow. Lastly, on Heroku, we have two deployment servers appsmith-ci-cd-server1 and appsmith-ci-cd-server2.</p><p>Below is a snippet showing the content of .gitlab-ci.yml file.</p><pre>image: node:latest</pre><pre>stages:<br>  - test<br>  - deploy</pre><pre>testing:<br>  stage: test<br>  script: npm test</pre><pre>deploying:<br>  stage: deploy<br>  image: ruby:latest<br>  script:<br>    - gem install dpl<br>    - dpl --provider=heroku --app=$heroku_app_name --api-key=$heroku_api_key</pre><h3>Building Dashboard on Appsmith</h3><p>Now that we have a clear picture of what’s cooking, let’s head to Appsmith and start building our Dashboard. If you haven’t signed up, you can get started for free, <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=gitlab&amp;utm_campaign=weeklyblog&amp;utm_term=gitlab">here</a>.</p><p>Next, let’s head over to our Appsmith dashboard and create a new application by clicking on the Create New button. We’ll be now redirected to a new application named “Untitled Application 1”. Now, let’s give our app a creative name, let’s call it Deploy Dashboard. Our first step is to build a feature that would list all the existing and future workflow history. To do this, let’s utilize Gitlab’s pipeline API, fetch all the details and display them onto the Appsmith table widget.</p><p>Let’s go ahead and configure our workflow API Gitlab.</p><h3>Setting up Gitlab API as Datasource</h3><p>In this section, we’ll be using the GitLab API as a data source to configure it with the Appsmith Deploy Dashboard application. Let’s now create a new API, we can do it by navigating to the API section under Page1 and clicking on Create New option.</p><p>Paste the following in the request form and click on <em>Save as Data Source</em></p><pre><a href="https://gitlab.com/api/v4/projects/:id">https://gitlab.com/api/v4/projects/:id</a></pre><p>Next, let’s follow the below steps to display all the existing workflows onto the Appsmith dashboard.</p><ol><li>Firstly, the id in the above GitLab API is a parameter to access details of a particular repository on Gitlab, you can find it on your repository page on GitLab.</li><li>To make things more clear, let’s rename the Datasource name as GitLab, we can do it by double-clicking on the existing one.</li><li>Next, let’s add a new key named PRIVATE-TOKEN under the headers section. We can find the value of PRIVATE-TOKEN from GitLab.</li><li>Navigate to the Preferences -&gt; Access Tokens on GitLab and create a new access token and paste it to the PRIVATE-TOKEN key on the Appsmith data source. (Also be sure to give it at list API scope)</li><li>Lastly, save the data source!</li></ol><h3>Getting Workflows List</h3><p>Our Datasource is up and running, now let’s head back to the API section on Appsmith and create a new API to fetch all the existing workflows on the repository. Now create a new API and set the name as get_pipelines. On clicking on the URL we have suggestions to use our previously configured GitLab data source. Use the suggestions and add /pipelines to its end. The URL should now look like the following:</p><pre>GET <a href="https://gitlab.com/api/v4/projects/:id/pipelines">https://gitlab.com/api/v4/projects/:id/pipelines</a></pre><p>Hit the Run button and you will be greeted with an array of the workflow linked to that repository! Sweet, isn’t it?</p><p>Now to make things cooler, let’s build UI to display all these CI/CD workflows on the Appsmith page. Click on the widgets on the navigation bar and drag and drop a table widget onto the canvas. You should see a new table with some pre-populated data. We should also see a floating pane, that consists of all the table properties. Under that pane, edit the Table Data property to the following:</p><pre>{{get_pipelines.data}}</pre><p>Now, we can see data from the get_pipelines API rendered on the table. You can go ahead to rearrange the column and disable columns that you don’t want showing up on the table i.e sha and updated_at.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/880/0*8zv-KzRmZIzaUI85" /></figure><h3>Triggering A Pipeline</h3><p>Now let’s add a new feature to trigger a new workflow on the same dashboard. To do this, we’ll create a new button by dragging and dropping a button widget. Rename the button to Trigger New Pipeline. Also, drag in a modal widget to the canvas. The button should be configured such that the modal is opened whenever it’s clicked. On the other hand, the modal’s type should be set to form modal and we’ll drag in two dropdowns with corresponding labels into it. The first dropdown should be configured to select a branch with the following options:</p><pre>[<br>  {<br>    &quot;label&quot;: &quot;master&quot;,<br>    &quot;value&quot;: &quot;master&quot;<br>  },<br>  {<br>    &quot;label&quot;: &quot;staging&quot;,<br>    &quot;value&quot;: &quot;staging&quot;<br>  }<br>]</pre><p>Similarly, we configure the second dropdown to show the server options that are configured on Heroku namely, appsmith-ci-cd-server1 and appsmith-ci-cd-server2:</p><pre>[<br>  {<br>    &quot;label&quot;: &quot;appsmith-ci-cd-server1&quot;,<br>    &quot;value&quot;: &quot;appsmith-ci-cd-server1&quot;<br>  },<br>  {<br>    &quot;label&quot;: &quot;appsmith-ci-cd-server2&quot;,<br>    &quot;value&quot;: &quot;appsmith-ci-cd-server2&quot;<br>  }<br>]</pre><p>Perfect, we should now see a great-looking modal on our Appsmith dashboard.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/694/0*5F5KZBxw6vzmZIhf" /></figure><p>Let’s head back to the API section and create a new API to trigger a workflow whenever the Confirm button from our modal is clicked. Let’s name this API as create_pipeline and set the value to the following:</p><pre>POST <a href="https://gitlab.com/api/v4/projects/:id/pipeline">https://gitlab.com/api/v4/projects/:id/pipeline</a></pre><p>Additionally, we have the option to provide variables and ref (meaning the source branch) in the body of this endpoint. We should configure the body as given in the below snippet.</p><pre>{<br>    &quot;ref&quot;: &quot;{{Dropdown1.selectedOptionValue}}&quot;,<br>    &quot;variables&quot;: [<br>       {<br>            &quot;key&quot;: &quot;heroku_app_name&quot;,<br>            &quot;variable_type&quot;: &quot;env_var&quot;,<br>            &quot;value&quot;: &quot;{{Dropdown2.selectedOptionValue}}&quot;<br>        },<br>       {<br>            &quot;key&quot;: &quot;heroku_api_key&quot;,<br>            &quot;variable_type&quot;: &quot;env_var&quot;,<br>            &quot;value&quot;: &quot;your_heroku_api_key_here&quot;<br>        }<br>    ]<br>}</pre><p>By looking at the above snippet, the ref key is obtained from the branch dropdown, which was previously configured, and in the variables section, the value of the heroku_app_name key is obtained from our server dropdown.</p><blockquote>You can find the value of heroku_api_key from your Heroku account under the Settings-&gt; API Keys section.</blockquote><p>Lastly, let’s head back to the modal and configure the onclick action of the confirm button to trigger the create_pipeline endpoint. Add the following JS snippet to the onclick property under the button settings.</p><pre>{{<br>create_pipeline.run(() =&gt; get_pipelines.run( closeModal(&#39;Modal1&#39;)), () =&gt; {})<br>}}</pre><p>Kudos! With this, we should be able to trigger a workflow from the Appsmith dashboard itself. Let’s now fine-tune this to have more features in the next section.</p><h3>More Fine Tuning</h3><p>Alright, in the last section, we’ll now add fine-grained controls such as deleting, canceling, retrying, and viewing workflows. These are quite similar to each other, let’s look at the delete workflow option and you can try adding the rest as an exercise :)</p><p>Deleting the CI/CD Workflow from Appsmith Dashboard</p><p>To implement this feature, let’s add head back to our table and add a new “Custom Colum”. You can find it under the table settings pane. Let’s name this column as delete. To make our dashboard more intuitive, we can set the column type to button and add the label as delete. Now let’s create a delete API under the APIs section and name it as delete_pipeline. Use the following endpoint to add functionality.</p><pre>DELETE <a href="https://gitlab.com/api/v4/projects/:id/pipelines/%7B%7BTable1.selectedRow.id%7D%7D">https://gitlab.com/api/v4/projects/:id/pipelines/{{Table1.selectedRow.id}}</a></pre><p>This API grabs the id of the selected row from the table, which is automatically set when the delete button is clicked. Heading back to the delete button, let’s configure the onclick action to run the delete_pipeline API and call the get_pipelines API on success to update the table. Here’s the configuration JS snippet:</p><pre>{{delete_pipeline.run(() =&gt; get_pipelines.run(), () =&gt; {})}}</pre><p>Perfect, now we have the ability to delete a specific workflow from the <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=gitlab&amp;utm_campaign=weeklyblog&amp;utm_term=gitlab">Appsmith</a> dashboard itself.</p><blockquote>Disclaimer: Clicking on this button will delete that pipeline for good. As a safety measure, you can add a confirmation modal to prevent accidental delete.</blockquote><p>Here’s a quick lookup to configure the other actions to play with our workflows:</p><p>Retry Workflow:</p><pre>POST <a href="https://gitlab.com/api/v4/projects/24888719/pipelines/%7B%7BTable1.selectedRow.id%7D%7D/retry">https://gitlab.com/api/v4/projects/24888719/pipelines/{{Table1.selectedRow.id}}/retry</a></pre><p>Cancel Workflow:</p><pre>POST <a href="https://gitlab.com/api/v4/projects/24888719/pipelines/%7B%7BTable1.selectedRow.id%7D%7D/cancel">https://gitlab.com/api/v4/projects/24888719/pipelines/{{Table1.selectedRow.id}}/cancel</a></pre><h3>Final Thoughts</h3><p>We are glad you made it this far. As a quick summary, here’s a gif to show everything we’ve built so far!</p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fgiphy.com%2Fembed%2F29t58DqSVHPx0DBOFT%2Ftwitter%2Fiframe&amp;display_name=Giphy&amp;url=https%3A%2F%2Fmedia.giphy.com%2Fmedia%2F29t58DqSVHPx0DBOFT%2Fgiphy.gif&amp;image=https%3A%2F%2Fi.giphy.com%2Fmedia%2F29t58DqSVHPx0DBOFT%2Fgiphy.gif&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=giphy" width="435" height="271" frameborder="0" scrolling="no"><a href="https://medium.com/media/d16d91c8d2db04e530b65ea5aa1b1747/href">https://medium.com/media/d16d91c8d2db04e530b65ea5aa1b1747/href</a></iframe><p>Honestly, that was a lot to take in, but we’ve been able to go through a complete flow of how you can build a custom dashboard to manage your ci/cd process. Also, <a href="https://app.appsmith.com/applications/60418f2126e31f5bfb676a34/pages/60418f2126e31f5bfb676a36">here’s</a> a quick demo of the app that we’ve built! And we are quite sure you’re bubbling with ideas on the limitless use cases you can build with this. So go into the world and build amazing stuff!</p><p>Are you stuck somewhere? We’re happy to help! Join us on <a href="https://discord.com/invite/rBTTVJp"><strong>Discord</strong></a> today! Follow <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=social&amp;utm_content=gitlab&amp;utm_campaign=weeklyblog&amp;utm_term=gitlab">Appsmith</a> on <a href="https://twitter.com/theappsmith"><strong>Twitter</strong></a>, <a href="https://www.youtube.com/appsmith"><strong>Youtube</strong></a>, and <a href="https://in.linkedin.com/company/appsmith"><strong>Linkedin</strong></a> to stay up to date. (</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=dec8ceac6711" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The Best Tools for Building CRUD Applications]]></title>
            <link>https://codeburst.io/the-best-tools-for-building-crud-applications-86651e5c74d4?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/86651e5c74d4</guid>
            <category><![CDATA[development]]></category>
            <category><![CDATA[ui]]></category>
            <category><![CDATA[api]]></category>
            <category><![CDATA[tools]]></category>
            <category><![CDATA[low-code]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Tue, 18 May 2021 16:54:36 GMT</pubDate>
            <atom:updated>2021-05-18T16:54:36.776Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*SVkPJ28ZKDc4Uig7xzz_fQ.jpeg" /><figcaption>Photo by <a href="https://unsplash.com/@ellenqin?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Ellen Qin</a> on <a href="https://unsplash.com/s/photos/balls?utm_source=unsplash&amp;utm_medium=referral&amp;utm_content=creditCopyText">Unsplash</a></figcaption></figure><p>Create, Read, Update, and Delete (CRUD) are the basic functions required for most applications. In other words, a CRUD application enables users to get data into and out of a data store.</p><p>For example, consider a note-taking app. You can create a new note that will get stored in a database (Create). You can see all your notes — which are retrieved from the database — each time you revisit the app (Read). You can edit the contents of a note (Update), and you can also remove a note (Delete). Due to their basic nature and the repetitive code that makes up most CRUD apps, they’re ideal for building with no-code or low-code tools.</p><p>No-code or low-code tools make software development more accessible because users don’t have to know how to write code to build an application. At least for some things, you can avoid the expense of a developer for simple builds or just build applications faster, usually with a drag-and-drop interface.</p><p>Whether a tool is no-code or low-code is definitely something you need to consider before adopting it into your workflow — do you need the tool to be usable for people with no coding experience? Or do you just need it to eliminate some repetitive coding tasks, like setting up web servers? — but that’s far from the only criteria to keep in mind.</p><p>This article compares a wide range of features of some of the best no-code and low-code tools for building CRUD applications. We’ll go over each tool’s flexibility, user-friendliness, scalability, price, and other unique features. By the time we wrap up, you should be able to make an informed decision as to which tool is best for your use case.</p><h3>1. <a href="https://www.appsmith.com/">Appsmith</a> “Appsmith open-source framework for CRUD apps, admin panels, and workflows”)</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*T7kySgxoRqEQ6Gd_.png" /></figure><p>Appsmith is an open-source tool ideal for building admin dashboards, CRUD apps, and workflows. This low-code tool features pre-built UI widgets such as tables, charts, forms, and a map viewer to help you build frontends that connect to your existing or new data sources. Appsmith is ideal for building internal tools, and although applications can be made public, it isn’t built for complicated UI interactions like you might see in modern e-commerce or consumer-facing websites.</p><h3>Features</h3><ul><li>Intuitive drag-and-drop widgets</li><li>Easily connects directly to and queries the <a href="https://docs.appsmith.com/core-concepts/connecting-to-data-sources/connecting-to-databases#supported-databases%20%E2%80%9CAppsmith%20list%20of%20supported%20databases%E2%80%9D">supported database</a> of your choice or use a REST or GraphQL API as your data source</li><li>Supports collaboration for app building and testing</li><li>Option to host on either the Appsmith cloud or your own Docker instance</li><li>Thorough documentation and video learning materials</li><li>Their standard plan with unlimited apps and pages is currently free</li><li>User authentication via Google or GitHub</li><li>Applications <a href="https://docs.appsmith.com/core-concepts/access-control#public-apps">can be made public</a></li></ul><h3>Downsides</h3><ul><li>You need to know how to write queries and some JavaScript to fully make use of the platform</li><li>No granular permissions for public-facing apps</li></ul><h3>2. <a href="https://www.budibase.com/%20%E2%80%9CBudibase%20open-source%20tool%20for%20building%20dashboards,%20admin%20panels,%20and%20other%20infrastructure%E2%80%9D">Budibase</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*6PyWrEtyTLyopGde.png" /></figure><p>Budibase is another open-source low-code tool to make it easier to build and ship internal tools and CRUD applications. It features integrations with <a href="https://www.budibase.com/integration/%20%E2%80%9CBudibase%20integrations%20list%E2%80%9D">several external tools</a>, supports most major databases, and allows you to use webhooks or CSV imports to populate data in your application.</p><p>Like Appsmith, Budibase is built for building web-based internal software, but it requires more work to get started as you need to install their client on your computer. This also means you won’t be able to let one of your non-technical team members make a quick change somewhere in your CRUD app without teaching them to use npm and the terminal.</p><h3>Features</h3><ul><li>Build and test applications offline</li><li>Attractive widgets alongside other style properties help you build beautiful UIs</li><li>Self-host your application on your infrastructure or host on the Budibase cloud</li><li>Connect to an external database or use Budibase’s built-in database</li><li>Extensive and well-thought-out documentation</li><li>Built-in authentication and user management</li></ul><h3>Downsides</h3><ul><li>Requires you to download a local client</li><li>JavaScript and command-line skills are required</li><li>No pre-built templates</li></ul><h3>3. <a href="https://www.knack.com/%20%E2%80%9CKnack%20no-code%20business%20app%20builder%E2%80%9D">Knack</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-eeb-TAOGhe91bTE.png" /></figure><p>Knack is a no-code tool for building CRUD applications and allowing users to view, update, manage, share, and analyze their data. Knack is great for building web-based internal apps that automate manual or paper-based processes, but it’s got some major limitations if you’re plugging into an existing data set. Since Knack only supports the built-in database, you’ll have to <a href="https://www.knack.com/faq/migrate-database">import your application data into Knack</a>, and it won’t be automatically kept in sync. Knack also has some pretty strict <a href="https://www.knack.com/api-limits">API limits</a>, so you’ll have to ask for an increased usage cap as you scale.</p><h3>Features</h3><ul><li>Application templates for different use cases to get started quickly</li><li>Applications are hosted at a unique URL, but you can also embed your app directly into your existing website</li><li>Built-in authentication, user management, email, and notification automation workflows</li><li>Built-in database</li><li>Option to <a href="https://vihar.hashnode.dev/%E2%80%9Chttps://docs.knack.com/docs/how-to-add-custom-code%E2%80%9D%20directions%20for%20adding%20JavaScript%20or%20CSS%20to%20app%20in%20Knack">write custom JavaScript and CSS</a> for further customization</li><li>Extensive documentation with lots of external learning materials and an active community forum</li><li>Options to <a href="https://learn.knack.com/article/wc3mkoirrr-do-more-with-knack#integrate_with_other_services%20%E2%80%9Cpartial%20list%20of%20integrations%20available%20for%20Knack%20with%20Zapier%20and%20Integromat%E2%80%9D">integrate hundreds of other services</a> to your app using Zapier and Integromat</li></ul><h3>Downsides</h3><ul><li>Works only with the platform’s own built-in database</li><li>No free plan. The Starter package begins at $39 per month after a fourteen-day free trial.</li><li>API rate limits could limit your ability to scale</li><li>Very plain UI components</li></ul><h3>4. <a href="https://bubble.io/%20%E2%80%9CBubble%20no-code%20app%20for%20building%20SaaS%20platforms,%20marketplaces,%20and%20CRMs%E2%80%9D">Bubble</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/960/0*cy1Kp85wlW66g6a4.png" /></figure><p>Bubble is a no-code tool primarily designed for building full-stack web applications. While you can build almost anything from CRUD apps to complex marketplace SaaS products, it is likely overkill for smaller internal tools. It’s complicated to learn and cannot be hosted on your own infrastructure, so you have to trust Bubble to keep your application running. The support for custom code is also rather limited as Bubble is primarily designed for non-coders.</p><h3>Features</h3><ul><li>Drag-and-drop, pixel-perfect, fully customizable widgets and designs</li><li>Handles deployment and hosting</li><li>No hard limits on the number of users, volume of traffic, or amount of data stored</li><li>Extensive documentation alongside an active community on YouTube and forums</li><li>Built-in user management systems with third-party authentication support</li><li>Built-in localization translates your app’s text automatically</li><li>Invite up to forty people to collaborate with managed permissions and access rights</li><li>Ability to import designs from <a href="https://www.figma.com/">Figma</a> and quickly convert them into functioning pages</li><li>You can use Bubble’s built-in code-free hosted data store or connect to your own SQL database or RESTful API as data sources</li><li>Robust marketplace for app templates and plug-ins to get you started faster</li><li>Free tier offering many essential features</li><li>Built-in version control with test and live environments</li></ul><h3>Downsides</h3><ul><li>Cannot be self-hosted to maximize security and performance</li><li>Separate billing plan required for each application</li><li>Admin interface is slow when building complex applications</li><li>Not designed for creating simple, internal tools</li><li>Steep learning curve</li></ul><h3>5. <a href="https://uibakery.io/%20%E2%80%9CUI%20Bakery%20internal%20tool%20and%20app%20builder%E2%80%9D">UI Bakery</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*O1z1C1fRFGJAWrUx.png" /></figure><p>UI Bakery is another no-code UI builder for creating internal tools and CRUD apps. It provides ready-made templates, predefined widgets, and other UI components you can use to build your application’s UI. In other words, UI Bakery handles only UI development, while you take care of providing data sources and third-party integrations.</p><p>Since UI Bakery is focused on internal tools, you likely won’t use it for public-facing apps, mobile apps, or customer-facing websites. It also requires a pretty high level of technical expertise to get started as you’ll find yourself editing JavaScript code to connect with a database or API as you build your CRUD app.</p><h3>Features</h3><ul><li>Drag-and-drop UI widgets</li><li>Ready-made templates</li><li>Authentication and user management through UI Bakery’s built-in tool or with Google, Twitter, or Facebook</li><li>Ability to lightly customize the look and feel of your app widgets</li><li>Handles app hosting on a unique URL</li><li>Connect to SQL databases such as Postgres, MySQL, Google Sheets, or Firebase, or use an HTTP API as a data source</li></ul><h3>Downsides</h3><ul><li>The free tier only allows you to trial the product</li><li>Very small community of users as it’s a relatively new product</li><li>Technical background needed to add data connections and API integrations</li><li>Cannot create custom components from scratch at this time</li></ul><h3>6. <a href="https://retool.com/%20%E2%80%9CRetool%20startup-%20to%20enterprise-level%20internal%20app%20and%20tool%20builder%E2%80%9D">Retool</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*TuiiFX2liFvLvwOU.png" /></figure><p>Retool is an enterprise-focused low-code platform for building custom internal CRUD applications using drag-and-drop building blocks. Like most tools discussed above, Retool is primarily a UI builder; you’ll have to write queries or custom JavaScript to fetch your data from a database or external API.</p><p>Retool’s free plan is very limited, and it will get expensive fast because they charge on a per end-user basis. That means you’ll pay $100 per month if you want your ten teammates to access your CRUD app on Retool!</p><h3>Features</h3><ul><li>Provide your own data via a connection to most databases or <a href="https://retool.com/integrations/%20%E2%80%9CList%20of%20Retool%20integrations%E2%80%9D">anything with a REST, GraphQL, or gRPC API</a></li><li>Built-in authentication, authorization, and audit log management</li><li>Can host on-premises via Docker or Kubernetes or through Retool with a unique URL</li><li>Supports version control with syncing a Git repository</li><li>Variety of ready-made templates</li><li>Option to customize with JavaScript</li><li>Extensive documentation and active community forum</li></ul><h3>Downsides</h3><ul><li>Limited free tier with an expensive price point for large teams</li><li>Must write your own database queries or HTTP requests to interact with data sources</li><li>Does not support public-facing applications</li></ul><h3>7. <a href="https://www.glideapps.com/%20%E2%80%9CGlide%20no-code%20app%20builder%20platform%E2%80%9D">Glide</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*tZSb7K8UfT3AmZpy.png" /></figure><p>Glide is a no-code CRUD application builder that exclusively uses Google Sheets as a data source. While this is a serious limitation for many use cases, it also makes it very easy for non-technical users to build out prototypes of internal or public-facing web applications.</p><p>While Glide integrates with <a href="https://zapier.com/">Zapier</a> to allow you to integrate with other services, the automation workflows are still rather limited. It’s not a bad prototyping tool, especially if you want to give your non-technical team members the ability to create mobile apps, but you’ll run into its limitations pretty quickly.</p><h3>Features</h3><ul><li>Convenient drag-and-drop interface builder</li><li>Prebuilt ready-to-use templates and apps to help you get started quickly</li><li>Supports iOS and Android deployments so you can build multiplatform apps</li><li>Simple deployment to Glide’s servers and the option to use your own domain</li><li>Straight-forward documentation and an active community forum</li></ul><h3>Downsides</h3><ul><li>Free tier only supports mobile apps</li><li>Can’t use external data sources or APIs</li><li>Limited integrations and automation options</li></ul><h3>8. <a href="https://airtable.com/%20%E2%80%9CAirtable%20spreadsheet-like%20database%20platform%E2%80%9D">Airtable</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*YdQOLlhJXPfgLF7L.png" /></figure><p>Airtable is a platform for creating and sharing relational databases via a spreadsheet-like interface, but you can also use it for very limited types of CRUD applications. The user interface is simple, colorful, and friendly, and it allows anyone to spin up a database in minutes. Each Airtable base comes with an API and a limited amount of free storage.</p><p>While it’s easy to get started using Airtable — even for non-technical team members — you have very limited options for customizing Airtable yourself. It doesn’t sync with other databases or API sources, the permissions are not very granular, and there are limited options for creating user interfaces with Airtable.</p><h3>Features</h3><ul><li>Supports integration with <a href="https://airtable.com/marketplace%20%E2%80%9CAirtable%20apps%20for%20integration%E2%80%9D">other Airtable apps</a>, <a href="https://airtable.com/integrations%20%E2%80%9Clist%20of%20supported%20third-party%20integrations%E2%80%9D">third-party services</a>, or your own custom apps using their API</li><li>Supports real-time collaboration and device syncing</li><li><a href="https://airtable.com/templates">Template library</a> that showcases different use cases</li></ul><h3>Downsides</h3><ul><li>Must use Airtable’s storage system and cannot integrate with an existing database without custom code</li><li>API limits you to <a href="https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API">5 requests per second</a></li><li>Can get expensive for large teams as pricing is on a per-user basis</li><li>Documentation is difficult to locate and navigate</li><li>Cannot self-host or use custom domains</li></ul><h3>9. <a href="https://www.jetadmin.io%20%E2%80%9CJet%20Admin%20no-code%20internal%20tool%20builder%E2%80%9D/">Jet Admin</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8VIi0CVKnA0uP_FK.png" /></figure><p>Jet Admin is another no-code internal CRUD application builder. It provides a simple drag-and-drop interface that allows you to connect blocks and add custom workflows to automate backend processes. While they have a number of integrations, they don’t currently support DynamoDB, MongoDB, or Zapier, so your options for databases and automation are somewhat limited.</p><h3>Features</h3><ul><li>Free tier includes support and a user onboarding program</li><li><a href="https://www.jetadmin.io/templates">Library of templates</a> that cover some common use cases</li><li>Self-hosted options using AWS, Heroku, or your own dedicated server</li><li>Built-in collaboration, authentication, and authorization options</li><li>Custom JavaScript, HTML, and CSS support to extend core layouts and functionality</li><li>Supports limited public-facing applications via its customer portal</li></ul><h3>Downsides</h3><ul><li>Data sources and automations are still rather limited</li><li>Must maintain your own data source, so a developer is likely required to set up and modify fields</li><li>Free plans are limited and don’t allow collaboration with your team</li></ul><h3>10. <a href="https://internal.io/%20%E2%80%9CInternal%20no-code%20builder%20for%20internal%20apps%E2%80%9D">Internal.io</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*g4veCcd725w_Gl7q.png" /></figure><p><a href="http://internal.io/">Internal.io</a> is another no-code tool for building internal apps on top of an existing database, API, or business application. It features an intuitive interface for non-coders but also includes robust tools for developers and granular access controls to your CRUD application.</p><p>While the granular controls and enterprise SSO options are appealing for some use cases, there’s no option to make an application public with <a href="http://internal.io/">Internal.io</a>. You will also pay on a per-user basis, so it can cost you hundreds of dollars per month to run an application for your whole team.</p><h3>Features</h3><ul><li>Supports relational databases, non-relational databases, spreadsheets, and certain HTTP-based services as data sources</li><li>Granular permissions and access control</li><li>Drag-and-drop UI widgets</li><li>‍Automatically generates functions for CRUD operations on your databases without queries or API work</li><li>Option to use JavaScript to add customized business logic</li><li>Supports multiple environments (eg, staging and production)</li></ul><h3>Downsides</h3><ul><li>No ready-made templates</li><li>Expensive for large teams</li><li>Does not support public-facing apps</li><li>Documentation is heavily focused on developers and not the no-code users</li></ul><h3>11. <a href="https://www.appsheet.com/%20%E2%80%9CAppSheet%20no-code%20app%20building%20platform%E2%80%9D">AppSheet</a></h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*-j0WooVUdN7eD0m4.png" /></figure><p>AppSheet is another no-code application builder somewhat similar to Glide. AppSheet is a part of the Google ecosystem, so it integrates with other Google products and lets you integrate machine learning algorithms with your app without the need for a data scientist.</p><p>AppSheet might be a good option for building CRUD apps that are compatible across devices, but it only works with spreadsheets and a few select databases as data sources. If your application depends on an external API or a non-relational database like MongoDB, it’s not the right tool for you.</p><h3>Features</h3><ul><li>Multi-platform apps support web, desktop, and mobile deployments</li><li>Supports collaboration with team members</li><li>Collection of <a href="https://www.appsheet.com/SampleApps">sample apps</a> covering common use cases</li><li>An active community forum</li><li>Primarily focused on public-facing apps</li></ul><h3>Downsides</h3><ul><li>Free plan allows only prototyping and testing. Deploying your app requires a paid plan</li><li>Limited options for data sources (no support for HTTP APIs or MongoDB)</li><li>Documentation is difficult to navigate</li></ul><h3>Conclusion</h3><p>Every application is different, so depending on the specifics of your CRUD app, your choice of tools will vary.</p><p>If your team is non-technical and wants something that <em>just works</em> without involving a developer, Knack or Bubble might be a good option. On the other hand, if your team includes developers who want to build an internal tool faster with lots of options for presenting and manipulating data, <a href="https://www.appsmith.com/">Appsmith</a> might be the right choice.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/881/0*iVoww8BfCw7KHsCM" /></figure><p>With so many different strengths and feature sets, something is bound to fit your business’s needs for internal and external apps. Happy building!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=86651e5c74d4" width="1" height="1" alt=""><hr><p><a href="https://codeburst.io/the-best-tools-for-building-crud-applications-86651e5c74d4">The Best Tools for Building CRUD Applications</a> was originally published in <a href="https://codeburst.io/">codeburst</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Build an Investor CRM using Appsmith on Google Sheets]]></title>
            <link>https://vihark.medium.com/build-an-investor-crm-using-appsmith-on-google-sheets-73565a16da77?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/73565a16da77</guid>
            <category><![CDATA[open-source]]></category>
            <category><![CDATA[ui]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[crm]]></category>
            <category><![CDATA[startup]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Wed, 12 May 2021 12:50:54 GMT</pubDate>
            <atom:updated>2021-05-12T12:50:54.899Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*L5YeN5_299Xz-r6Ps3n8Jw.jpeg" /><figcaption>Photo by <a href="https://www.pexels.com/@scottwebb?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Scott Webb</a> from <a href="https://www.pexels.com/photo/shapes-and-pattern-2346594/?utm_content=attributionCopyText&amp;utm_medium=referral&amp;utm_source=pexels">Pexels</a></figcaption></figure><p>Most founders talk to 10s, if not 100s of investors. Keeping track of the conversations, files shared, and specifics of each investor is hard. Most of the time, we find ourselves rummaging through our inbox for that last email received, the previous file sent or the following action steps.</p><p>Many rely on spreadsheets (Google Sheets, usually) to list down the bare minimum of next steps, notion or google docs for the notes, and everything else on email to “streamline” the fundraising process. We know that’s not efficient from our experience, and we thought why not take a leaf out of our sales team and use a CRM to track our investor conversations.</p><p>So we went ahead and built an investor CRM that we’ve been using for our fundraising. We used Appsmith and the Google Sheets Integration to build this. Feel free to develop or fork <a href="https://app.appsmith.com/applications/6098bdc65864501cc39c3d2f/pages/6098bdc65864501cc39c3d31">this</a> application and extend it to however you want.</p><p>In this tutorial, we’ll build an essential Investor CRM, which will let you:</p><ul><li>Build unique profiles for the fund and investor</li><li>Filter saved investors by fund specifications and interests levels</li><li>Track conversations, see the most recent interaction</li><li>Set deadlines and reminders for action items</li><li>Manage file sharing by keeping track of files shared with each investor</li></ul><p>Here’s a screenshot of how the app looks like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*aJR_qLO4whO4NisFkSwqFw.jpeg" /><figcaption>Screenshot of Investor CRM built on Appsmith</figcaption></figure><blockquote><a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=direct&amp;utm_content=google_sheets_crm&amp;utm_campaign=weeklyblog&amp;utm_term=google_sheets_crm">Appsmith</a> is an open-source framework that lets developers build dashboards, workflows, and CRUD apps with only the necessary code. You can connect to any API or databases like MongoDB, PostgreSQL, or MYSQL and get access to multiple widgets, including charts, tables and forms, for building a UI really fast.</blockquote><p>Let’s dive right in!</p><h3>Setting Up Google Sheets and Appsmith</h3><p>To build this application, we’ll be using Appsmith’s Google Sheet Plugin. This will allow us to use our Google Sheet as a data source and help us build a custom CRM with a beautiful UI on Appsmith. Follow the below steps to integrate Google Sheets with Appsmith:</p><ul><li>Create a new account on <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=direct&amp;utm_content=google_sheets_crm&amp;utm_campaign=weeklyblog&amp;utm_term=google_sheets_crm">Appsmith</a> (it’s free!), if you are already an existing login to your Appsmith account.</li><li>Create a new application by clicking on the “Create New” button under the Appsmith dashboard.</li><li>We’ll now see a new Appsmith app with an empty canvas and a sidebar with Widgets, APIs and DB Queries.</li><li>Click on the + icon next to the APIs section and choose the Google Sheets option. Next, click on the New Datasource button and set the scope to Read and Write and click Authorise.</li><li>This will ask us to log in from our Google Account, choose the account we want to access Google Sheets with and log in. After successful authorisation, this will redirect back to your Appsmith account.</li><li>Now, you’ll find your Google Sheets Datasource under your APIs, and you can create the necessary queries by choosing this data source.</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iXr-5W_j7y1xr1Qeb3-bAg.gif" /><figcaption>Google Sheets Plugin on Appsmith!</figcaption></figure><p>Awesome! Now that our Google Sheets Plugin is set up, let’s create a new Google Sheet and add the necessary fields required for Investor CRM.</p><p>Let’s divide our Google Sheet into two sheets; in the first Sheet named “Investor Details”, let’s add all the information regarding the inventors and their specifics. Following are the fields we’ll be considering:</p><ul><li>Investment Fund</li><li>Location</li><li>Name of Investor</li><li>Designation</li><li>Interesting Portfolio Companies</li><li>Size of Fund</li><li>Ref Check Names</li><li>Ref Check Details</li><li>Website</li><li>Notes</li><li>Interest Levels</li></ul><p>In the second Sheet, “Notes”, let’s add all the notes/conversations related to these investors; we’ll use an identifier named id to filter our discussions based on the Investors. Additionally, we will also save the links to media/pitch decks that need to be shared with the Investors. Following are the columns we would need in the second Sheet.</p><ul><li>id</li><li>Notes</li><li>Date</li><li>Author</li><li>Files Shared Link</li></ul><p>To make this more precise, we’ve made a sample Google Sheet with some mock data <a href="https://docs.google.com/spreadsheets/d/19ewbxuiNwfD5etHpb__jMzFYjVdYaeLSviC951htlsI/edit#gid=333192">here</a>. We’ll be using the same Sheet throughout this tutorial, and you can either follow with this or create your own based on our requirements.</p><p>In the next section, let’s fetch all the investor information and display it on a beautiful table.</p><h3>Fetch Data from Google Sheet to Appsmith</h3><p>Now that we are connected to our Google Sheets data source, let’s connect to our Google Sheet and query all the data onto a table widget in Appsmith. To do this, navigate to the created data source under the APIs section and click on the New API button on the top right. Next, follow the below steps:</p><ul><li>After clicking the New API button, you’ll be redirected to a new query tab, name your API to getInvestorDetails by double-clicking on the existing one.</li><li>Now set the method to Fetch Sheets Row, this method will query the data that’s present in the given Google Sheet.</li><li>In the SpreadSheet URL property, paste the URL of your Google Sheet, in this tutorial we’ll be following with the following URL:</li></ul><pre>https://docs.google.com/spreadsheets/d/19ewbxuiNwfD5etHpb__jMzFYjVdYaeLSviC951htlsI/edit#gid=333192</pre><ul><li>Next, in the Sheet name, add the name of our first sheet which is Investor Details</li><li>The Table Heading Row Index property takes in the row number that basically has our column heading, we’ll set this to 1.</li><li>Next, we’ll set the Row Offset to 1 and Row limit to 100, this will query only the first 100 rows of our Google Sheet.</li><li>Lastly, click on the Run button on the top right, we should see the sheet information in JSON format in the response pane at the bottom. Below is the GIF showing the same:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*1SOsPI4gtQYzBtuLaoMr-A.gif" /><figcaption>Fetching data from Google Sheet onto Appsmith</figcaption></figure><p>Awesome, now that we have our data from the Google Sheet, let’s put this in a table; follow the below steps:</p><ul><li>Make sure the API is saved as getInvestorDetails</li><li>Next, click on the + icon next to the widgets and drag and drop a table widget onto the canvas.</li><li>Open the Table property pane by clicking on the cog icon on the top right of the table.</li><li>Now under the Table Data property, paste the following code snippet:</li></ul><pre>{{ getInvestorDetails.data }}</pre><ul><li>Here, we’re using the moustache syntax to bind the data from the API to the table widget.</li><li>With this, we should see the Table data with the investor details from the Google Sheet. Below is a GIF showing the same:</li></ul><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*JzI3rbUbVt5_KJDE-tYS-A.gif" /><figcaption>Binding data on Appsmith Table from Google Sheets Query</figcaption></figure><p>Perfect! We now binded our Investor Data into a table widget; you could play with it by opening the table’s property pane and displaying only required values or adding custom columns. Next, let’s add a feature to add new Investor Details to the Google Sheet from Appsmith.</p><h3>Insert Row to Google Sheet from Appsmith</h3><p>In this section, let’s learn to add a new row from Appsmith UI to Google Sheet. With this, we should be able to add new investor details for our Investor CRM. Let’s start by adding a button and showing a modal that has a form to add all the details of the new investors. Follow the below steps:</p><ul><li>Drag and drop a button widget on to the canvas and next open the property pane of the button by clicking on the cog icon on the top right of the button when selected.</li><li>Open the onClick property and select the Open Modal option and click on New Modal, this should open a new modal.</li><li>Now add the necessary form fields by dragging the Input widgets onto the Modal. In our case of Investor CRM, we will add the following fields:</li></ul><pre>- Investment Fund<br>- Location<br>- Name of Investor<br>- Designation<br>- Interesting Portfolio Companies<br>- Size of Fund    <br>- Website<br>- Notes<br>- Interest Levels</pre><p>Name the input widgets to follow to easily use them for other operations for our CRM.</p><ul><li>Investment Fund: addFund</li><li>Location: addLocation</li><li>Name of Investor: addInvestorInput</li><li>Designation: addDesignation</li><li>Interesting Portfolio Companies: addPortifolio</li><li>Size of Fund: addFundSize</li><li>Website: addWebsite</li><li>Notes: addNotes</li><li>Interest Levels: addIntrests</li></ul><p>Below is a screenshot of how our form should look like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*0rhMBRz8vL7wxqlP" /><figcaption>Form for Adding a New investor in the CRM</figcaption></figure><p>Now that we have our form ready, let’s write the logic to push the values from the form to the Google Sheet whenever submitted. Follow the below steps:</p><ul><li>Create a new API from the existing Google Sheets data source and set the query method to Insert Sheet Row. This query method helps us insert new data to the Google Sheet from Appsmith.</li><li>Name the query as addNewInvestor</li><li>Next, in the SpreadSheet URL property, add the link to our Google Sheet.</li><li>The Sheet Name will be Investor Details as named in our Google Sheet.</li><li>The Table Heading Row Index will be the row where the names of the columns are listed; in our case, this will be 1,</li><li>Lastly, the Row Object takes a JSON object with keys set to the column names associated with the desired values. In our case, below is how the Row Object should look like:</li></ul><pre>{<br>  &quot;Investment Fund&quot;: &quot;{{addFund.text}}&quot;,<br>  &quot;Location&quot;: &quot;{{addLocation.text}}&quot;,<br>  &quot;Name of Investor&quot;: &quot;{{addInvestorInput.text}}&quot;,<br>  &quot;Designation&quot;: &quot;{{addDesignation.text}}&quot;,<br>  &quot;Interesting Portfolio Companies&quot;: &quot;{{addPortifolio.text}}&quot;,<br>  &quot;Size of Fund&quot;: &quot;{{addFundSize.text}}&quot;,<br>  &quot;Website&quot;: &quot;{{addWebsite.text}}&quot;,<br>  &quot;Notes&quot;: &quot;{{addNotes.text}}&quot;,<br>  &quot;Interest Levels&quot;: &quot;{{addIntrests.text}}&quot;<br>}</pre><p>Here, the key’s are the column names in the Google Sheet, and the values associated with them are the names of the input widgets. The .text method is used to pick the text that&#39;s written in the input widgets.</p><p>Lastly, in the form below for the submit button, set the on click property to Call an API and call the addNewInvestor API from the options.</p><p>Our query is now complete, go ahead and try adding a new Investor Detail from the created UI. We should be able to see the updates on the Google Sheet automatically. Magical, isn’t it? In this way, we could add new data using the Insert Sheet Row query. In the next section, let&#39;s see how we can edit existing row data from Appsmith.</p><h3>Displaying and Updating Investor Details</h3><p>Displaying on the table is cumbersome, hence let’s shrink our table and show all the details in a different container. Additionally, let’s give the functionality to edit the details when displaying them. With Appsmith, all these are pretty straightforward. Now, first, let’s reduce the width of the table and only show the Investor Name and Company, we can do this by opening the property pane and clicking on the eye icon to make the other fields invisible. Next, follow the below steps:</p><p>Drag and drop a container and add necessary input widgets to display the Investor Details. In this case, we’ll be adding the following:</p><ul><li>Investment Fund: editFund</li><li>Location: editLocation</li><li>Name of Investor: editInvestorInput</li><li>Designation: editDesignation</li><li>Interesting Portfolio Companies: editPortifolio</li><li>Size of Fund: editFundSize</li><li>Website: editWebsite</li><li>Notes: editNotes</li><li>Interest Levels: editInterests</li></ul><p>Below is a screenshot of how our app should look like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*H8ZFdeVg9YP-MYPI" /><figcaption>Screenshot of App with Investor Details on Right</figcaption></figure><p>As we see in the image we have the Investor Table on the left, and the details on the right. Notice an Update Details button at the end? This button should help us the investor details wherever updated. Now in each of these inputs widgets, let’s use the selectedRow property from the table and display data.</p><p>Set the following to the Default text of input widgets in the investor details container:</p><ul><li>Investment Fund Input Widget: {{Table1.selectedRow.Investment_Fund}}</li><li>Name of Investor Widget: {{Table1.selectedRow.Name_of_Investor}}</li><li>Location Input Widget: {{Table1.selectedRow.Location}}</li></ul><p>Similarly, add the default text to the other widgets. Now, when a row is selected in the table you should have all the details of the selected investor in the investor detail container. Below is a screenshot of how it should look like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*5_RSkVg_ANw6eUqJ" /><figcaption>Investor Details showing up when a row is selected on the Table</figcaption></figure><p>Awesome! Our CRM is almost ready, but we missed one more thing in here; whenever we made changes in the input widgets and hit update details, the associated investor details should be updated in the Google Sheet. For this, let’s write a new update API that’ll help us update the values in the selected row of the Google Sheet. Follow the below steps:</p><ul><li>Create a new API from the existing Google Sheets data source and set the query method to Update Sheet Row. This query method helps us update row data in the Google Sheet from Appsmith.</li><li>Name the API to editInvestorDetail</li><li>Next, in the SpreadSheet URL property, add the link to our Google Sheet.</li><li>The Sheet Name will be Investor Details as named in our Google Sheet.</li><li>The Table Heading Row Index will be the row where the names of the columns are listed; in our case, this will be 1,</li><li>Lastly, the Row Object takes a JSON object with keys set to the column names associated with the desired values. In our case, below is how the Row Object should look like:</li></ul><pre>{<br>    &quot;rowIndex&quot;:{{Table1.selectedRow.rowIndex}},<br>    &quot;Investment Fund&quot;: &quot;{{editFund.text}}&quot;,<br>    &quot;Location&quot;: &quot;{{editLocation.text}}&quot;,<br>    &quot;Name of Investor&quot;: &quot;{{editInvestorInput.text}}&quot;,<br>    &quot;Designation&quot;: &quot;{{editDesignation.text}}&quot;,<br>    &quot;Interesting Portfolio Companies&quot;: &quot;{{editPortifolio.text}}&quot;,<br>    &quot;Size of Fund&quot;: &quot;{{editFundSize.text}}&quot;,<br>    &quot;Website&quot;: &quot;{{editWebsite.text}}&quot;,<br>    &quot;Notes&quot;: &quot;{{editNotes.text}}&quot;,<br>    &quot;Interest Levels&quot;: &quot;{{editInterests.text}}&quot;<br>}</pre><p>Lastly, for the Update Details button, set the onclick property to Call an API and call the editInvestorDetail API. We should now be able to update the investor details by editing the necessary input widgets and clicking on the update button.</p><p>Awesome, now we have a fully functional app that allows us to manage all our investor contacts. Now let’s extend this application by adding a new page to save all the conversations, media files related to each investor.</p><h3>Creating Conversations Page to Save Notes and Files</h3><p>A fully functioning CRM should also have all the details of conversations, files with the associated investor. For this, let’s create a new page where we display all the notes and conversations from the Investors. Follow the below steps:</p><ul><li>Create a new page and name it “Investor Conversations”</li><li>On this page, add a query to the URL to show only details of the selected investor. Now to the Appsmith URL, you see on the top add ?id=1. With this, we will filter all the investor details related to row one.</li><li>Now your data source will also be copied to these pages as well, click on the create New API from the existing data source to fetch the data from the second sheet which is Notes</li><li>Name the API as fetchInvestorDetails, next add the SpreadSheet URL and set the sheet name as Investor Details</li><li>Set the row offset to {{<a href="http://appsmith.url.queryparams.id/">appsmith.URL.queryParams.id</a>}}, this will query the row index given from the id param.</li><li>Lastly, set the row limit to 1, if you run the query you should see the details of investor details in the first row of the Google Sheet (as id is hard-coded to 1).</li></ul><p>Below is the screenshot showing the same.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*nb2pux7NXWnPjkGh" /><figcaption>Fetching particular row data using the Row Offset property</figcaption></figure><p>Awesome, let’s add some details regarding the investor to the conversation page before we list down the conversations.</p><ul><li>Now, on the conversation page, let’s add some Text Widgets to display the details of the Investors. Set the default text property to {{fetchInvestorDetails.data[0].Company}}</li><li>This will display the investor name based on the filtered id from the URL; later, we’ll have to pass this id dynamically from the investor table on the first page.</li><li>Now create one more API that fetches all the conversations from Sheet 2, which is notes.</li><li>Name the API to getConversationDetails, and set the query method to Fetch Sheets Row and add the link to Google Sheets URL under the Spreadsheet URL property.</li><li>Next, set the sheet name to Notes, and this will fetch all the information that’s listed in the Notes Sheet.</li><li>The Table Row Heading Index, Row Offset will be 1, and the Row limit will be 100; you can increase this based on the data on your Google Sheets.</li><li>Run the query. You should see all the notes listed down in the response pane in JSON format.</li></ul><p>Next, drag and drop a table on the Canvas and in the table property pane under the Table Data, paste the following JS code snippet:</p><pre>{{getConversationDetails.data.filter((note)=&gt;note.id === appsmith.URL.queryParams.id)}}</pre><p>Here, we’re filtering the notes only based on the query parameter that’s passed in the URL. Remember, we set the id to 1. Hence, we should see the conversations only from the first investor.</p><h3>Dynamically Passing the Query Params and Adding Notes</h3><p>Now on our conversation page, we’ve hardcoded the id parameter; that’s why we were able to see only notes from the first investor. Now let’s add a new column in the table that’ll redirect to the conversation page of the selected investor. We should pass the ID dynamically based on the rowIndex. Follow the below steps:</p><ul><li>First, open the table property pane in the Investor Details Page and click on Add A New Column.</li><li>Set the Column Type to Button and Label to View Conversations</li><li>Now when the button is clicked, it should navigate to the conversation page with the particular investor row id as a query parameter</li><li>Now set the onClick property to Navigate to Page, enter the Page name as Investor Conversations</li><li>Under the page name, you’ll find the Query Parameters property; add the following JS code snippet to pass the id as a query parameter:</li></ul><pre>{{ {id:Table1.selectedRow.rowIndex} }}</pre><p>Awesome, this will send the id variable as the query parameter when navigated to the Conversation page, thereby filtering the notes based on the investor.</p><p>Now let’s add a new API that will add new conversations to the investor’s details.</p><ul><li>Firstly, add a new Rich Text Editor to the Investor Conversation page and a button to add these notes to the list. Set the RTE input name to addConversation.</li><li>Now create one more API that adds new conversations to Sheet 2, which is notes.</li><li>Name the API to addNote, and set the query method to Insert Sheets Row and add the link to Google Sheets URL under the Spreadsheet URL property.</li><li>Next, set the sheet name to Notes, and Table Heading Row Index to 1.</li><li>In the Row Object paste the following JS code:</li></ul><pre>{<br>    &quot;id&quot;:&quot;{{appsmith.URL.queryParams.id}}&quot;,<br>    &quot;Notes&quot;: &quot;{{addConversation.text}}&quot;,<br>    &quot;Author&quot;: &quot;{{appsmith.user.name}}&quot;,<br>    &quot;rowIndex&quot;:&quot;0&quot;<br>}</pre><p>Awesome, this will add new notes to the Notes sheet in the Google Sheet. Also, make sure you call the addNote API when the “Add Notes” button is clicked.</p><h3>Wrapping Up</h3><p>Deploy your application on the cloud and share it with others, and that’s it. We’re done!</p><p>You’ve seen how easy it is to build an application on <a href="https://www.appsmith.com/?utm_source=blog&amp;utm_medium=direct&amp;utm_content=google_sheets_crm&amp;utm_campaign=weeklyblog&amp;utm_term=google_sheets_crm">Appsmith</a>, specifically a CRM with Google Sheets as a backend. This guide covered how to create an Investor CRM and connect it to a Google Sheets, as well as how to create, read, update and delete data. You learned how to build interactive pages, work with widgets, and customize them for your purposes.</p><p>We have made a slightly more robust application public here; try it out and let us know what you think. You can also check the live demo of our app <a href="https://app.appsmith.com/applications/6098bdc65864501cc39c3d2f/pages/6098bdc65864501cc39c3d31?utm_source=blog&amp;utm_medium=direct&amp;utm_content=google_sheets_crm&amp;utm_campaign=weeklyblog&amp;utm_term=google_sheets_crm">here</a>.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=73565a16da77" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[The past, present and future of deep learning]]></title>
            <link>https://medium.com/data-science/the-past-present-and-future-of-deep-learning-adb4d60eaf24?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/adb4d60eaf24</guid>
            <category><![CDATA[artificial-intelligence]]></category>
            <category><![CDATA[deep-learning]]></category>
            <category><![CDATA[computer-science]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[machine-learning]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Tue, 19 Jan 2021 15:28:41 GMT</pubDate>
            <atom:updated>2021-01-20T16:11:46.107Z</atom:updated>
            <content:encoded><![CDATA[<h4>A small story on the evolution of deep learning from the study of the human brain to building complex algorithms</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*iaTXvFnkdT7imxDW" /><figcaption>Frank Rosenblatt working on Perceptron (Source: <a href="https://news.cornell.edu/stories/2019/09/professors-perceptron-paved-way-ai-60-years-too-soon">Cornell Chronicle</a>, Division of Rare and Manuscript Collections)</figcaption></figure><p>TLDR; In this blog, you’ll be learning the theoretical aspects of deep learning (DL) and how it has evolved, right from the study of the human brain to building complex algorithms. Next, you’ll be looking at a few pieces of research that have been carried by renowned deep learning folks who have then sown the sapling in the fields of DL which has now grown into a gigantic tree. Lastly, you’ll be introduced to the applications and the areas where deep learning has set a strong foothold.</p><h3>Deep Learning: A brief history</h3><p>Over the past decade, no other technologies were important than Artificial Intelligence. Stanford’s Andrew NG called it the <strong><em>“New Electricity”</em></strong> and several tech giants, including Google, Microsoft and Apple, have changed their business strategies to become “AI-first” companies. And we can thank Deep Learning for all of that. Before getting started, let’s understand what DL is about and the reason behind its hype.</p><p>Deep learning, a subset of AI, is a computer technique to extract and transform data using multiple artificial layers of neural networks. These layers contain a set of artificial neurons which exist in a particular state. When data is sent into these layers, each layer takes input from the preceding layers and progressively refines them. The layers are then trained by algorithms that consistently reduce the errors and improve their accuracy of predictions. In this way, the network learns to perform a specific task.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/655/0*4p26rTVESssVCn-F" /><figcaption>Classes of Artificial Intelligence (Image by Author)</figcaption></figure><p>DL is slow compared to traditional AI and Machine Learning (ML) algorithms yet more straightforward and powerful. Hence, these are used across different domains ranging from medicine, science, social, manufacturing, supply chain, robotics and many more based on a single innovative type of model: the neural network. If you&#39;re wondering as to when DL dates back to, let me clear you that it isn&#39;t after all NEW; it has existed since the 1940s. Let’s dig into history to see how these were evolved from time to time.</p><h4>The McCulloch-Pitts (MCP) Model</h4><p>Neural Networks were first proposed in 1944 by Warren McCullough and Walter Pitts, two University of Chicago researchers who moved to MIT in 1952 as founding members of the <a href="https://books.google.com/books?id=RLKxSvCBQZcC&amp;q=%22first+cognitive+science+department+in+history%22#v=snippet&amp;q=%22first%20cognitive%20science%20department%20in%20history%22&amp;f=false">first cognitive science department</a>. The goal of their research, titled “<a href="https://www.cs.cmu.edu/~./epxing/Class/10715/reading/McCulloch.and.Pitts.pdf">A Logical Calculus of the Ideas Immanent in Nervous Activity</a>,” was to understand how the brain could produce highly complex patterns by using many interconnected cells. The very same theory has helped them to model a simple neural network using electronic circuits which was inspired by a real neuron. According to scholars, this paper is considered the beginning of artificial neural networks, although different opinions and questions exist.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*oWVgBOftOlR7ICpL" /><figcaption><strong><em>Warren McCulloch and Walter Pitts (Wikipedia Commons)</em></strong></figcaption></figure><p>The structure of the neurons was named after them “MCP (McCulloch Pitts) Neuron.” MCP neuron is often called <strong><em>linear threshold gate</em></strong> since it classifies the inputs into two different classes. Mathematically, the linear step function is defined as,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*H1eh63-MHmZ7vpVr" /><figcaption>The mathematical definition of Linear threshold gate (Image by Author)</figcaption></figure><ul><li><strong><em>y </em></strong>stands for the output</li><li><strong><em>xi </em></strong>stands for the input signals</li><li><strong><em>wi</em></strong> stands for the corresponding weights of a neuron</li><li><strong><em>Zj </em></strong>stands for inhibitory input</li><li><strong><em>Θ </em></strong>stands for the threshold</li></ul><p>The function is designed in a way that the activity of any inhibitory input completely prevents excitation of the neuron at any point of time.</p><p>Below is an illustration of Linear Threshold Gate by Kiyoshi Kawaguchi.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/512/0*xb7tfjZAwUMzz3rH" /><figcaption><em>Symbolic Illustration of Linear Threshold Gate by </em>Kiyoshi Kawaguchi</figcaption></figure><h4><strong>Hebbian Learning Rule</strong></h4><p>In 1949, six years after the inventions of MCP models, Donald O. Hebb strengthened the concept of neurons in his research titled, “<strong><em>The Organization of Behavior</em></strong><em>”</em>. For his substantial contributions towards deep learning, he’s also called the father of Neural Networks.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/324/0*HvvXLNQcdssf2b3i" /><figcaption>Donald Hebb (SRC: UBC Open Collections)</figcaption></figure><p>Now let’s see what Hebbian Rule is about; it states that the connection between two units should be strengthened as the frequency of co-occurrences of these two units increase.</p><p>To understand the rule, here’s an excerpt taken from his book,</p><p><em>“When an axon of cell A is near enough to excite a cell B and repeatedly or persistently takes part in firing it, some growth process or metabolic change takes place in one or both cells such that As efficiency, as one of the cells firing B, is increased.”</em></p><p>The above statement describes how neuronal activities influence the connection between neurons, i.e., the synaptic plasticity. It provides an algorithm to update the weights of neuronal connections within the neural network. To summarise his research, here are the three major takeaways from the Hebbian learning mechanism:</p><ol><li>Information between neuron connections in a neural network is stored in the form of weights.</li><li>The updation of weights is directly proportional to the product of activation values for neurons.</li><li>As learning occurs, simultaneous or repeated activation of weakly connected neurons incrementally changes the strength and pattern, leading to stronger connections.</li></ol><h4><strong>Perceptron</strong></h4><p>In 1957, after MCP Models and the Hebbian Rule’s success, Frank Rosenblatt, a psychologist, came up with a first trainable neural network called <strong>Perceptron</strong>. Later, he constructed an electronic device out of a perceptron that showed the ability to learn in accordance with associationism.</p><p>The Perceptron’s design was similar to the modern neural net, except that it has only one layer that classifies input into two possible output categories with adjustable weights and thresholds, between input and output layers.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*V79gbqPpDsxxSxhs" /><figcaption><em>Rosenblatt and the Perceptron (Wikipedia Commons)</em></figcaption></figure><p>Most of his research was mainly inspired by the context of human vision; let’s see how!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ywcIzdbQOG0l9oVWMXcN1g.png" /><figcaption>Left: Illustration of organisation of a perceptron in (Rosenblatt, 1958), Right: A typical perceptron in modern machine learning literature (Src: <a href="https://arxiv.org/pdf/1702.07800.pdf">On the origins of DL</a>)</figcaption></figure><p>The image on the left explains the Rosenblatt perceptron. It has four units, sensory unit, projection unit, association unit and response unit respectively. When the input is sent to the Retina, the information is sent to the projection area, which then proceeds to the sensory unit and later passes on to the association unit. The structure resembles the structure of nowadays perceptron in a neural network which is shown on the right.</p><p>The perceptron can be assumed to be quite similar to the MCP model; however, here are the major differences:</p><p>In Perceptron, the neurons take an additional constant associated with the synaptic weights called biases (b). It can be thought of as the negation of the activation threshold.</p><ul><li>The synaptic weights are not restricted to unity or positive. Hence, some of the inputs can have an inhibitory influence, thus allowing some inputs to affect the neuron’s output more than others.</li></ul><p>Mathematically, the non-linearity of the artificial neuron on which the perceptron relies is given by:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/392/0*F3KBNrvGWh-MX9m3" /><figcaption>Image by Author</figcaption></figure><p>No matter what the formulation is, the decision boundary for the perceptron (and many other linear classifiers) is given by,</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/399/0*8dIi9bZvSU7UExXk" /><figcaption>Image by Author</figcaption></figure><p>Alternatively, we can give a compact mathematical notation as follows:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/151/0*G8dHzTb58uiEzGHO" /><figcaption>Image by Author</figcaption></figure><p>Here’s a modern illustration of the perceptron explaining how weights and biases are attached to the neurons:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*PUUh9Dhu-8modeou" /><figcaption>Image by Author</figcaption></figure><h4><strong>The Back Propagation</strong></h4><p>The backpropagation learning technique was one of the significant breakthroughs in the fields of deep learning. This algorithm was introduced in the 1970s. Still, its importance wasn’t fully appreciated until the famous 1986 research paper, “Learning representations by back-propagating errors,” which was published by David Rumelhart, Geoffrey Hinton, and Ronald Williams.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CBiyx9Itj6JuHzIlP9urFg.png" /><figcaption><em>Left to Right: David Rumelhart Geoffrey Hinton, NNs, with forward and back pass (Wikipedia Commons)</em></figcaption></figure><p>Without an efficient backpropagation technique for a Neural Network, it would be impractical to train deep learning networks to the depths as we see today. Backpropagation can be considered as the foundation for modern neural networks and deep learning.</p><p>The algorithm is used to efficiently train a neural network using a method called chain rule. In simple terms, after each forward pass through the network, backpropagation performs a backward pass while adjusting the model’s parameters (weights and biases). At the heart of backpropagation is an expression of the partial derivative, ∂C/∂w of the cost function, C concerning any weight, w (or bias b) in the network.</p><p>“Why use derivatives for a Backpropagation Algorithm?”.</p><ol><li>The Gradient of a Cost Function C for a particular input x is a vector of partial derivatives of C.</li><li>Using this gradient of the cost function, we can measure the sensitivity of the output value concerning the change in the amount of the input. In other terms, using this derivative, we can understand the direction that the cost function takes.</li><li>Altogether, the gradient shows how much the parameter w (or b) needs to change (in a positive or negative direction) to minimise C.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/583/0*RirIQ4pfGZqYvVXL" /><figcaption><em>Image showing how the gradients are Computed (</em><a href="http://neuralnetworksanddeeplearning.com/chap2.html"><em>src</em></a><em>)</em></figcaption></figure><p>So far, we’ve seen a few significant contributions made by the deep learning pioneers. Below is an image that gives us an overall idea of how this domain had evolved since the 1940s. As we can see, the timeline is pretty dense, and covering all these would be utterly unrealistic in a single blog post. If you’re still interested in learning more about this in detail, I would suggest you read this extraordinary research titled “<strong>On the Origin of Deep Learning” </strong>by Haohan Wang and Bhiksha Raj.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*5avLmO_PDw573-ux" /><figcaption><em>Credits to </em><a href="https://medium.com/u/e8ec6fa4d7d4?source=post_page-----37a3ec09038a--------------------------------"><em>Favio Vázquez</em></a><em> for this awesome image!</em></figcaption></figure><p>Now, let’s look at how deep learning has evolved into different areas with their respective applications to date.</p><h3>Areas and Applications of Deep Learning</h3><p>The current advancements in technology have been unpalpable a long time ago. We’ve never imagined a humane computer, self-driving automobiles, and the enhancement of the medical procedures. But today, these became part of our everyday life with the power of deep learning. Now let us further understand the applications of deep learning across areas.</p><p><strong><em>Computer Vision</em></strong>: CV, in short, provides techniques to help computers “see” and understand digital content such as images and videos. Below are some of the applications of DL for Computer Vision.</p><ul><li>Facial recognition and identification</li><li>Satellite and drone imagery</li><li>Image search optimisation</li><li>Image super-resolution and colourisation</li><li>Guiding autonomous vehicles to identify the road, pedestrians, signal lights etc.</li></ul><p><strong><em>Natural Language Processing (NLP): </em></strong>NLP helps in understanding the complexities associated with language, could be syntax, semantics, tonal nuances, expressions, or even sarcasm. With the increase in computing power, deep learning is now able to identify and understand human language as well. AI assistants like Siri, Google Voice mainly rely on NLP to process information. Here are a few of its applications.</p><ul><li>Speech Recognition</li><li>Named Entity Recognition (Identifying Names, Location, Address and may move from the text)</li><li>Chatbots, (Q and A)</li><li>Sentiment and emotion detection on social media</li></ul><p><strong><em>Medicine and Biology: </em></strong>Advances in medicine and biology, has provided vast volumes of data such as medical images, gene information, protein sequences and many more. Using this data, several deep learning-based algorithms are being developed that are widely being used in production helping doctors, scientists and radiologists. Below are a few applications that made breakthroughs through DL:</p><ul><li>Medical Image Classification (on CT, MRI, X-Ray images)</li><li>Tumour Segmentation</li><li>Protein folding and drug discovery</li><li>Clinical text processing</li></ul><p><strong><em>Gaming: </em></strong>DL has revolutionised the way of gaming it was before. The DL algorithms can now play against humans by adapting to the player’s emotional and psychological state. All thanks to reinforcement learning for bringing the concept of learning by trial and error.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Nv9aLn5_XSahIVut" /><figcaption><em>OpenAI models playing against humans (Source: </em><a href="https://openai.com/blog/openai-five/"><em>OpenAI</em></a><em>)</em></figcaption></figure><p>Below are a few applications that are widely being used:</p><ul><li>Playing NPC’s (Non-Playable-Character) — Bots</li><li>Modelling complex interactions</li><li>Video graphic processing</li><li>Game universe creation</li></ul><h4>References:</h4><ul><li><a href="https://news.mit.edu/2017/explained-neural-networks-deep-learning-0414#:~:text=Neural%20networks%20were%20first%20proposed,the%20first%20cognitive%20science%20department">Explained: Neural networks</a></li><li><a href="https://www.proquest.com/docview/304650983">A multithreaded software model for backpropagation</a></li><li><a href="https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.335.3398&amp;rep=rep1&amp;type=pdf">The perceptron: a probabilistic model for information storage and organization in the brain</a></li><li><a href="https://arxiv.org/pdf/1702.07800.pdf">On the Origin of Deep Learning</a></li><li><a href="https://towardsdatascience.com/rosenblatts-perceptron-the-very-first-neural-network-37a3ec09038a">Rosenblatt’s perceptron, the first modern neural network | by Jean-Christophe B. Loiseau</a></li></ul><p>Thanks for reading!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=adb4d60eaf24" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/the-past-present-and-future-of-deep-learning-adb4d60eaf24">The past, present and future of deep learning</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Flask Web Programming from Scratch]]></title>
            <link>https://medium.com/hackernoon/flask-web-programming-from-scratch-9ada8088fde1?source=rss-4ce24554e1d2------2</link>
            <guid isPermaLink="false">https://medium.com/p/9ada8088fde1</guid>
            <category><![CDATA[design]]></category>
            <category><![CDATA[database]]></category>
            <category><![CDATA[dev]]></category>
            <category><![CDATA[python]]></category>
            <category><![CDATA[flask]]></category>
            <dc:creator><![CDATA[Vihar Kurama]]></dc:creator>
            <pubDate>Thu, 24 May 2018 14:20:11 GMT</pubDate>
            <atom:updated>2019-04-23T07:25:59.177Z</atom:updated>
            <content:encoded><![CDATA[<p>Complete guide for Flask 1.0 from scratch with SQLAlchemy and Postgres.</p><p>Choosing a web framework is one of the important and the most frustrating tasks for building dynamic websites. There are more than thousands of web frameworks in several programming languages. We use these web frameworks based on different use cases. For example, Whatsapp uses Erlang Programming Language which is good at concurrency so for applications like Whatsapp we need to choose a framework which is concurrent enough to handle multiple connections. So before starting web programming or building websites, it is essential to have a robust framework which can handle all types of features. In this article, we will learn about one of the most used and famous web frameworks “Flask.”</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*fD3qqMWNyfJ85XST9c1H2g.png" /></figure><blockquote>A web framework (<strong>WF</strong>) or web application framework (WAF) is a software framework that is designed to support the development of web applications including web services, web resources, and web APIs.</blockquote><h4><strong>About &amp; Why Flask?</strong></h4><p>It is a micro level web framework which is written in <a href="https://hackernoon.com/tagged/python">Python</a> by <a href="https://github.com/mitsuhiko">Armin Ronacher</a> and several open source contributors. Flask is based on Werkzeug(Utilities and Requests), Jinja 2(Templating).</p><p>Here’s the link to official<a href="http://flask.pocoo.org/docs/1.0/"><strong> </strong><em>Flask 1.0 Documentation</em></a>.</p><p>Flask community recently released its stable version “Flask 1.0” which is production ready which has several new features and updates included.</p><p><strong><em>Pros</em></strong> — Flask provides extreme simplicity, flexibility and fine-grained control. It implements bare-bones and leaves the bells and whistles to add-ons or the developers. Routing URLs is simple. Required <a href="https://hackernoon.com/tagged/database">database</a> connections can be synced explicitly. It’s easier to learn and implement and hence could be a good starting point for all the people out there who’re craving to start their web development journey.</p><p><strong><em>Cons</em></strong> — Non-Asynchronous. Lack of database and ORM(Object Relational Mapping — It is a programming technique in which a metadata descriptor is used to connect object code to a relational database).</p><p>Finally, Flask is the best choice for all the web programmers, to start from the scratch and for building minimalistic web applications. One more advantage of using Flask is you can integrate machine learning algorithms(Python Based) within the functions with ease which makes your applications more intelligent and cognitive.</p><h4><strong>What can you do with Flask?</strong></h4><p>From blog applications to cloning facebook/twitter, almost everything is possible in Flask. There are many libraries like flask-sockets, flask-google-maps etc. where you can embed several features in your application. Flask supports MySQL, Postgresql, MongoDB and other few databases and based on the use case we need to choose the most suitable database.</p><p><strong><em>Here are few websites models you can build with Flask:</em></strong></p><p>Blog Applications, Chat Applications, Data Visualisation, Dashboards, REST Applications, Admin Pages, Email-Services.</p><h3>Getting Started with Flask 1.0</h3><p><strong><em>Prerequisites</em></strong>: Before getting started with flask one should be good with Python, if you are learning Python, refer <a href="https://towardsdatascience.com/python-programming-in-15-min-part-1-3ad2d773834c">this</a> article on Python or documentation <a href="https://docs.python.org/3/">here</a>. Install Python&gt;=3, configured with PIP (Python Package Index) on your computer.</p><h4>Installing Flask</h4><p>To install flask all you need to do is just run this single command on your command prompt if you are using windows, terminal if you are using MacOS or Linux.</p><pre>$ pip install flask</pre><p>The following packages will also be installed with this command: Werkzeug, Jinja, MarkupSafe, ItsDangerous, Click which are necessary for your application to be running. We need not worry about this now, and Flask takes care of this at the back.</p><h4>Writing out first traditional program “Hello World!”</h4><p>To start our first flask “Hello World” application, here are few steps to follow. Create a new app.py file and follow accordingly.</p><ol><li>Firstly we need to import Flask Class from flask module which we installed earlier, this Flask class will contain all the methods and attributes that we use in writing our application, so this will be our first line in our program.</li></ol><pre>from flask import Flask</pre><p>2. Secondly, we need to declare a variable containing flask object. This variable will be used for running and configuring our app.</p><pre>app = Flask(__name__)</pre><blockquote>“__name__” is a special variable in Python. If the source file is executed as the main program, the interpreter sets the __name__ variable to have a value “__main__”. If this file is being imported from another module, __name__ will be set to the module’s name.</blockquote><p>3. Writing Main Function.</p><p>In our main function, we need to run our flask variable, to do that we need to use the app variable which we declared before and use the run method on it. This run method starts a local server in your machine. Usually, the default address is “localhost:5000.” To change the port address, we can pass in a parameter to the run method assigning it to any desired port number. We need to restart our server whenever we change the code in our application, to overcome that we can use debug parameter given to run method and set it to “True”. Now, whenever if there are any changes made to the source code the server automatically restarts. The debugger is also used to track the errors if there’re any. Below is the code snippet of main function.</p><pre>if __name__ ==&quot;__main__&quot;:<br>    app.run(debug=True, port=8080)</pre><p>4. Routing</p><p>We then use the <strong>route() decorator</strong> on the app variable to tell Flask what URL should trigger our function. The desired URL pattern should be written in the string to the route decorator. The function which should be triggered by the route will be declared under it. Below is the code snippet of how to declare a route.</p><pre>@app.route(&#39;/&#39;)<br>def hello_world():<br>    return &#39;Hello, World!&#39;</pre><blockquote>“/” is the home route, as soon as you run your server it triggers first.</blockquote><p>5. Running the Flask application.</p><p>Once all the above steps are complete, now our source code looks like this.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b2a59bc19d5df926bdac4a40fc2487e8/href">https://medium.com/media/b2a59bc19d5df926bdac4a40fc2487e8/href</a></iframe><p>Running flask application is similar to how you execute your python programs.Once the server starts running you can see the below information.</p><pre>$ python app.py</pre><pre>* Serving Flask app &quot;app&quot; (lazy loading)<br>* Environment: production<br>* Debug mode: on<br>* Running on http://127.0.0.1:8080/ (Press CTRL+C to quit)<br>* Restarting with stat<br>* Debugger is active!<br>* Debugger PIN: 770-937-705</pre><p>Now, open your web browser and hit the URL: <em>http://127.0.0.1:8080/</em> you can see “Hello World!” printed there.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yH30E28cDBJ6tYaeb_0JCg.png" /></figure><h3><strong>Flask Templating (Jinja 2)</strong></h3><p>So, how to insert plain HTML code into a Flask Application?</p><p>Here we’re creating a dictionary comprising of username and age and later in the HTML code those values are being extracted.</p><p>Code snippet explaining templating.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/3d4839bfed67fa8727b94d3d22c8d130/href">https://medium.com/media/3d4839bfed67fa8727b94d3d22c8d130/href</a></iframe><p>This gives the output: Hello, John!, you’re 20 years old.</p><p><em>http://127.0.0.1:8080/greet</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dhjbdRQFAEc5u5-mixT26A.png" /></figure><p>This is totally cumbersome if at all HTML code must be changed on a regular basis. Hence, it isn’t really feasible and scalable. This would be better if logic part is separated from the presentation. Because of that, Flask configures the Jinja2 template engine for us automatically. Instead of hard coding HTML into Flask, we can instead insert the HTML file using the render_template() function.</p><p>The hierarchy that must be followed for placing the HTML file assuming the .py file is being placed in a module named ‘Apps’</p><pre>Apps folder<br>/app.py<br>templates<br>   |-/index.html</pre><p>So, create a folder named templates and add the HTML file into it.</p><p>A view/function must return render_template() and the name of html page that should be rendered. Below is code snippet, how you render templates from view.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/29acdfb0ebe1d091164d5e9d1a4e325b/href">https://medium.com/media/29acdfb0ebe1d091164d5e9d1a4e325b/href</a></iframe><p>In HTML page we render the template passed and the variable name is also returned on HTML page.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b826c3557df3f80505af65f9ffde9bc6/href">https://medium.com/media/b826c3557df3f80505af65f9ffde9bc6/href</a></iframe><p><em>http://127.0.0.1:8080/hello/alex</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WPCpjg9h3JLebeACOVmptQ.png" /></figure><p>The above code snippet clearly explains how to insert HTML file comprising of conditional statements, say, ‘if’ in this case. {{ }} indicates the placeholder for variables.</p><p>{% %} is the container for inserting control statements.</p><h3><strong>Flask Forms and Requests.</strong></h3><p>Forms are building blocks for every web application, using these forms we take inputs of several categories like username forms and e-mail forms. These help us receive information from users/clients and store them into the database.</p><p>Now let’s create a simple bio-data form which takes in few inputs like Name, Age, Email and Hobbies in Flask and renders it on a HTML Page. The HTML code for forms is given below- “bio_form.html”.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/a2ec48a5390446846dba6119c05c4fa8/href">https://medium.com/media/a2ec48a5390446846dba6119c05c4fa8/href</a></iframe><p>Now, we use requests library to retrieve the posted data from the form input fields. First, we need to know how the request-response work on the Internet. Whenever a form is submitted it comes under POST method, to load all the pages on to internet it is GET request. We need to create a view to request the information from the forms. As soon as the form is submitted the view compares to POST method and requests the data from the input tags. The index of the form should be equal to the name attribute of input tag.</p><pre>--HTML--<br>&lt;input type=&quot;text&quot; name=&quot;username&quot; placeholder=&quot;Your Name&quot;/&gt;</pre><pre>--Python--<br>if request.method == &quot;POST&quot;:<br>    username = request.form[&#39;username&#39;]</pre><p>Now for the above HTML form let’s declare a view bio_data_form() to store input into Python variables. — <em>this view renders the above “bio_form.html”</em></p><pre>@app.route(&#39;/form&#39;, methods=[&#39;POST&#39;, &#39;GET&#39;])<br>def bio_data_form():    <br>    if request.method == &quot;POST&quot;:<br>        username = request.form[&#39;username&#39;]        <br>        age = request.form[&#39;age&#39;]        <br>        email = request.form[&#39;email&#39;]        <br>        hobbies = request.form[&#39;hobbies&#39;]        <br>        return redirect(url_for(&#39;showbio&#39;,                              <br>                                username=username,<br>                                age=age,<br>                                email=email,   <br>                                hobbies=hobbies))    <br>    return render_template(&quot;bio_form.html&quot;)</pre><p>Once all the variables from the form are requested these variables are sent to ‘<strong>showbio</strong>’ view in order to render information in a HTML page. We use “url_for” to redirect to views. So as soon as the request method is POST, the form is submitted the data is sent in the form of arguments, these arguments are fetched from the url and rendered on “<strong>show_bio.html</strong>”</p><p><em>This how the arguments are submitted : </em><a href="http://127.0.0.1:8080/showbio?username=Stark&amp;email=stark07%40gmail.com&amp;hobbies=Play%2C+Code"><em>http://127.0.0.1:8080/showbiousername=Stark&amp;email=stark07%40gmail.com&amp;hobbies=Play%2C+Code</em></a></p><pre>@app.route(&#39;/showbio&#39;, methods=[&#39;GET&#39;])<br>def showbio():    <br>    username = request.args.get(&#39;username&#39;)    <br>    age = request.args.get(&#39;age&#39;)    <br>    email = request.args.get(&#39;email&#39;)    <br>    hobbies = request.args.get(&#39;hobbies&#39;)    <br>    return render_template(&quot;show_bio.html&quot;,<br>                           username=username,                         <br>                           age=age,                          <br>                           email=email,                         <br>                           hobbies=hobbies)</pre><p>Once these two views are added, this is how your source code should look like,</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/d83d87b3b1eaa7d05d717701fe409b3b/href">https://medium.com/media/d83d87b3b1eaa7d05d717701fe409b3b/href</a></iframe><p>We use Jinja 2 for rendering these variables on HTML page, make sure that this function returns the fetched variables. If the function doesn’t return the variables they won’t be rendered on HTML page.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/d1f9091fd44f6b662ff1e2689abe952d/href">https://medium.com/media/d1f9091fd44f6b662ff1e2689abe952d/href</a></iframe><p>Run your application, and visit the : <a href="http://127.0.0.1:8080/form">http://127.0.0.1:8080/form</a></p><h3>Integrating Flask with Postgres(Database) using <strong>Flask-SQLAlchemy</strong></h3><p>Flask cannot connect to databases directly so we need to have a medium to connect them. The Medium which we use is called as ORM (Object Relational Mapper).</p><p>Here we shall explore about Flask-SQLAlchemy, an extension that provides a Flask-friendly wrapper to the popular <a href="http://www.sqlalchemy.org/">SQLAlchemy</a> package, which is an ORM. This allow applications to manage a database using high-level entities such as classes, objects and methods instead of tables and SQL. The job of the ORM is to translate the high-level operations into database commands. SQLAlchemy supports a long list of database engines, including the popular MySQL, PostgreSQL and SQLite.</p><p>To configure your application with SQLAlchemy and PostgreSQL here are the following steps:</p><ol><li><strong>Install Flask-SQLAlchemy and PostgresQL on your machine.</strong></li></ol><p>Install Flask-SQlAlchemy using pip. Run the following command on terminal or command prompt to install Flask-SQLAlchemy.</p><pre>$ pip install flask-sqlalchemy</pre><p>To install PostgreSQL on MAC use Homebrew</p><pre>brew install postgres</pre><p>Or download Postgres application — <a href="https://postgresapp.com/">https://postgresapp.com/</a></p><p>In windows you need to download and install Postgres, here is the link to download Postgres — <a href="https://www.postgresql.org/download/windows/">https://www.postgresql.org/download/windows/</a></p><p><strong>2. Create a Database</strong></p><p>Once you have Postgres installed and running, create a database called “appdb” to use as our local development database:</p><p>In your terminal or command prompt use the following command to create Postgres database.</p><pre>$ createdb appdb</pre><p>This command creates a Postgres database in your local machine. If any error occurs, try reinstalling Postgres.</p><p><strong>3. Update App Settings.</strong></p><p>Configure your source code with all SQlAlchemy and Postgres by setting app.config variables.</p><p>Now, we need to link our application with this database using SQLAlchemy as the medium. In our source code add SQLALCHEMY_DATABASE_URI field to the app.config and declare a new variable called db created using an SQLAlchemy object by passing it to the application named app in this case. That object then contains all the functions and helpers from both sqlalchemy and sqlalchemy.orm. Furthermore, it provides a class called Model that is a declarative base which can be used to declare models.</p><p>Here is the code for configuring SQlAlchemy and Postgres.</p><pre>app.config[&#39;DEBUG&#39;] = True<br>app.config[&#39;SQLALCHEMY_DATABASE_URI&#39;]=&#39;postgresql://localhost/appdb&#39;<br>SQLALCHEMY_TRACK_MODIFICATIONS = True<br>db = SQLAlchemy(app)</pre><p>Once you’ve updated app.py this is how it should look like,</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/df380c4e23435e8e0a134f140fe12a6f/href">https://medium.com/media/df380c4e23435e8e0a134f140fe12a6f/href</a></iframe><p>These three steps, will let you connect your app with Postgres database.</p><p>Now, let’s create our first M<strong>odel</strong>. The base class for all your models is called db.Model. It’s stored on the SQLAlchemy instance we’ve to create. Use Column to define a column. The name of the column is the name you assign it .</p><p>Below is the code snippet to declare models in flask. This is similar to how we create classes in Python. In this we are declaring a Post Model which has three attributes id(primary_key), title for the post, and post description(post_text).</p><pre>class Post(db.Model):<br>    id = db.Column(db.Integer(), primary_key=True)<br>    title = db.Column(db.String(80), unique=True)<br>    post_text = db.Column(db.String(255))<br>    <br>    def __init__(self, title, post_text):<br>        self.title = title<br>        self.post_text = post_text</pre><p>Add your Model to your source code.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/035e4b92c6193f786efa4126668b48f8/href">https://medium.com/media/035e4b92c6193f786efa4126668b48f8/href</a></iframe><h4>Flask-Migrations</h4><p>Next migrations must be done to the database in order to keep up with the existing modifications and the changing needs of the application. The second extension that must be used is Flask-Migrate. This extension is a Flask wrapper for <a href="https://bitbucket.org/zzzeek/alembic">Alembic</a>, a database migration framework for SQLAlchemy.</p><p>Install flask migrations and flask script( — has the manager class to activate manager commands) package using PIP.</p><pre>$ pip install flask-migrate<br>$ pip install flask_script</pre><p>To setup migrations in our app, we need to define Migrate class within the app as our base instance. Add the below lines in your source file to configure migrations.</p><p>First import flask migrations and Manager class to your source code.</p><pre>from flask_script import Manager<br>from flask_migrate import Migrate, MigrateCommand</pre><p>Next, configure app settings with migrations.</p><pre>migrate = Migrate(app, db)<br>manager = Manager(app)<br>manager.add_command(&#39;db&#39;, MigrateCommand)</pre><p>To elaborate upon this, we set our config to get our scene — based on the environment variable — created a migrate instance, with app and db as the arguments, and set up a manager command to initialise a Manager instance for our app. Lastly, we added the db command to the manager so that we can run the migrations from the command line.</p><p>Now, since our manager app has the whole app and db instances we need to run the replaced app variable which is manager variable in the main function.</p><pre>if __name__ == &#39;__main__&#39;:<br>    manager.run()</pre><p>The configured source code(app.py) now will look like this:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/e5c5c38bc76b60921660a35a5aca9cd6/href">https://medium.com/media/e5c5c38bc76b60921660a35a5aca9cd6/href</a></iframe><p>In order to run the migrations to initialize Alembic, use the following command.</p><pre>$ python app.py db init<br>Creating directory /Users/Vihar/Desktop/flask-databases/migrations ... done<br>...<br>...<br>...<br>Generating /Users/Vihar/Desktop/flask-databases/migrations/alembic.ini ... done</pre><p>Once you run the command, the above information is provided by the manager saying, migrations are successfully created. After you run the database initialisation, you will see a new folder called “migrations” in the project.</p><p>Let’s do our first migration by running the migrate command. Use the following command to update and create tables in your database.</p><pre>$ python app.py db migrate<br>INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.<br>INFO  [alembic.runtime.migration] Will assume transactional DDL.<br>INFO  [alembic.autogenerate.compare] Detected added table &#39;post&#39;</pre><pre>Generating /Users/Vihar/Desktop/flask-databases/migrations/versions/ed3b3a028447_.py ... done</pre><p>With this command your tables will now be created if there aren&#39;t and modified in there are any.</p><p>Now we’ll apply the upgrades to the database using the db upgrade command:</p><pre>$ python app.py db upgrade</pre><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*pivCBHufwrveAftQnJ1aAQ.png" /></figure><p>Here, you can see that two row are added in appdb from Postgres shell.</p><h4>Flask-Postgres Minimal Blog.</h4><p>We can add information to database from forms using Flask — WTF Extension which is a wrapper around WTForms Package. When working with WTForms we have to define forms as classes first. So, to install Flask-WTF using PIP, the command is</p><pre>$ pip install flask-wtf</pre><p>Your form class should contain all the fields, for the above Post Model, this is how we declare Form Class</p><pre>class Post(db.Model):<br>    id = db.Column(db.Integer(), primary_key=True)<br>    title = db.Column(db.String(80), unique=True)<br>    post_text = db.Column(db.String(255))</pre><pre>    def __init__(self, title, post_text):<br>        self.title = title<br>        self.post_text = post_text</pre><pre># Declaring Flask WTF-Form</pre><pre>class PostForm(FlaskForm):<br>    title = StringField(&#39;Title&#39;, validators=[DataRequired()])<br>    post_text = StringField(&#39;Post_Text&#39;,                            <br>                             validators=[DataRequired()]<br>                           )</pre><p>Now we need to declare a view which sends all the form values to the HTML Template.</p><p>Here in the below code snippet, we are declaring a new view “add_post” under “/addpost” route.</p><p>In this view we are rendering “post_form.html” which has the form input fields. Now in the view, first we need to create a new instance of PostForm so whenever the page is refreshed or reloaded a new instance is created.</p><p>Here we are using Flask requests to fetch the information from forms. Whenever something is submitted from a web page, it comes under POST request method. In this view, initially it would be GET which renders post_form.html and later when we submit PostForm, this would call POST method thereby collecting the data from the form.</p><p>Once we POST the data to the page a session should be created for the information, in order to add the data to the database. We use db.session.add() which adds the data to the session and db.session.commit() to push the data to the database. Hence, add_post view is defined as</p><pre>@app.route(&#39;/addpost&#39;, methods=[&#39;GET&#39;, &#39;POST&#39;])<br>def add_post():<br>    postform = PostForm()<br>        if request.method == &#39;POST&#39;:<br>            pf = Post(<br>                postform.title.data,<br>                postform.post_text.data,<br>            )<br>            db.session.add(pf)<br>            db.session.commit()<br>        return redirect(url_for(&#39;view_posts&#39;))<br>    return render_template(&#39;post_form.html&#39;, postform = postform)</pre><p>To render flask-wtf forms onto HTML we need to call with the postform variable and thereby pass these as the parameters to model Post which will return on to “post_form.html”</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/e289c490d14ff9da08fd61be7c533b51/href">https://medium.com/media/e289c490d14ff9da08fd61be7c533b51/href</a></iframe><p>After the form is committed to the database we redirect our page to view_posts where we query all the posts and render on a template. Below is the code snippet for ‘view_posts’</p><pre>@app.route(&#39;/posts&#39;, methods=[&#39;GET&#39;, &#39;POST&#39;])<br>def view_posts():<br>    posts = Post.query.all()<br>    return render_template(&#39;view_posts.html&#39;, posts=posts)</pre><p>All the post are queried in view_posts and returned view_post.html and iterated in HTML page using jinja loops. Here is code snippet for view_post.html which explains looping variables in Jinja 2.</p><p>As all the posts are returned from view_posts and rendered on view_posts we iterate over a loop and render on HTML.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/bc24b9ca377dfb2ee9e86ff2cbf6fc04/href">https://medium.com/media/bc24b9ca377dfb2ee9e86ff2cbf6fc04/href</a></iframe><p>The complete source code is given below:</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/68430d4a2842b99a9df2315d9b69cf81/href">https://medium.com/media/68430d4a2842b99a9df2315d9b69cf81/href</a></iframe><p>http://localhost:5000/addpost</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*sZhvZBO8SkOSNTZCrrngEQ.png" /></figure><p>http://localhost:5000/posts</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*IxTepLVr0JyqFsZTy83hFw.png" /></figure><p>This explains the minimal working of blog application, All the frontend part can be added in the HTML files directly.</p><p>Congratulations on learning Flask 1.0, with this you will be able to create seamless and intelligent web applications.</p><p>The source-code for the article can be found <a href="https://github.com/vihar/flask-web-programming">here</a>.</p><p>Thanks for reading. If you found this story helpful, please click the below 👏 to spread the love.</p><p>This article is authored by <a href="https://medium.com/u/4ce24554e1d2">Vihar Kurama</a> and <a href="https://medium.com/u/7e65fabdea53">Samhita Alla</a>.</p><p>Stay tuned for more articles on Flask.</p><p>Important Links:</p><p><a href="https://towardsdatascience.com/python-programming-in-15-min-part-1-3ad2d773834c">Python Programming in 15 min Part 1</a></p><iframe src="https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fupscri.be%2Fdde502%3Fas_embed%3Dtrue&amp;dntp=1&amp;url=https%3A%2F%2Fupscri.be%2Fhackernoon%2F&amp;key=a19fcc184b9711e1b4764040d3dc5c07&amp;type=text%2Fhtml&amp;schema=upscri" width="800" height="400" frameborder="0" scrolling="no"><a href="https://medium.com/media/3c851dac986ab6dbb2d1aaa91205a8eb/href">https://medium.com/media/3c851dac986ab6dbb2d1aaa91205a8eb/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9ada8088fde1" width="1" height="1" alt=""><hr><p><a href="https://medium.com/hackernoon/flask-web-programming-from-scratch-9ada8088fde1">Flask Web Programming from Scratch</a> was originally published in <a href="https://medium.com/hackernoon">HackerNoon.com</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>