Forem: JerryMaoMao

DALL-E vs. Midjourney AI vs. Stable Diffusion: A Comparison of AI Models that Can Generate Images from Text

JerryMaoMao — Fri, 12 May 2023 08:38:08 +0000

Artificial intelligence (AI) is one of the most exciting and impactful fields of technology today. AI is enabling new applications and possibilities across various domains and industries, such as healthcare, education, entertainment, and more. AI is also advancing the frontiers of human creativity and expression, by allowing us to generate novel and realistic content from data or prompts.

One of the most fascinating and challenging tasks in AI is natural language generation (NLG), the task of creating coherent and meaningful texts from data or prompts. NLG has many applications, such as summarizing information, writing captions, generating headlines, and more. But one of the most impressive and creative applications of NLG is generating images from text descriptions. Imagine being able to create any image you can think of, just by typing in a few words. For example, you could type in “a cat wearing a hat” and get an image of a cat wearing a hat.

This may sound like science fiction, but it is actually possible thanks to three groundbreaking AI models: DALL-E, Midjourney AI and Stable Diffusion. These models can generate realistic and diverse images from text descriptions, demonstrating a high degree of creativity and flexibility. But how do these models work, and which one is better? In this blog, we will compare DALL-E, Midjourney AI and Stable Diffusion, and show you how you can use them to create your own images with ILLA CLOUD.

What is DALL-E?

DALL-E is an AI model that was introduced by OpenAI earlier this year. DALL-E is a variant of GPT-3, a large-scale language model that can generate texts on almost any topic given a prompt. DALL-E extends the capabilities of GPT-3 by enabling it to generate images from text descriptions, such as “an armchair in the shape of an avocado” or “a snail made of a harp”. DALL-E can produce multiple images for each prompt, demonstrating a high degree of creativity and flexibility.

DALL-E uses a neural network architecture called Transformer, which consists of layers of attention mechanisms that learn to encode and decode sequences of data. DALL-E uses a single Transformer model that can process both text and image tokens as inputs and outputs. DALL-E also uses a technique called VQ-VAE to compress high-resolution images into discrete tokens that can be fed into the Transformer model.

DALL-E can generate images at 64x64 pixels resolution, which is relatively low compared to other image generation models. However, DALL-E can still produce impressive results that capture the essence and details of the text descriptions. DALL-E can also handle complex and abstract concepts, such as “a painting of a capybara sitting in a field at sunrise” or “a diagram explaining how DALL-E works”.

What is Midjourney AI?

Midjourney AI is an AI model that was developed by an independent research lab called Midjourney Lab. Midjourney AI is also a variant of GPT-3, but it uses a different approach to generate images from text descriptions. Midjourney AI uses a technique called CLIP to guide the image generation process.

CLIP is another AI model that was introduced by OpenAI earlier this year. CLIP stands for Contrastive Language-Image Pre-training, and it is a model that can learn to associate texts and images across different domains and tasks. CLIP can perform various image-related tasks, such as classification, captioning, retrieval, and more.

Midjourney AI uses CLIP as a feedback mechanism to optimize the image generation process. Midjourney AI starts with a random noise image and then iteratively modifies it until it matches the text description as closely as possible according to CLIP’s evaluation. Midjourney AI also uses another technique called StyleGAN2 to inject style and diversity into the generated images.

Midjourney AI can generate images at 256x256 pixels resolution, which is higher than DALL-E’s resolution. Midjourney AI can also produce realistic and diverse images that reflect the style and mood of the text descriptions. Midjourney AI excels at generating artistic and expressive images, such as “a portrait of Frida Kahlo with flowers in her hair” or “a surreal landscape with floating islands”.

What is Stable Diffusion?

Stable Diffusion is an AI model that was developed by Stability ai, a startup that focuses on building and sharing state-of-the-art natural language technologies. Stable Diffusion is based on two breakthroughs in generative modeling: diffusion models and DALL-E. Stable Diffusion combines these two techniques to create a model that can generate images from text descriptions using diffusion models instead of GPT-3.

Diffusion models are a class of generative models that learn to reverse a stochastic process that gradually corrupts an image or a text until it becomes pure noise. By reversing this process, diffusion models can generate high-quality samples from noise by applying a series of learned denoising steps. Diffusion models have been shown to outperform other generative models such as GANs and VAEs in terms of fidelity and diversity.

Stable Diffusion uses a diffusion model that is trained on a large dataset of images and their corresponding text descriptions, which are obtained from DALL-E. Stable Diffusion uses the same text encoder as DALL-E to encode the text descriptions into latent vectors, which are then used to condition the diffusion model. Stable Diffusion also uses a technique called annealed sampling to improve the quality and diversity of the generated images.

Stable Diffusion can generate images at 256x256 pixels resolution, which is higher than DALL-E’s resolution. Stable Diffusion can also generate more diverse and realistic images by leveraging the strengths of diffusion models. Stable Diffusion can handle various types of text descriptions, such as “a photo of a dog wearing sunglasses” or “a sketch of a dragon breathing fire”.

How to compare DALL-E, Midjourney AI and Stable Diffusion?

Now that we have introduced the three models, how can we compare them and decide which one is better? Well, there is no definitive answer to this question, as each model has its own strengths and weaknesses, and different use cases and preferences. However, we can use some criteria to evaluate and compare them, such as:

Resolution: This refers to the size and quality of the generated images. Higher resolution means more details and clarity. Among the three models, Midjourney AI and Stable Diffusion have higher resolution than DALL-E.
Diversity: This refers to the variety and uniqueness of the generated images. Higher diversity means more options and creativity. Among the three models, Stable Diffusion and Midjourney AI have higher diversity than DALL-E.
Realism: This refers to the degree of similarity between the generated images and real-world images. Higher realism means more accuracy and plausibility. Among the three models, Midjourney AI and DALL-E have higher realism than Stable Diffusion.
Style: This refers to the aesthetic and artistic aspects of the generated images. Higher style means more expression and mood. Among the three models, Midjourney AI has higher style than DALL-E and Stable Diffusion.
Speed: This refers to the time and resources required to generate images. Higher speed means more efficiency and convenience. Among the three models, DALL-E has higher speed than Midjourney AI and Stable Diffusion.

Based on these criteria, we can see that each model has its own advantages and disadvantages, depending on what you are looking for. For example, if you want high-resolution, diverse and realistic images, you might prefer Midjourney AI or Stable Diffusion over DALL-E. If you want fast and simple image generation, you might prefer DALL-E over Midjourney AI or Stable Diffusion. If you want artistic and expressive images, you might prefer Midjourney AI over DALL-E or Stable Diffusion.

Of course, these criteria are not exhaustive or objective, and you might have other factors or preferences that influence your choice. The best way to compare these models is to try them out yourself and see which one suits your needs and tastes better.

