Search Results for "sql"
Sort By:
Showing 2846 open source projects for "sql"
View related business solutions-
The Most Powerful Software Platform for EHSQ and ESG ManagementChoose from a complete set of software solutions across EHSQ that address all aspects of top performing Environmental, Health and Safety, and Quality management programs.
-
Component Content Management System for Software DocumentationPaligo is an end-to-end Component Content Management System (CCMS) solution for technical documentation, policies and procedures, knowledge management, and more.
-
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. -
Respond 100x faster, more accurately, and improve your documentationSlash response times for questionnaires, audits, and RFPs by up to 90%. OptiValue.ai automates the heavy lifting, freeing your team to focus on strategic priorities with intuitive tools for seamless review and validation.
-
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
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. -
7
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. ... -
8
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. -
9
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. ... -
Go beyond a virtual data room with Datasite DiligenceThe data room with a view. Evolved for next-generation M&A. Built on decades of deal experience. Packed with expert tools, yet intuitive for novices. A fully mobile platform with frictionless processes. Smart AI tools that let you close more deals, faster, plus end-to-end support at all times. Do due diligence with intelligence.
-
10
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. -
11
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. ... -
12
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. -
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
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. ... -
15
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. -
16
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. -
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
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... -
19
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. -
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
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... -
22
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. -
23
MySQL Edit Table
Editor for MySQL - PHP class
Editor for MySQL database tables. Edit, View or Add records of a MySQL table. Languages: English, French, German, Italian, (Mex) Spanish, Dutch and Swedish -
24
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. -
25
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.
