Search Results for "sql"
Sort By:
Showing 2846 open source projects for "sql"
View related business solutions-
Desktop and Mobile Device Management SoftwareDesktop Central is a unified endpoint management (UEM) solution that helps in managing servers, laptops, desktops, smartphones, and tablets from a central location.
-
Free and Open Source HR SoftwareGive your HR team the tools they need to streamline administrative tasks, support employees, and make informed decisions with the OrangeHRM free and open source HR software.
-
1
Countries States Cities Database
Discover our global repository of countries, states, and cities
Full Database of city state country available in JSON, SQL, XML, YAML & CSV format. All Countries, States and cities are Covered and populated with Different Combinations and versions. The API database is regularly updated to ensure the latest data is available to users. Discover our global repository of countries, states, and cities! Get comprehensive data in JSON, SQL, XML, YAML, and CSV formats. -
2
Adminer
Database management in a single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin. Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Connect to a database server with username and password. Select an existing database or create a new one. List fields, indexes, foreign keys and triggers of table Change name, engine, collation, auto_increment and comment of table. ... -
3
Database connection pool with support for lots of languages and databases.
-
4
PHP-CRUD-API
Single file PHP script that adds a REST API to a SQL database
Single file PHP script that adds a REST API to a MySQL/MariaDB, PostgreSQL, SQL Server or SQLite database. Howto: Upload "api.php" to your webserver, configure it to connect to your database, have an instant full-featured REST API. This is the TreeQL reference implementation in PHP. This is a single file application! Upload "api.php" somewhere and enjoy! For local development you may run PHP's built-in web server. -
Cloud-based help desk software with ServoDeskWhat if You Could Automate 90% of Your Repetitive Tasks in Under 30 Days? At ServoDesk, we help businesses like yours automate operations with AI, allowing you to cut service times in half and increase productivity by 25% - without hiring more staff.
-
5
Doctrine JSON Functions
Doctrine DQL functions for SQL JSON data type
DoctrineJsonFunctions is a library that adds native support for JSON-related SQL functions to Doctrine ORM. It extends Doctrine’s DQL capabilities to handle PostgreSQL, MySQL, and SQLite JSON functions, enabling developers to write expressive queries involving JSON fields directly in DQL. This is especially useful for applications that store semi-structured data in relational databases. -
6
Medoo
The lightweight PHP database framework to accelerate the development
...A lightweight PHP database framework to accelerate development. Supports MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle, and more. Supports various common and complex SQL queries, data mapping, and prevents SQL injection. Works well with every PHP framework, like Laravel, Yii, Slim, and framework which supports singleton extension or composer. -
7
phpMyAdmin
A web interface for MySQL and MariaDB
...Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement. phpMyAdmin comes with a wide range of documentation and users are welcome to update our wiki pages to share ideas and howtos for various operations. The phpMyAdmin team will try to help you if you face any problem; you can use a variety of support channels to get help. phpMyAdmin is also very deeply documented in a book written by one of the developers, mastering phpMyAdmin for Effective MySQL Management, which is available in English and Spanish. ... -
8
Backup Tables
Backup single or multiple database tables with ease
Backup single or multiple database tables with ease. Use the BackupTables::generateBackup($tableToBackup) Facade anywhere in your application and it will generate $tableToBackup_backup_2024_08_22_17_40_01 table in the database with all the data and structure. Note that the datetime 2024_08_22_17_40_01 will be varied based on your datetime. -
9
atk4/data
Data Access PHP Framework for SQL & high-latency databases
...It provides a high-level abstraction for working with databases, making it easier to define and manipulate data models with minimal boilerplate code. It supports various SQL and NoSQL databases and integrates seamlessly with Agile UI and other PHP frameworks. -
PairSoft | AP Automation and Doc ManagementStreamline operations and elevate your team's efficiency with PairSoft. Our AP automation, procurement, and document management solutions eliminate manual processes, cut costs, and free your team to focus on strategic initiatives. Experience our state-of-the-art invoice-to-pay solution, now integrated with advanced AI technology for faster, smarter results. Our customers report a significant 70% reduction in approval times and annual savings of $62,000 in employee hours. At PairSoft, we aim to transform your business operations through automation. Explore the future of automation at pairsoft.com, where you can leverage cutting-edge features like invoice capture, OCR, and comprehensive AP automation to transform your workflow. Whether you are a small business or a large enterprise, our solutions are designed to scale with your needs, providing robust functionality and ease of use. Join the growing number of businesses that trust PairSoft.
-
10
Doctrine ORM
Doctrine Object Relational Mapper
Doctrine 2 is an object-relational mapper (ORM) for PHP 7.1+ that provides transparent persistence for PHP objects. It sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernate's HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication. As the term ORM already hints at, Doctrine ORM aims to simplify the translation between database rows and the PHP object model. ... -
11
Fast Paginate for Laravel
A fast implementation of offset/limit pagination for Laravel.
This is a fast limit/offset pagination macro for Laravel. It can be used in place of the standard paginate methods. This package uses a SQL method similar to a "deferred join" to achieve this speedup. A deferred join is a technique that defers access to requested columns until after the offset and limit have been applied. In our case we don't actually do a join, but rather a where in with a subquery. Using this technique we create a subquery that can be optimized with specific indexes for maximum speed and then use those results to fetch the full rows. -
12
Laravel Request Docs
Effortless API documentation tool for Laravel applications
The Hassle-Free automatic API documentation generation for Laravel. Automatic rules fetching from injected Request and by regexp. Automatic routes fetching from Laravel Routes. Support for Laravel logs. Support for SQL query and query time. Support for HTTP response time and memory consumption. Support for Authorization Headers. Support for File uploads, and support for Eloquents events. Display extra documentation using markdown. Saves the history of previous requests. Added filters to sort, group, and filter routes by methods, controllers, middleware, and routes. ... -
13
World countries JSON
Constantly updated lists of world countries
Constantly updated lists of world countries and their associated alpha-2, alpha-3 and numeric country codes as defined by the ISO 3166 standard, available in CSV, JSON , PHP, SQL and XML formats, in multiple languages and with national flags included; also available are the ISO 3166-2 codes of provinces/ states associated with the countries. Also available are the ISO 3166-2 codes used for identifying the principal subdivisions (e.g., provinces or states) of all countries coded in ISO 3166-1. -
14
Phinx
PHP database migrations for everyone
Most database migration tools are framework-dependent, complicated, confusing to install/configure and a pain in the ass to write migrations for. In less than 5 minutes you can install Phinx, create and execute your first migration. Phinx supports migrations written in both PHP and SQL. Use the PHP syntax to make your migrations portable between different database vendors or hand-code advanced queries. It's your choice. As Phinx executes from the command-line, it is painless to integrate with your deploy, build or CI tool. Phinx is and will always remain completely free, open-source software. Developers are encouraged to fork, hack and modify Phinx. ... -
15
AdminerEvo
Database management in a single PHP file
AdminerEvo is a modern fork of Adminer, a lightweight and single-file database management tool for web servers. It retains Adminer's core functionality while enhancing usability, compatibility, and design. AdminerEvo supports multiple databases and is ideal for quick database inspection, management, and prototyping without installing heavy clients. -
16
FlatPress
FlatPress is a lightweight, easy-to-set-up flat-file blogging engine
FlatPress is a lightweight, flat-file CMS that allows users to create and manage blogs without requiring a database. It is designed for simplicity, portability, and low resource usage, making it ideal for small websites and personal projects. -
17
Fat-Free Framework (FatFree)
A powerful yet easy-to-use PHP micro-framework
Fat-Free Framework (F3) is a lightweight, modular PHP micro-framework designed to build web applications with minimal effort. It provides a set of essential tools for routing, templating, database interaction, and caching while keeping the core codebase compact and efficient. F3 is suitable for developers who want to create small to medium-sized applications without the overhead of larger frameworks. -
18
EasyDB
Easy-to-use PDO wrapper for PHP projects
EasyDB is a secure, lightweight, and extensible database wrapper for PHP built on top of PDO. It simplifies query building, error handling, and parameter binding while encouraging best practices like prepared statements. EasyDB is designed for small to mid-sized applications that need clean and secure database access. -
19
Laravel DB Snapshots
Quickly dump and load databases
Laravel DB Snapshots is a package that allows you to easily create, load, and manage database snapshots within Laravel applications. It’s especially useful in testing and staging environments where resetting the database to a known state is critical. By integrating with Laravel’s Artisan commands, the tool offers a streamlined developer experience. -
20
LaraDumps
LaraDumps is a friendly app designed to boost your Laravel PHP coding
LaraDumps is a friendly app that boosts your Laravel PHP coding and debugging experience. When using LaraDumps, you can see the result of your debug displayed in a standalone Desktop application. -
21
Symfony DebugBundle
Provides a tight integration of the Symfony VarDumper component
The Symfony Debug Bundle is a development tool that enhances the debugging experience in Symfony applications. It provides real-time feedback on exceptions, request data, and performance metrics through the Symfony Web Debug Toolbar. The bundle integrates deeply with Symfony’s profiler, offering insights into routing, database queries, and service usage, making it essential for debugging and performance tuning during development. -
22
Drush
Drush is a command-line shell and scripting interface for Drupal
Drush is a powerful command-line tool for managing Drupal websites. It streamlines common administrative tasks such as module installation, database updates, and cache clearing, enabling developers to automate workflows and speed up site management. Drush is widely adopted in the Drupal community for its efficiency and scripting capabilities. -
23
Laravel Visits
Laravel Visits is a counter that can be attached to any model
Laravel Visits is a counter that can be attached to any model to track its visits with useful features like IP protection and lists caching. -
24
Inspector
Code Execution Monitoring foe Laravel applications
Fix fast every release and spot new weak points in real-time as your code evolves. Easily pinpoint and troubleshoot performance bottlenecks within your app in less than a minute. Visualize what your application is doing during HTTP requests or background tasks. You can immediately understand which statement can be optimized to make your application more efficient, and your customers happy. Get detailed insights to identify and fix slow-performing queries and other critical tasks immediately... -
25
Doctrine DBAL
Doctrine database abstraction layer
Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. The Doctrine database abstraction & access layer (DBAL) offers a lightweight and thin runtime layer around a PDO-like API and a lot of additional, horizontal features like database schema introspection and manipulation through an OO API. The fact that the Doctrine DBAL abstracts the concrete PDO API away through the use of interfaces that closely resemble the existing PDO API...