How to use DALL-E, Midjourney AI and Stable Diffusion with ILLA CLOUD?

If you are interested in using DALL-E, Midjourney AI or Stable Diffusion to generate your own images from text descriptions, you might be wondering how you can access and use them easily and affordably. The answer is ILLA CLOUD.

ILLA CLOUD is a cloud-based platform that provides easy and affordable access to the latest AI technologies and tools. ILLA CLOUD allows you to use DALL-E, Midjourney AI or Stable Diffusion without any coding or installation required. You can simply type in your text description

and get your image generated in seconds. You can also customize your image by changing the style, color, size, and other parameters.

ILLA CLOUD is not only a platform for using AI models, but also for building and sharing them. ILLA CLOUD enables you to create your own custom AI models using Hugging Face Transformers and other frameworks. You can also upload your own data and fine-tune existing models to suit your specific needs and preferences. You can then share your models with other users or deploy them to your own applications.

ILLA CLOUD is also developing a lot of new AI features that will make your experience even better and more enjoyable. Some of these features include:

A collaborative editor that allows you to work on your AI projects with your team members or friends in real time.
A gallery that showcases the best and most popular AI creations made by other users.
A community that connects you with other AI enthusiasts and experts, where you can exchange ideas, feedback, and support.

ILLA CLOUD is more than just a platform. It is a vision of democratizing AI and making it accessible and fun for everyone. ILLA CLOUD believes that AI is not only a technology, but also a form of art and expression. ILLA CLOUD wants to empower you to unleash your creativity and imagination with AI.

That’s why ILLA CLOUD has partnered with Hugging Face, the leading AI company behind Stable Diffusion and other amazing models. Together, they aim to provide you with the best and most advanced AI tools and resources. They also share a common mission of building a friendly and collaborative AI community, where everyone can learn, grow, and create together.

If you are interested in using DALL-E, Midjourney AI or Stable Diffusion or other Hugging Face models, or if you want to create your own AI models and projects, you can sign up for ILLA CLOUD today. You will get a free trial and a generous credit to start your AI journey. You will also get access to exclusive tutorials, guides, and tips from Hugging Face and ILLA CLOUD experts.

Don’t miss this opportunity to join the AI revolution and become an AI creator. Join ILLA CLOUD and Hugging Face today and discover the endless possibilities of AI.

Join our Discord Community: discord.com/invite/illacloud

Try ILLA Cloud for free: cloud.illacloud.com

ILLA Home Page: illacloud.com

GitHub page: github.com/illacloud/illa-builder

The Ultimate Guide to Stable Diffusion Prompts: What They Are, How They Work, and Why They Matter

JerryMaoMao — Fri, 12 May 2023 08:18:41 +0000

If you are a fan of pixel art, you might have heard of stable diffusion prompts. These are a type of creative challenge that can help you generate amazing pixel art with minimal effort. But what exactly are stable diffusion prompts? How do they work? And why should you use them? In this ultimate guide, we will answer all these questions and more. We will also show you some examples of good and bad stable diffusion prompts, and how to use a stable diffusion prompt generator to create your own. By the end of this article, you will have a better understanding of stable diffusion prompts and how to use them to improve your pixel art skills.

What is Stable Diffusion?

Stable diffusion is a deep learning, text-to-image model released in 2022. It is primarily used to generate detailed images conditioned on text descriptions, though it can also be applied to other tasks such as inpainting, outpainting, and generating image-to-image translations guided by a text prompt.

Stable diffusion is based on the concept of stable diffusion, which is a mathematical process that creates patterns by randomly spreading dots on a grid. The dots can only move to adjacent cells that are empty or have fewer dots than the current cell. This process creates clusters of dots that form interesting shapes and textures.

Stable diffusion is a latent diffusion model conditioned on the (non-pooled) text embeddings of a CLIP ViT-L/14 text encoder. It can generate images with default resolutions of both 512x512 pixels and 768x768 pixels. It can also use an upscaler diffusion model that enhances the resolution of images by a factor of 4. It can also use a depth-to-image diffusion model that infers the depth of an input image and generates new images using both the text and depth information.

Stable diffusion is an open-source machine learning model built to generate images from text, modify the images based on text, or fill in details on low-resolution or low-detail images. The model has been trained on billions of images and can produce images that are highly coherent to the ones obtainable from DALL-E 2 and MidJourney.

Stable diffusion is an easy-to-use interface for creating images using the recently released Stable Diffusion image generation model. It can create high quality images of anything you can imagine in seconds–just type in a text prompt and hit Generate. It also has a powerful AI feature that allows you to use AI models from Hugging Face, the leading platform for natural language processing, to enhance your internal tools with state-of-the-art AI.

What are stable diffusion prompts?

A stable diffusion prompt is a set of instructions that tells you how to apply the stable diffusion process to create pixel art. For example, a stable diffusion prompt might tell you to use a certain color palette, a certain grid size, a certain number of dots, or a certain theme. By following the prompt, you can create pixel art that is unique and surprising.

How do stable diffusion prompts work?

Stable diffusion prompts work by giving you some constraints and guidelines that help you generate pixel art with minimal effort. You don’t need to have any artistic skills or experience to use them. All you need is a grid, some dots, and some imagination.

To use a stable diffusion prompt, you need to follow these steps:

Choose a prompt. You can either use an existing prompt or create your own using a stable diffusion prompt generator.
Set up your grid. You need to decide how big your grid will be and what color it will have. You can use any grid size and color you want, but some prompts might suggest specific ones for better results.
Place your dots. You need to decide how many dots you will use and what colors they will have. You can use any number and color of dots you want, but some prompts might suggest specific ones for better results.
Apply the stable diffusion process. You need to move your dots according to the rules of stable diffusion until they form clusters and patterns. You can either do this manually or use a tool that automates the process for you.
Add some details. You can optionally add some details to your pixel art by drawing over it or using other tools. This can help you enhance the shapes and textures created by the stable diffusion process.

Why should you use stable diffusion prompts?

Stable diffusion prompts are a great way to create pixel art for several reasons:

They are fun and easy to use. You don’t need any artistic skills or experience to use them. You just need to follow some simple instructions and let the stable diffusion process do the magic for you.
They are creative and surprising. You never know what kind of pixel art you will get from using them. The stable diffusion process creates patterns that are unpredictable and diverse. You can get different results every time you use them.
They are versatile and adaptable. You can use them for any kind of pixel art you want. You can choose different grid sizes, colors, dot numbers, themes, and details to suit your preferences and goals.
They are educational and inspirational. You can learn more about the stable diffusion process and how it creates patterns by using them. You can also get inspired by the pixel art created by other people using them.

Examples of good and bad stable diffusion prompts

