Open Source Database Software - Page 6

Impala provides low latency and high concurrency for BI/analytic queries on the Hadoop ecosystem, including Iceberg, open data formats, and most cloud storage options. Impala also scales linearly, even in multitenant environments. Impala is integrated with native Hadoop security and Kerberos for authentication, and via the Ranger module, you can ensure that the right users and applications are authorized for the right data. Utilize the same file and data formats and metadata, security, and resource management frameworks as your Hadoop deployment, with no redundant infrastructure or data conversion/duplication. For Apache Hive users, Impala utilizes the same metadata and ODBC driver. Like Hive, Impala supports SQL, so you don't have to worry about reinventing the implementation wheel. With Impala, more users, whether using SQL queries or BI applications, can interact with more data through a single repository and metadata stored from source through analysis.

Create a new production-ready project with backend, frontend and deploy automation by running one CLI command! Focus on writing code and thinking of business-logic! The CLI will take care of the rest. Next, open the generated Ansible inventory file (called hosts.ini) and fill in the variables according to your server configuration. And you're ready to automatically deploy this project. If you don't want to install Create Go App CLI to your system, you feel free to using our official Docker image and run CLI from isolated container. CLI command for deploy Docker containers with your project via Ansible to the remote server. Configured PostgreSQL container with apply migrations for backend. Frontend part will be generate using awesome tool Vite.js under the hood. So, you'll always get the latest version of React, Preact, Vue, Svelte, Lit or pure JavaScript/TypeScript templates.

Logstash is a server-side data processing pipeline that dynamically ingests data from numerous sources, transforms it, and ships it to your favorite “stash” regardless of format or complexity. It supports and ingests data of all shapes, sizes and sources, dynamically transforms and prepares this data, and transports it to the output of your choice. Logstash is extensible, with over 200 plugins available to let you create and configure your pipeline how you choose.

Milvus is an open-source vector database built to power embedding similarity search and AI applications. Milvus makes unstructured data search more accessible, and provides a consistent user experience regardless of the deployment environment. Milvus 2.0 is a cloud-native vector database with storage and computation separated by design. All components in this refactored version of Milvus are stateless to enhance elasticity and flexibility. Average latency measured in milliseconds on trillion vector datasets. Rich APIs designed for data science workflows. Consistent user experience across laptop, local cluster, and cloud. Embed real-time search and analytics into virtually any application. Milvus’ built-in replication and failover/failback features ensure data and applications can maintain business continuity in the event of a disruption. Component-level scalability makes it possible to scale up and down on demand.

Open source intermediate for the MySQL database network protocol written in Java language, open source of GPLv3 protocol. Custom Calcite distributed query engine, edit SQL to relationship algebra expression, rule optimization engine, and cost optimization engine, generate physical execution plan, support logic view. Any cross-currant cross-table join query, support cross-currant cross-table non-associated query, support cross-currant cross-table association query, support cross-currant cross-table Window grammar, support global secondary index, limited support storage process, support visualization configuration. Support parallel extraction of result sets, support the automatic transfer of back-end result sets, support multiple routing notes, and optimizer notes. Parameterization of the requested SQL, cache physics execution plan, and request of the same parameterization SQL, will avoid some analysis and optimization processes.

OrientDB is an Open Source Multi-Model NoSQL DBMS with the support of Native Graphs, Documents, Full-Text search, Reactivity, Geo-Spatial and Object Oriented concepts. It's written in Java and it's amazingly fast. No expensive run-time JOINs, connections are managed as persistent pointers between records. You can traverse thousands of records in no time. Supports schema-less, schema-full and schema-mixed modes. Has a strong security profiling system based on user, roles and predicate security and supports SQL amongst the query languages. Thanks to the SQL layer it's straightforward to use for people skilled in the Relational world. OrientDB adheres to the NoSQL movement even though it supports ACID Transactions and SQL as query language. In this way it's easy to start using it without having to learn too much new stuff.

RethinkDB is the first open-source, scalable, NoSQL database for building realtime applications. It pushes JSON to your apps in realtime and makes building realtime apps so much easier. RethinkDB exposes a new database access model where the developer can tell the database to continuously push updated query results to apps without polling for changes. This expedites the building of realtime, scalable apps while also cutting down on effort. RethinkDB can be used for a number of different things: building realtime trading and optimization engines; simplifying the data infrastructure in multiplayer games to produce low latency, high throughput realtime interactions; building reactive web and mobile apps with a lot less effort, and so much more.

VictoriaMetrics is a fast, cost-effective and scalable monitoring solution and time series database. VictoriaMetrics is available in binary releases, Docker images, Snap packages and source code. Just download the latest version of VictoriaMetrics. VictoriaMetrics is developed at a fast pace, so it is recommended periodically checking the CHANGELOG and performing regular upgrades. It can be used as long-term storage for Prometheus. See these docs for details. It can be used as a drop-in replacement for Prometheus in Grafana, because it supports Prometheus querying API. It can be used as a drop-in replacement for Graphite in Grafana, because it supports Graphite API. It features easy setup and operation. VictoriaMetrics consists of a single small executable without external dependencies. All the configuration is done via explicit command-line flags with reasonable defaults. All the data is stored in a single directory pointed by -storageDataPath command-line flag.

