Kexi is an open source visual database design and data management application for the desktop. It allows users to design database schemas, create tables, queries, forms and reports visually, and manage data all within a user friendly desktop interface. Kexi supports multiple data
Kexi: Open Source Visual Database Design and Management
Kexi is an open source visual database design and data management application for the desktop, supporting multiple databases including MySQL, PostgreSQL, and SQLite.
What is Kexi?
Kexi is a free and open source visual database design, data analysis and data management application for the desktop aimed at both novice and expert users. Built on Qt software and the KDE Frameworks technologies, it features a slick graphical user interface that allows users to create and manage databases, tables, queries, forms and reports all through an intuitive drag and drop design interface without having to write SQL code or program anything.
At its core, Kexi provides a convenient and efficient way to organize, access and share data. It supports connections to several major database servers including MySQL, MariaDB, SQLite, and PostgreSQL as backends. The visual design tools and widgets allow creating entire database applications and interfaces without coding. Advanced users can still write raw SQL when needed.
Some key features and components of Kexi include:
Visual database and table design with support for relationships and constraints
Form building with widgets for data entry and display
Report creation with advanced formatting and layouts
Intuitive visual query building with joins, grouping, sorting etc
Data importing from CSV, Excel and other sources
Data exporting to formats like CSV, HTML, PDF
With its advanced capabilities wrapped in a user friendly interface, Kexi allows both database experts and novices to be more productive in managing and accessing data for a wide variety of purposes from personal data to enterprise solutions. Its open source foundation and cross platform compatibility makes it freely accessible to anyone.
Kexi Features
Features
Visual database design
Creating tables, queries, forms and reports
Managing data through a desktop interface
Supports multiple database servers like MySQL, PostgreSQL and SQLite
Pricing
Open Source
Pros
Open source and free
User friendly visual interface
Allows quick database development without coding
Cross-platform availability
Cons
Limited features compared to full-scale database IDEs
Not suitable for large or complex databases
Lacks some advanced database features like triggers, stored procedures etc
Microsoft Access is a database management system from Microsoft that is part of the Microsoft Office suite of productivity applications. It provides an easy-to-use graphical interface and tools for non-technical business users to create relational databases, tables, queries, forms, and reports to track and analyze data.Some key features of Access...
Claris FileMaker is a versatile database application platform that enables businesses and organizations to easily create custom database solutions tailored to their specific needs. Some key things to know about FileMaker:Works across Windows, Mac, iOS, Android, and web browsersFeatures an intuitive drag-and-drop interface for building database layouts and forms quickly...
LibreOffice Base is a free and open source database management application included as part of the LibreOffice software suite. It provides tools for creating, accessing, and managing SQL databases without the need for any additional database software.Some of the key features of LibreOffice Base include:Graphical database design tools for creating...
My Visual Database is a powerful yet easy-to-use database builder for non-technical users. With its visual, drag-and-drop interface, anyone can quickly create relational databases, build tables with different field types, set up relationships between tables, and construct customized forms and views for entering and accessing data.Unlike traditional database programs that...
Symphytum is an open-source, cross-platform software synthesizer, sampler, and digital audio workstation. It was created to be a free and accessible tool for music production, composition, and performance.Some key features of Symphytum include:Powerful synthesizer engine for generating and manipulating soundsIntuitive graphical interface for connecting modules and routing audioSupport for VST...
HSQLDB (HyperSQL DataBase) is an open-source relational database management system (RDBMS) written in Java. It offers a small, fast multithreaded and transactional database engine with in-memory and disk-based tables and supports embedded and server modes.Key features of HSQLDB include:Full support for standard SQL, JDBC API and PCI driversEmbedded, in-process, memory-only...
Apache OpenOffice Base is a free and open source database management application. It is an integral part of the Apache OpenOffice software suite, which also includes a word processor, spreadsheet, presentation program, and drawing application.Base allows users to easily create, modify, and query databases without needing to understand SQL or...
MobiDB Database is a relational database management system designed from the ground up for mobile applications and devices. Unlike traditional RDBMSs, MobiDB is optimized for offline usage, data synchronization, low resource utilization, and flexibility to evolve with changing application requirements.Some key features and benefits of MobiDB Database include:Offline data storage...
dbFront is an open-source web-based database frontend that allows users to easily manage multiple databases through one simple and consistent interface. It can connect to MySQL, PostgreSQL, SQL Server, SQLite, and other major database platforms.Some key features of dbFront include:Intuitive dashboard interface for browsing database objects like tables, views, stored...
SpeedBase Professional is a desktop database application used by small and medium-sized businesses to build custom databases tailored to their needs. With an easy-to-use visual interface, non-technical users can quickly create tables, relationships, forms, reports and more without any coding required.Key features include:Intuitive drag-and-drop interface to design databasesOptions to create...
Tiki Trackers is a flexible project management software designed for agile teams. It provides a variety of tools to help plan, organize, and track projects more efficiently.Some key features of Tiki Trackers include:Kanban boards for visualizing work and limiting work-in-progressCustomizable workflows to match your team's processTask dependencies and Gantt charts...
LyteRAD is an open-source, lightweight rapid application development (RAD) tool for building desktop applications. It features a drag-and-drop interface that allows developers to quickly assemble graphical user interfaces by adding widgets like buttons, text boxes, lists, and more without writing a lot of boilerplate code.Some key capabilities and benefits of...
Databuilder.io is an open-source data modeling and ETL (extract, transform, load) pipeline building tool. It provides a graphical interface and drag-and-drop components to enable users to quickly model, validate, transform, and load large volumes of data without having to write any code.Some key capabilities and benefits of Databuilder.io include:Intuitive graphical...
Glom is an open-source GUI database management and design tool for creating relational databases without programming knowledge. It allows users to visually design database schemas, tables, forms, reports and queries to build full-featured database applications.Some key features of Glom include:Visual database designer for creating tables, relations, forms and reports without...
XtraBuild Designer is a leading low-code application development platform that empowers anyone to build custom web and mobile apps fast without coding. With its intuitive visual drag-and-drop interface, non-developers can easily design application flows, connect to data sources, incorporate business logic, and publish across devices.Key features include:Visual app designer -...
NSBase is an open-source alternative to Airtable that allows you to create flexible, customizable databases to organize information. Like Airtable, NSBase uses a spreadsheet-database hybrid model that enables you to structure data into tables with different views and forms.Key features of NSBase include:Intuitive drag-and-drop interface for building databases without codingCustom...
Limbas is an open-source project management software application designed as an alternative to Microsoft Project. It provides a suite of tools for planning, scheduling, resource allocation, collaboration, and progress tracking for projects.Key features of Limbas include:Intuitive Gantt chart interface for visualizing project tasks, timelines and dependenciesResource management tools for assigning...
Handy Application Maker is a powerful yet user-friendly application building platform for quickly creating custom desktop software tailored to your needs, without writing any code.It features an intuitive drag-and-drop interface that allows you to easily add and customize various components like forms, tables, charts, buttons, and more to build full-featured...
MDBLite is an open-source, lightweight, document-oriented database that retains many of the key features of MongoDB while being more resource-efficient. Like MongoDB, MDBLite stores data in flexible JSON-like documents rather than tables in rows and columns. This allows for heterogeneous data types to be stored together and for documents to...