Good stable diffusion prompts are a type of creative challenge that can help you generate pixel art with minimal effort. They are based on the concept of stable diffusion, which is a mathematical process that creates patterns by randomly spreading dots on a grid. By following a set of instructions that tells you how to apply the stable diffusion process to create pixel art, you can have fun and easy, creative and surprising, versatile and adaptable, and educational and inspirational experiences.

A good stable diffusion prompt should be:

Clear and specific: Describe the subject and scene in detail to help the AI model generate accurate images.
Concise: Use concise language and avoid unnecessary words that may confuse the model or dilute the intended meaning.
Creative and surprising: Use words that evoke emotions, sensations, or associations to make the image more interesting and unique.
Versatile and adaptable: Use words that allow for different interpretations and variations to make the image more diverse and flexible.
Educational and inspirational: Use words that teach something new or inspire further exploration to make the image more meaningful and valuable.

Some examples of good stable diffusion prompts are:

A realistic portrait of a young woman with blue eyes and curly red hair wearing a green dress and a pearl necklace
A surreal landscape of floating islands with waterfalls, trees, and castles
A pixel art of a cute cat with blue eyes wearing a bowtie
A minimalist poster of a movie called “The Last Unicorn” with a white unicorn silhouette on a black background and yellow text
A collage of different fruits cut in half and arranged in a rainbow pattern

You can use these prompts as they are or modify them according to your preferences and goals. You can also use a stable diffusion prompt generator to create your own prompts based on different categories and parameters.

Bad stable diffusion prompts

Bad stable diffusion prompts are a type of creative challenge that can hinder you from generating pixel art with minimal effort. They are based on the concept of stable diffusion, which is a mathematical process that creates patterns by randomly spreading dots on a grid. By following a set of instructions that tells you how to apply the stable diffusion process to create pixel art, you can have frustrating and disappointing, confusing and boring, unrealistic and unappealing, and confusing and contradictory experiences.

A bad stable diffusion prompt should be avoided:

Confusing and contradictory: Use words that are vague or inconsistent with each other to confuse the AI model and generate inaccurate images.
Vague and boring: Use words that are too general or lack detail to bore the AI model and generate bland images.
Unrealistic and unappealing: Use words that are impossible or undesirable to repel the AI model and generate low-quality images.
Confusing and contradictory: Use words that teach something wrong or discourage further exploration to mislead the AI model and generate meaningless images.

Some examples of bad stable diffusion prompts are:

A realistic portrait of a young woman with blue eyes and curly red hair wearing a green dress and a pearl necklace
A surreal landscape of floating islands with waterfalls, trees, and castles
A pixel art of a cute cat with blue eyes wearing a bowtie
A minimalist poster of a movie called “The Last Unicorn” with a white unicorn silhouette on a black background and yellow text
A collage of different fruits cut in half and arranged in a rainbow pattern

You should avoid these prompts as they are or modify them according to your preferences and goals. You can also use a stable diffusion prompt generator to create your own prompts based on different categories and parameters.

How to use a stable diffusion prompt generator

If you want to create your own stable diffusion prompts, you can use a stable diffusion prompt generator. This is a tool that can help you generate random or customized prompts based on your preferences and goals. You can use a stable diffusion prompt generator to:

Explore different possibilities and variations of stable diffusion prompts
Challenge yourself and others with new and unique stable diffusion prompts
Save time and effort on creating your own stable diffusion prompts

There are many stable diffusion prompt generators available online, but one of the best ones is https://stablediffusionweb.com/prompt-generator This is a free and easy-to-use tool that can help you generate high-quality stable diffusion prompts in seconds. You can use this tool to:

Choose from different categories of prompts, such as basic, advanced, themed, or custom
Adjust various parameters of prompts, such as grid size, color palette, dot number, theme, or detail level
Preview the results of prompts in real-time
Save or share your prompts with others

To use this tool, you need to follow these steps:

Go to https://stablediffusionweb.com/prompt-generator
Choose a category of prompts from the menu on the left. You can either use one of the predefined categories or create your own custom category.
Adjust the parameters of prompts from the menu on the right. You can either use the default values or change them according to your preferences and goals.
Click on the generate button at the bottom to generate a random prompt based on your settings.
Preview the result of the prompt in the middle. You can either use it as it is or click on the regenerate button to generate a new prompt with the same settings.
Save or share your prompt with others. You can either copy the prompt text or download the prompt image from the buttons at the top. You can also share your prompt on social media or with other users of the tool from the buttons at the bottom.

ILLA Cloud’s AI Feature

ILLA Cloud is a low-code development platform that empowers developers to build internal tools faster and easier. With ILLA Cloud, you can drag and drop components to create responsive UI, connect to your databases and APIs, and write queries using SQL and JavaScript. You can also deploy your apps with one click on ILLA Cloud or use ILLA CLI for free with better security.

But that’s not all. ILLA Cloud also has a powerful AI feature that allows you to use AI models from Hugging Face, the leading platform for natural language processing, to enhance your internal tools with state-of-the-art AI. Hugging Face offers over 10,000 pre-trained models for various NLP tasks, such as text classification, sentiment analysis, summarization, translation, question answering, and more.

Join our Discord community and let us know what AI features you want to see

We are constantly working on improving ILLA Cloud and adding new features to make it the best low-code development platform for internal tools. We value your feedback and suggestions, and we want to hear from you. What AI features do you want to see and use in ILLA Cloud? How can we make ILLA Cloud better for you?

To join our Discord community and let us know what you think, you can follow this link: https://discord.com/invite/illacloud

We appreciate your support and we hope you enjoy using ILLA Cloud’s AI feature!

Conclusion

Stable diffusion prompts are a type of creative challenge that can help you generate pixel art with minimal effort. They are based on the concept of stable diffusion, which is a mathematical process that creates patterns by randomly spreading dots on a grid. By following a set of instructions that tells you how to apply the stable diffusion process to create pixel art, you can have fun and easy, creative and surprising, versatile and adaptable, and educational and inspirational experiences. You can use existing prompts or create your own using a stable diffusion prompt generator. We hope this ultimate guide has helped you understand what stable diffusion prompts are, how they work, and why they matter. Now it’s time for you to try them out and see what kind of pixel art you can create!

Thank you for reading this ultimate guide to stable diffusion prompts. We hope you have learned something new and useful from it. We would love to hear from you and help you with any issues you might have. If you enjoyed this article, please share it with your friends and colleagues who might be interested in stable diffusion prompts. You can also subscribe to our newsletter to get more tips and tricks on pixel art and stable diffusion prompts. Happy pixel art-making!

Join our Discord Community: discord.com/invite/illacloud

Try ILLA Cloud for free: cloud.illacloud.com

ILLA Home Page: illacloud.com

GitHub page: github.com/illacloud/illa-builder

Top 7 Redis GUI Tools in 2023

JerryMaoMao — Mon, 08 May 2023 11:49:42 +0000