A large crowd-sourced dataset for developing natural language interfaces for relational databases. WikiSQL is the dataset released along with our work Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning. Regarding tokenization and Stanza, when WikiSQL was written 3-years ago, it relied on Stanza, a CoreNLP python wrapper that has since been deprecated. If you'd still like to use the tokenizer, please use the docker image. We do not anticipate switching to the current Stanza as changes to the tokenizer would render the previous results not reproducible.

elasticsearch-head is a web front end for browsing and interacting with an Elastic Search cluster. elasticsearch-head is hosted and can be downloaded or forked at github. There are two ways of running and installing elasticsearch-head. Running as a plugin of ElasticSearch (this is the preferred method). And running as a standalone webapp. By default es-head will immediately attempt to connect to a cluster node at http://localhost:9200/. Enter a different node address in the connect box and click 'Connect' if required. A ClusterOverview, which shows the topology of your cluster and allows you to perform index and node level operations. A couple of search interfaces that allow you to query the cluster a retrieve results in raw json or tabular format. Several quick access tabs that show the status of the cluster. An input section that allows arbitrary call to the RESTful API to be made. This interface includes several options that can be combined to produce interesting results.

immudb is a database with built-in cryptographic proof and verification. It tracks changes in sensitive data and the integrity of the history will be protected by the clients, without the need to trust the database. It can operate both as a key-value store, and/or as a relational database (SQL). Traditional database transactions and logs are mutable, and therefore there is no way to know for sure if your data has been compromised. immudb is immutable. You can add new versions of existing records, but never change or delete records. This lets you store critical data without fear of it being tampered with. Data stored in immudb is cryptographically coherent and verifiable. Unlike blockchains, immudb can handle millions of transactions per second, and can be used both as a lightweight service or embedded in your application as a library. immudb runs everywhere, on an IoT device, your notebook, a server, on-premise or in the cloud.

Open source simple business intelligence application and sql editor tool for Clickhouse. Auto-completion of fields, dictionaries and functions. Tips on fields and functions in Russian and English. Reformatting queries / autoformat. Minimizes brackets and subqueries. Setting the autocompletion / enableLiveAutocompletion. Backlight brackets. The list of functions is loaded based on the capabilities of the server. Displays which query is running. Display the number of tables at the database. The icon of the table depends on its engine. List of fields in the table and inserting the field when clicking in the editor. DB selection via double click in the tree, pop-up window about selection. Search in the tree of objects, filtering the tree. Rebuilding the list of databases / tables after the query is executed. Table with information about completed requests at the end of the list / Requests in the tab are logged for performance comparison.

MySQL Control Center is an excellent GUI front end for MySQL database creation and administration. It allows multiple concurrent MySQL server connections, MDI (or not under Linux), stored login credentials, point and click dump file imports and more.

QuickRedis is a free forever Redis Desktop manager. It supports direct connection, sentinel, and cluster mode, supports multiple languages, supports hundreds of millions of keys, and has an amazing UI. Supports both Windows, Mac OS X and Linux platform.

SchoolMag is a free and opensource msexcel vba standard software for management of school. Create a folder SchoolMaG1.2A in c drive of your pc and there extract the file SchoolMag1.2A.zip. First go to excel option Trust Centre, trust centre setting, macro setting and opt for enable macro, then go to ActiveX setting and opt for enable control without restriction and then click on ok.

SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4, but work fine with PHP5. Work just as well on a platform Linux as on Windows or MAC.

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automaticaly and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

JabRef is a graphical application for managing bibliographical databases. JabRef is designed specifically for BibTeX bases, but can import and export many other bibliographic formats. JabRef runs on all platforms and requires Java 1.8 or newer.

WordNet Database in various SQL format

VFront is a dynamic front-end for MySQL, PostgreSQL and SQLite databases written in PHP and Javascript. With VFront you can create forms for manage data in AJAX style, rules and privileges for differents groups, reports ,statistics and much more. Please note that the project, with the latests updates, has moved on Github: https://github.com/marciuz/vfront/

phpLDAPadmin is a web-based LDAP administration tool for managing your LDAP server. With it you can browse your LDAP tree, view LDAP schema, perform searches, create, delete, copy and edit LDAP entries. You can even copy entries between servers.

ORBADA is a database, SQL, query client using JDBC drivers. It is a tool to administrate and manage database structure. It Is for Oracle, SQLite, Firebird, HSQLDB, DerbyDB, MySQL, PostgreSQL and other databases.

PHP5 RAD and object oriented PHP framework for building event-driven stateful web applications. Based on Zend Framework, features tableless HTML, multiple databases, accesskey support, auto data type recognition, transparent AJAX, UTF-8, i18n/l10n.

JookDB is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, Oracle, PostgreSQL, SQLite, MongoDB,Redis, DM, OceanBase, TiDB and SQLServer databases from a single application. You can quickly and easily build, manage and maintain your databases.

Mole is an automatic SQL Injection exploitation tool. Only by providing a vulnerable URL and a valid string on the site it can detect the injection and exploit it, either by using the union technique or a boolean query based technique. The Mole uses a command based interface, allowing the user to indicate the action he wants to perform easily. The CLI also provides auto-completion on both commands and command arguments, making the user type as less as possible.