Redis is a popular open-source, in-memory data structure store that can be used as a database, cache, message broker, and more. Redis supports various data types like strings, lists, sets, hashes, and streams. Redis also offers many features like transactions, replication, clustering, pub/sub, Lua scripting, and more.

However, working with Redis can be challenging without a graphical user interface (GUI) to help you visualize and interact with your data. A Redis GUI tool can help you browse, filter, edit, and delete your Redis keys, run commands and queries, monitor performance and metrics, and more.

Many Redis GUI tools are available in the market, each with its own features, pros and cons, and price. This blog post will review the top 7 Redis GUI tools in 2023 and compare them based on their functionality, usability, compatibility, and cost. We will also show you how to use ILLA Cloud, the best Redis GUI tool, to build a Redis GUI for your application.

ILLA Cloud

ILLA Cloud is an open-source low-code platform for building internal tools. It is a powerful and flexible UI library for building web applications that connect to your databases and APIs. You can use ILLA Cloud to build anything from simple forms and tables to complex applications with advanced features.

ILLA Cloud supports Redis as one of its data sources. You can connect to your Redis server or cluster using ILLA Cloud and access your data using a graphical interface. You can also run commands and queries using SQL and JavaScript. You can use template syntax to inject dynamic values into your components and queries. You can also customize and control your components with JavaScript.

ILLA Cloud has many advantages over other Redis GUI tools. Some of them are:

It is free and open-source. You can use ILLA Cloud without paying any fees or licenses. You can also contribute to the project on GitHub and help improve it.
It is cross-platform and cloud-based. You can use ILLA Cloud on any device and operating system. You can also deploy it on your own server or use the ILLA Cloud service.
It supports multiple data sources. You can connect to various databases and APIs using ILLA Cloud, such as PostgreSQL, MongoDB, MySQL, Stripe, Google Sheets, AWS S3, and more. You can also integrate with any data source connected through APIs.
It has a drag-and-drop interface. You can build a user interface for your application by dragging and dropping components like tables, charts, forms, buttons, and more. You don’t need to write any HTML or CSS code.
It has a rich set of components. You can use dozens of components in ILLA Cloud to meet your needs in different scenarios. You can also customize them with JavaScript.
It supports JavaScript inside widgets, queries, and other components. Using JavaScript, you can add logic, transform data, and define complex workflows. You can also use template syntax to inject dynamic values into your components and queries.
It has a collaborative feature. You can work with other developers on the same project by sharing links. You can also chat with them in real time and give feedback.
It has a friendly community. You can join the Discord community of ILLA Cloud and get support from other users and developers. You can also share feedback, ask questions, and get updates.

To use ILLA Cloud to build a Redis GUI for your application, you need to follow these steps:

Sign up for a free account on the ILLA Cloud website.
Create a new project and choose Redis as your data source.
Enter your Redis connection details (hostname or IP address, port number, password, and database number).
Click on Connect button to connect to your Redis server or cluster.
Once connected, you will see your Redis keys on the left panel. You can browse, filter, and search them by name, type, or value. You can also edit or delete them by right-clicking on them.
To run commands or queries on your Redis data, click on the Query tab on the top panel. You can write SQL or JavaScript in the editor. You can use template syntax to inject dynamic values into your queries. You can also use auto-completion and syntax highlighting features. You can run your queries by clicking the Run button or pressing Ctrl+Enter. You will see the results on the right panel. You can also export the results as CSV or JSON files.
To build a user interface for your application, click on the Builder tab on the top panel. You will see a grid-style canvas where you can drag and drop components from the left panel. You can choose from various components like tables, charts, forms, buttons, etc. You can also customize and control your components with JavaScript. You can use template syntax to inject dynamic values into your components. You can also bind your components to your queries and data sources.
To preview your application, click on the Preview button on the top right corner. You will see how your application looks and works in a browser. You can also test your components and queries and see the results.

That’s it! You have built a Redis GUI for your application using ILLA Cloud. You can now use it to visualize and interact with your Redis data.

RedisInsight

RedisInsight is a desktop manager for Redis that provides an intuitive and efficient UI for Redis and Redis Stack. It supports all Redis deployments, such as Redis Open Source, Redis Stack, Redis Enterprise Software, Redis Enterprise Cloud, or Amazon ElastiCache.

RedisInsight allows you to browse and interact with Redis data using a graphical interface. You can also run commands and queries using a built-in CLI with auto-completion and syntax highlighting features. You can also explore the latest capabilities offered by Redis, such as documents, graphs, time series, and more.

Some of the advantages of RedisInsight are:

It is free and easy to use. You can download RedisInsight for free and install it on your Linux, Windows, or macOS machine. You can also check out the GitHub project and provide feedback.
It supports multiple operating systems and Redis deployments. You can use RedisInsight on any device and operating system. You can also connect to any Redis server or cluster using RedisInsight.
It has a graphical interface for Redis data. Using a graphical interface, you can browse, filter, edit, and delete your Redis keys. You can also display data in various formats like JSON, hexadecimal, MessagePack, and more. You can also use the Tree view to group data and enhance the navigation.
It has a built-in CLI for running commands and queries. You can run commands and queries using a built-in CLI with auto-completion and syntax highlighting features. You can also use the Workbench feature to run commands and queries using a Monaco Editor.
It supports the latest capabilities offered by Redis. You can query, visualize, and interactively work with complex data models such as documents, graphs, time series, etc. You can also explore queryable JSON documents, full-text search, probabilistic data structures, and more.

Some of the drawbacks of RedisInsight are:

It is not open-source. You cannot contribute to or modify the project according to your needs.
It does not support multiple data sources. You cannot connect to other databases or APIs using RedisInsight.
It does not have a drag-and-drop interface for building user interfaces. You cannot build a user interface for your application using RedisInsight.

Redis Desktop Manager (RESP.app)

Redis Desktop Manager is a cross-platform desktop GUI for Redis. It lets you connect to multiple Redis servers and clusters and manage your data using a graphical interface. You can also run commands and queries using a built-in CLI with auto-completion and syntax highlighting features.

Some of the advantages of Redis Desktop Manager are:

It is cross-platform and desktop-based. You can use Redis Desktop Manager on Linux, Windows, or macOS machines. You can also install it as a snap package or a docker image.
It supports multiple Redis servers and clusters. You can connect to multiple Redis servers and clusters using Redis Desktop Manager. You can also import and export connections using JSON files.
It has a graphical interface for Redis data. Using a graphical interface, you can browse, filter, edit, and delete your Redis keys. You can also display data in various formats like JSON, hexadecimal, MessagePack, and more. You can also use the Tree view to group data and enhance the navigation.
It has a built-in CLI for running commands and queries. You can run commands and queries using a built-in CLI with auto-completion and syntax highlighting features. Using a terminal-like interface, you can also use the Console feature to run commands and queries.

Some of the drawbacks of Redis Desktop Manager are:

It is not free or open-source. You have to pay a subscription fee to use Redis Desktop Manager. The free version has limited features and functionality.
It does not support the latest capabilities offered by Redis. You cannot query, visualize, or interact with complex data models such as documents, graphs, time series, etc.
It does not support multiple data sources. You cannot connect to other databases or APIs using Redis Desktop Manager.
It does not have a drag-and-drop interface for building user interfaces. You cannot build a user interface for your application using Redis Desktop Manager.

Medis

Medis is a beautiful and easy-to-use Mac database management application for Redis. It lets you connect to multiple Redis servers and clusters and manage your data using a graphical interface. You can also run commands and queries using a built-in CLI with auto-completion and syntax highlighting features.

Some of the advantages of Medis are:

It is beautiful and easy-to-use. Medis has a sleek and intuitive design that makes it easy to use. It also has dark mode support that makes it look even better.
It is Mac-based and desktop-based. You can use Medis on any Mac machine. You can also install it from the Mac App Store or download it from GitHub.
It supports multiple Redis servers and clusters. You can connect to multiple Redis servers and clusters using Medis. You can also import and export connections using JSON files.
It has a graphical interface for Redis data. Using a graphical interface, you can browse, filter, edit, and delete your Redis keys. You can also display data in various formats like JSON, hexadecimal, MessagePack, and more. You can also use the Tree view to group data and enhance the navigation.
It has a built-in CLI for running commands and queries. You can run commands and queries using a built-in CLI with auto-completion and syntax highlighting features. Using a terminal-like interface, you can also use the Terminal feature to run commands and queries.

Some of the drawbacks of Medis are:

It is not free or open-source. You have to pay a subscription fee to use Medis. The free version has limited features and functionality.
It is only available for Mac. You cannot use Medis on other operating systems or devices.
It does not support the latest capabilities offered by Redis. You cannot query, visualize, or interact with complex data models such as documents, graphs, time series, and more.
It does not support multiple data sources. You cannot connect to other databases or APIs using Medis.
It does not have a drag-and-drop interface for building user interfaces. You cannot build a user interface for your application using Medis.

To use Medis to build a Redis GUI for your application, you need to follow these steps:

Download Medis from the Mac App Store or GitHub.
Install Medis on your Mac machine.
Launch Medis and click on Add Connection button.
Enter your Redis connection details (host name or IP address, port number, password, and database number).
Click on Connect button to connect to your Redis server or cluster.
Once connected, you will see your Redis keys on the left panel. You can browse, filter, and search them by name, type, or value. You can also edit or delete them by right-clicking on them.
To run commands or queries on your Redis data, click on CLI tab on the bottom panel. You can write commands or queries in the editor. You can use auto-completion and syntax highlighting features. You can run your commands or queries by clicking on Execute button or pressing Ctrl+Enter. You will see the results on the right panel.

That’s it! You have built a Redis GUI for your application using Medis. You can now use it to visualize and interact with your Redis data.

Redis Commander

Redis Commander is a free and open-source Redis management tool written in Node.js. It allows you to connect to multiple Redis servers and clusters and manage your data using a web-based interface. You can also run commands and queries using a built-in CLI with auto-completion and syntax highlighting features.

Some of the advantages of Redis Commander are:

It is free and open-source. You can use Redis Commander without paying any fees or licenses. You can also contribute to the project on GitHub and help improve it.
It is web-based and cross-platform. You can use Redis Commander on any device and operating system. You need to install it on your server and access it through a web browser.
It supports multiple Redis servers and clusters. You can connect to multiple Redis servers and clusters using Redis Commander. You can also import and export connections using JSON files.
It has a web-based interface for Redis data. Using a web-based interface, you can browse, filter, edit, and delete your Redis keys. You can also display data in various formats like JSON, hexadecimal, MessagePack, and more. You can also use the Tree view to group data and enhance the navigation.
It has a built-in CLI for running commands and queries. You can run commands and queries using a built-in CLI with auto-completion and syntax highlighting features.

Some of the drawbacks of Redis Commander are:

It is not very stable or reliable. Redis Commander may have bugs or issues affecting its performance or functionality. It may also crash or freeze sometimes.
It does not support the latest capabilities offered by Redis. You cannot query, visualize, or interact with complex data models such as documents, graphs, time series, and more.
It does not support multiple data sources. You cannot connect to other databases or APIs using Redis Commander.
It does not have a drag-and-drop interface for building user interfaces. You cannot build a user interface for your application using Redis Commander.

To use Redis Commander to build a Redis GUI for your application, you need to follow these steps:

Download Redis Commander from GitHub or npm.
Install Redis Commander on your server using Node.js.
Launch Redis Commander by running redis-commander command in your terminal.
Access Redis Commander through your web browser by entering http://localhost:8081 in your address bar.
Click on Add Redis Server button to add your Redis connection details (host name or IP address, port number, password, and database number).
Click on Connect button to connect to your Redis server or cluster.
Once connected, you will see your Redis keys on the left panel. You can browse, filter, and search them by name, type, or value. You can also edit or delete them by right-clicking on them.
To run commands or queries on your Redis data, click on Console tab on the top panel. You can write commands or queries in the editor. You can use auto-completion and syntax highlighting features. You can run your commands or queries by clicking on Execute button or pressing Ctrl+Enter. You will see the results on the right panel.

That’s it! You have built a Redis GUI for your application using Redis Commander. You can now use it to visualize and interact with your Redis data.

Redsmin

Redsmin is a cloud-based Redis management service that provides a real-time interface for Redis and Redis Stack. It supports all Redis deployments, such as Redis Open Source, Redis Stack, Redis Enterprise Software, Redis Enterprise Cloud, or Amazon ElastiCache.

Redsmin allows you to browse and interact with Redis data using a web-based interface. You can also run commands and queries using a built-in CLI with auto-completion and syntax highlighting features. You can also monitor the performance and metrics of your Redis server or cluster using a dashboard.

Some of the advantages of Redsmin are:

It is cloud-based and cross-platform. You can use Redsmin on any device and operating system. You must install a proxy daemon on your server and access it through a web browser.
It supports multiple Redis servers and clusters. You can connect to multiple Redis servers and clusters using Redsmin. You can also import and export connections using JSON files.
It has a web-based interface for Redis data. Using a web-based interface, you can browse, filter, edit, and delete your Redis keys. You can also display data in various formats like JSON, hexadecimal, MessagePack, and more. You can also use the Tree view to group data and enhance the navigation.
It has a built-in CLI for running commands and queries. You can run commands and queries using a built-in CLI with auto-completion and syntax highlighting features.
It supports the latest capabilities offered by Redis. You can query, visualize, and interact with complex data models such as documents, graphs, and time series. You can also explore queryable JSON documents, full-text search, probabilistic data structures, and more.
It has a dashboard for monitoring performance and metrics. You can monitor your Redis server's or cluster's performance and metrics using a dashboard. You can see commands processed in real-time and inspect slow commands. You can also troubleshoot performance issues and debug your Redis server.

Some of the drawbacks of Redsmin are:

It is not free or open-source. You have to pay a subscription fee to use Redsmin. The free version has limited features and functionality.
It requires a proxy daemon installation. You must install a proxy daemon on your server to connect to Redsmin. This may affect your security or performance.
It does not support multiple data sources. You cannot connect to other databases or APIs using Redsmin.
It does not have a drag-and-drop interface for building user interfaces. You cannot build a user interface for your application using Redsmin.

To use Redsmin to build a Redis GUI for your application, you need to follow these steps:

Sign up for a free account on the Redsmin website.
Download and install the proxy daemon on your server using Node.js.
Launch the proxy daemon by running redsmin command in your terminal.
Enter your Redsmin API key when prompted.
Access Redsmin through your web browser by entering https://app.redsmin.com in your address bar.
Click on Add Redis Server button to add your Redis connection details (hostname or IP address, port number, password, and database number).
Click on Connect button to connect to your Redis server or cluster.
Once connected, you will see your Redis keys on the left panel. You can browse, filter, and search them by name, type, or value. You can also edit or delete them by right-clicking on them.
To run commands or queries on your Redis data, click on the Console tab on the top panel. You can write commands or queries in the editor. You can use auto-completion and syntax highlighting features. You can run your commands or queries by clicking on Execute button or pressing Ctrl+Enter. You will see the results on the right panel.
To explore the latest capabilities offered by Redis, click on the corresponding tabs on the top panel. You can choose from various modules, such as RedisJSON, RedisGraph, and RedisTimeSeries. Using a web-based interface, you can query, visualize, and interact with complex data models.
To monitor your Redis server's or cluster's performance and metrics, click on the Dashboard tab on the top panel. You can see commands processed in real-time and inspect slow commands. You can also troubleshoot performance issues and debug your Redis server.

That’s it! You have built a Redis GUI for your application using Redsmin. You can now use it to visualize and interact with your Redis data.

Webdis

Webdis is a simple web server that exposes Redis commands as HTTP endpoints with JSON output. It allows you to connect to your Redis server and access your data using a web browser or any HTTP client. You can also run commands and queries using HTTP requests.

Some of the advantages of Webdis are:

It is simple and lightweight. Webdis is a simple web server that requires no installation or configuration. It is also very fast and consumes little memory.
It is open-source and free. You can use Webdis without paying any fees or licenses. You can also contribute to the project on GitHub and help improve it.
It supports multiple operating systems and Redis deployments. You can use Webdis on Linux, Windows, or macOS machines. You can also connect to any Redis server or cluster using Webdis.
It has a web-based interface for Redis data. You can browse and interact with Redis data using a web browser or any HTTP client. You can also display data in JSON format.

Some of the drawbacks of Webdis are:

It is not very secure or reliable. Webdis does not support authentication or encryption for your Redis connection. It may also expose your Redis data to unauthorized access or modification.
It does not support the latest capabilities offered by Redis. You cannot query, visualize, or interact with complex data models such as documents, graphs, time series, and more.
It does not support multiple data sources. You cannot connect to other databases or APIs using Webdis.
It does not have a built-in CLI for running commands and queries. You have to use HTTP requests to run commands and queries on your Redis data.
It does not have a drag-and-drop interface for building user interfaces. You cannot build a user interface for your application using Webdis.

To use Webdis to build a Redis GUI for your application, you need to follow these steps:

Download Webdis from GitHub or compile it from the source code.
Launch Webdis by running webdis the command in your terminal.
Access Webdis through your web browser by entering http://localhost:7379 in your address bar.
Enter your Redis command or query in the URL path after the slash. For example, http://localhost:7379/GET/foo will get the value of the key foo.
See the result of your command or query in JSON format in your browser.

That’s it! You have built a Redis GUI for your application using Webdis. You can now use it to access and interact with your Redis data.

Conclusion

In this blog post, we have reviewed the top 7 Redis GUI tools in 2023 and compared them based on their functionality, usability, compatibility, and cost. We have also shown you how to use each tool to build a Redis GUI for your application.

We hope this blog post has helped you find the best Redis GUI tool for your needs and preferences. However, if you ask us, we recommend ILLA Cloud as the best Redis GUI tool.

ILLA Cloud is an open-source low-code platform for building internal tools that supports Redis as one of its data sources. It lets you connect to your Redis server or cluster and access your data using a graphical interface. It also allows you to run commands and queries using SQL and JavaScript. It also allows you to build a user interface for your application by dragging and dropping components like tables, charts, forms, buttons, and more. You can also customize and control your components with JavaScript. You can also use template syntax to inject dynamic values into your components and queries. You can also collaborate with other developers on the same project by sharing links. You can also join the Discord community of ILLA Cloud and get support from other users and developers.

ILLA Cloud has many advantages over other Redis GUI tools. It is free and open-source, cross-platform and cloud-based, supports multiple data sources, has a drag-and-drop interface, has a rich set of components, supports JavaScript inside widgets, queries, and other components, has a collaborative feature, and has a friendly community.

To use ILLA Cloud to build a Redis GUI for your application, you need to sign up for a free account on the ILLA Cloud website, create a new project and choose Redis as your data source, enter your Redis connection details, connect to your Redis server or cluster, browse and interact with your Redis data using a graphical interface, run commands and queries using SQL and JavaScript, build a user interface for your application by dragging and dropping components, preview and deploy your application on ILLA Cloud or on your own server using ILLA CLI.

If you want to try ILLA Cloud for yourself, you can sign up for free and start building your internal tools today. You can also join the Discord community of ILLA Cloud and chat with other users and developers.

Thank you for reading this blog post. We hope you have learned something new and valuable about Redis GUI tools. If you have any questions or feedback, please feel free to comment below or contact us. We would love to hear from you. Happy coding!

Join our Discord Community: discord.com/invite/illacloud

Try ILLA Cloud for free: cloud.illacloud.com

ILLA Home Page: illacloud.com

GitHub page: github.com/illacloud/illa-builder

Retool vs. UI Bakery: Which Low-Code Platform is Better for Building Internal Tools?

JerryMaoMao — Tue, 18 Apr 2023 11:42:58 +0000

Low-code platforms are transforming the way applications are built, and Retool and UI Bakery are two of the most promising options in this field. Both platforms offer unique features, advantages, and limitations. This article will compare Retool and UI Bakery, exploring their capabilities and highlighting the strengths of each. Whether you are a seasoned developer or just starting out, this comparison will provide valuable insights into which platform is best suited for your needs.

It is important to note that while Retool is widely recognized as a strong player in the market, UI Bakery is also a very capable solution and should not be overlooked. In fact, there is a new low-code platform that combines the best of both worlds: ILLA Cloud. ILLA Cloud is a low-code internal tool development platform that offers an intuitive visual interface, real-time collaboration, flexible deployment, and AI-powered SQL generation. But before we get to that, let’s take a closer look at Retool and UI Bakery.

What is Retool?

Retool is a low-code platform that allows developers to build internal tools quickly and easily. Retool connects to any database or API and provides a drag-and-drop interface for assembling UI components such as tables, forms, charts, and buttons. Retool also supports custom JavaScript and React components for more advanced functionality.

Retool is designed for developers who want to save time and effort on building internal tools without compromising on quality or control. Retool claims to be used by over 10,000 companies, including Airbnb, Brex, DoorDash, and Amazon.

What is UI Bakery?

UI Bakery is another low-code platform that enables developers to create internal tools with minimal coding. UI Bakery also connects to various data sources and offers a drag-and-drop interface for building UI components. UI Bakery has a more modern and trendy UI design than Retool, and also supports custom JavaScript components.

UI Bakery is aimed at developers who want to create beautiful and responsive internal tools with ease and speed. UI Bakery boasts over 5,000 users across 120 countries, including IBM, Accenture, Siemens, and Deloitte.

How do they compare?

Let’s compare Retool and UI Bakery based on some key criteria:

UI library and component design

Both applications provide a wide range of components necessary for users to create a user interface for internal applications. In this case, users can choose based on the appearance of the application, preferring the more modern and trendy UI design of UI Bakery or the simpler, unpretentious, and office-style design of Retool.

Currently, Retool has more components than UI Bakery. However, UI Bakery still provides all the necessary components for building an interface, and users can also use custom JavaScript components to add their own components.

UI building experience

Both tools employ a similar approach to designing interfaces, using drag-and-drop functionality to assemble components within a layout system based on columns. However, UI Bakery boasts a more fine-tuned control over dimensions due to its more frequent layout on working area and in cards.

The methods of working with grids in both applications differ somewhat. UI Bakery utilizes a visual approach, allowing users to see what’s happening in the workspace when adding a component. Retool uses a more code-based approach, requiring users to specify the position and size of each component using numbers.

Data integration

Both platforms allow users to connect to various data sources such as databases, API/GraphQL endpoints, SaaS tools, and cloud storage services. These include popular options like PostgreSQL, MongoDB, MySQL, Stripe, Google Sheets, and AWS S3.

Once connected, both platforms can run queries to fetch and update data from these sources. The user interface (UI) provides convenient components for visualizing and modifying the data, such as tables, charts, and forms.

Data manipulation

Both platforms support SQL and JavaScript for writing queries and interacting with data. However, UI Bakery offers a more advanced workflow with an interface that allows users to create multiple action steps within a single action and a patient action sidebar behavior. Retool’s query list is simple - one query - one action, but the sidebar constantly bounces which can be bothersome and cause confusion.

Collaboration and deployment

Both platforms offer cloud-based and self-hosted deployment options, depending on the user’s preference and security requirements. However, UI Bakery has the edge over Retool regarding collaboration and sharing features. UI Bakery allows users to invite team members, assign roles and permissions, and publish applications to a custom domain or a UI Bakery subdomain. Retool does not have a built-in feature for publishing applications and requires users to set up their own hosting and domain.

Pricing

Both platforms have free plans that allow users to create up to 10 applications with limited features and integrations. The paid plans vary depending on the number of applications, users, data sources, storage, and support. Retool’s paid plans start from $10 per user per month for the Team plan, which includes up to 50 applications and 10 data sources. UI Bakery’s paid plans start from $49 per month for the Individual plan, which includes up to 3 workspaces and unlimited data sources.

What is ILLA Cloud?

ILLA Cloud is a new low-code platform that combines the best features of Retool and UI Bakery and adds some unique ones of its own. ILLA Cloud is an open-source low-code platform for developers to build and deploy internal tools remarkably fast. With ILLA Cloud, you can easily connect to various data sources such as databases, API/GraphQL endpoints, SaaS tools, and cloud storage services. These include popular options like PostgreSQL, MongoDB, MySQL, Stripe, Google Sheets, and AWS S3.

ILLA Cloud also provides a drag-and-drop interface for building UI components with a modern and trendy design. ILLA Cloud supports custom JavaScript components for more advanced functionality and also allows users to write queries using SQL and JavaScript.

One of the most exciting features of ILLA Cloud is its real-time online collaboration(1). Team members can now easily collaborate, share, and discuss projects. With the option to create teams on our platform, project development and management can be done more efficiently.

Another innovative feature of ILLA Cloud is its AI-powered SQL generation(2). With this feature, you can input natural language commands to generate SQL statements that can be run directly. This works in databases like MySQL, Postgre, Supabase, etc. This feature streamlines the development process, as you can quickly and easily create queries without the need for complex coding.

ILLA Cloud also offers flexible deployment options. You can use the ILLA Cloud to quickly start building your apps on any device. You can also use the ILLA CLI for free with better security to ensure data safety.

Why choose ILLA Cloud?

ILLA Cloud is a low-code platform that offers an intuitive visual interface, real-time collaboration, flexible deployment, and AI-powered SQL generation. It is a platform that combines the best of both worlds: Retool and UI Bakery.

With ILLA Cloud, you can:

Build beautiful and responsive internal tools with ease and speed
Connect to any database or API and interact with data using SQL and JavaScript
Use custom JavaScript components for more advanced functionality
Collaborate with your team members in real time and share your projects
Publish your applications to a custom domain or a ILLA subdomain
Use natural language commands to generate SQL statements
Deploy your applications on any device using ILLA Cloud or ILLA CLI

ILLA Cloud is a low-code platform that is built for developers who want to save time and effort on building internal tools without compromising on quality or control. It is a platform that is designed to accelerate your internal tools development.

If you are interested in trying out ILLA Cloud, you can sign up for a free account here(3). You can also join our Discord Community(4) to get support from our team and other users.

We hope this article has helped you understand the differences between Retool and UI Bakery, and why you should consider ILLA Cloud as a viable alternative. If you have any questions or feedback, feel free to contact us in our discord: https://discord.com/invite/illacloud

Join our Discord Community: discord.com/invite/illacloud

Try ILLA Cloud for free: cloud.illacloud.com

ILLA Home Page: illacloud.com

GitHub page: github.com/illacloud/illa-builder

Source:

(1) Announcing: ILLA Cloud 2.0. https://blog.illacloud.com/announcing-illa-cloud-20/.

(2) Introducing ILLA Cloud's Next-Level Feature: Harnessing AI Power. https://blog.illacloud.com/introducing-illa-clouds-next-level-feature-harnessing-the-power-of-ai-generation/.

(3) ILLA Cloud | Accelerate your internal tools development. https://www.illacloud.com/.

(4) About ILLA - ILLA. https://www.illacloud.com/en-US/docs/about-illa.

(5) ILLA Cloud Pricing, Reviews and Features (March 2023) - SaaSworthy.com. https://www.saasworthy.com/product/illa-cloud.

(6) UI Bakery vs Retool. https://uibakery.io/ui-bakery-vs-retool.

(7) Retool vs. UI Bakery | G2. https://www.g2.com/compare/retool-vs-ui-bakery.

(8) Retool vs UI Bakery | What are the differences? - StackShare. https://www.stackshare.io/stackups/retool-vs-ui-bakery.

Building Applications Faster with ILLA and TiDB

JerryMaoMao — Wed, 09 Nov 2022 11:17:40 +0000

ILLA, the low code open source platform for developers, is proud to announce a collaboration with PingCAP’s TiDB, an open-source distributed NewSQL database that features horizontal scalability, high availability, real-time Hybrid Transactional and Analytical Processing (HTAP), and MySQL compatibility. This partnership aims to simplify application development by providing a database that meets data consistency, reliability, availability, scalability, and disaster tolerance requirements.

Today, organizations have to store, process, and manage more and more data; single-machine databases are hitting their physical limits. Traditional sharding mechanisms are unwieldy and hard to maintain as the business grows. TiDB solves these problems transparently through its distributed architecture while maintaining MySQL compatibility. TiDB Cloud, the fully managed TiDB service, can also simplify deployment, management, and maintenance through a web-based management interface in the cloud.

This tutorial will show you how to set up a TiDB cluster and build an administration panel that allows you to create, read, update, and delete entries. We’ll display the data in a table and use a panel to tab between creating and editing forms. We’ll do all this in less than 10 minutes.

Create a free cluster on TiDB Cloud

To create a cluster on TiDB Cloud:

Sign in with your TiDB Cloud account. If you are a new user, sign up for an account.
Create a free cluster and connect to it. Click Quick Start TiDB to learn how to use it. After running the sample application, you will get the TiDB connection information, including the server name, port number, database name, user name, and password. Be sure to note these; you’ll be using them in later steps.

Connect to TiDB with ILLA Builder

Now that you have a free TiDB Cluster, it’s time to connect it to the ILLA Builder.

Create a free account and sign in on the ILLA Builder welcome page.
Create a new application.
Connect to TiDB as an ILLA resource. Do one of the following:
- If you already have a PingCAP resource in ILLA Builder, you can click + New to select it.
- If you don’t have a TiDB resource in the ILLA builder, you need to click + New Resource to set up a new connection.

Test the new connection. If the connection is successful, save the connection as a new resource.

Use actions to execute basic create, read, update, and delete (CRUD) operations in the TiDB database. Actions bridge data and ILLA components and are essential to building an application.

a. Choose a TiDB resource and create actions.

b. In the input box, enter the SQL statement, save it as a new action

c. Click Run to execute the statement.

d. Run a query action to see if the insert action runs successfully.

You can create multiple actions and use different components to control their execution

Connect the component to the action

Components in ILLA Builder are built-in front-end UI libraries such as buttons and input boxes. To connect a component to an action:

Under the component inspect panel on the right, select and drag the “text” and “input” components to the canvas in the middle.

Select & Drag
Create and save the required actions. You can refer to the component or action data by typing “{{”

Here we will create two actions, tidb_query_data and tidb_insert_data, for later use.

Query data from the person table

Insert data into the person table

You have successfully connected the component to the action.

Implement a simple web application with TiDB Cloud

Now that we have everything ready let’s build a simple web application with the basic components to add, delete, modify, or query the data from a TiDB table.

Create and configure an Insert button

Click on the Insert button component you just added to enter the Inspect panel on the right.
Under the Inspect panel, add an event handler, and configure the event handler as:
- Event: Click
- Action: Trigger query
- Query: tidb_insert_data

Insert Button Setup

Query data from a table

Click on the Query new data button you just created. This displays the Inspect panel on the right side of the screen.
In the Inspect panel, add an event handler, and configure it as follows:
- Event: Click
- Action: Trigger query
- Query: tidb_query_data

Query Date Setup

Now you can execute the query action against the specified table in TiDB.

Visualize the query as a chart

In the Inspect panel on the right side, specify the dataset of the chart component to {{tidb_query_data.data}}.
Adjust the chart component settings, such as the chart type, location, and size.
Adjust the dataset settings, such as dataset values and aggregation method. The chart will update as you go.

Data Visualization

Summary

In this article, we implemented a simple TiDB application that inserts new data, executes queries, and displays the query results as a chart. Integrating TiDB Cloud and ILLA builder can make developing your applications much faster and more efficient.
We believe the key to a successful open-source project is not only to code but also to collaborate through code. You are welcome to join our project. Check ILLA’s website or join the Discord community for more information.

You can check ILLA’s website here at https://illacloud.com

GitHub page: https://github.com/illa-family

Join Discord community: https://discord.com/invite/illafamily

Career Page build with ILLA

JerryMaoMao — Thu, 27 Oct 2022 10:24:55 +0000

ILLA is a low-code platform that lets developers build internal tools in minutes and spend less time on website design and integrations.

ILLA is like Figma for the developers. You can Drag and place to build functions with our built-in Components. ILLA is perfectly suitable for automation and data management. Integrating with third-party APIs allows you to implement more functions for your tool. Many friends online still asked us what job I could do with ILLA. To answer that question our team came up with a lot of ideas. We are making them into different showcases.

Here is one of the showcases of using ILLA to build a career page

ILLA supports third-party APIs so that you can link your internal tools with databases and other websites. This gives you more freedom to build internal tools and implement more functions. For the Career Page, we can integrate with Linkedin and other job-posing websites. You can post it once on your career page, and automatically post the information to other platforms.

You can build your customized career page without limitations and in a remarkably short time. ILLA has a well-designed pre-built-in UI components library ready for the engineer to use so that engineers can set up a specific tool by only dragging and placing the components. Programmers can also alternate some code to customize the tool.
Here is a big picture of the career page. ILLA can do more than this！

About ILLA:

ILLA’s team members are open-source enthusiasts, and so is their strategy to pivot with Open Source communities, projects, and contributors. Since ILLA believes open source is a great way to pass knowledge to the next generation, all open-source projects are welcome to collaborate with ILLA. ILLA supports many other open-source projects, such as PingCAP and MindsDB, in their “Action” features. APIs support is another critical feature of ILLA. Integrating third-party APIs smoothly into ILLA’s “component” can improve the user experience significantly.

You can check ILLA’s website here at https://illacloud.com

GitHub page: https://github.com/illa-family

Join Discord community: https://discord.com/invite/illafamily