All Projects → thorsten → Phpmyfaq

thorsten / Phpmyfaq

Licence: mpl-2.0
phpMyFAQ - Open Source FAQ web application for PHP and MySQL, PostgreSQL and other databases

Projects that are alternatives of or similar to Phpmyfaq

Dbbench
🏋️ dbbench is a simple database benchmarking tool which supports several databases and own scripts
Stars: ✭ 52 (-89.47%)
Mutual labels:  database, mysql, postgresql, sqlite, mariadb, mssql
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+3577.73%)
Mutual labels:  database, mysql, postgresql, mariadb, sqlite, mssql
Linq2db
Linq to database provider.
Stars: ✭ 2,211 (+347.57%)
Mutual labels:  database, mysql, postgresql, sqlite, mariadb, mssql
Sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL.
Stars: ✭ 5,039 (+920.04%)
Mutual labels:  mysql, postgresql, sqlite, mariadb, mssql
Heidisql
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL and SQLite, written in Delphi
Stars: ✭ 2,864 (+479.76%)
Mutual labels:  mysql, postgresql, sqlite, mariadb, mssql
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (-65.79%)
Mutual labels:  mysql, postgresql, sqlite, mariadb, mssql
Sequelize
An easy-to-use and promise-based multi SQL dialects ORM tool for Node.js
Stars: ✭ 25,422 (+5046.15%)
Mutual labels:  mysql, postgresql, sqlite, mariadb, mssql
Denodb
MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Stars: ✭ 498 (+0.81%)
Mutual labels:  database, mysql, postgresql, sqlite, mariadb
Typeorm
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Stars: ✭ 26,559 (+5276.32%)
Mutual labels:  database, mysql, postgresql, sqlite, mariadb
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Stars: ✭ 477 (-3.44%)
Mutual labels:  database, mysql, postgresql, sqlite, mariadb
Next
Directus is a real-time API and App dashboard for managing SQL database content. 🐰
Stars: ✭ 111 (-77.53%)
Mutual labels:  database, mysql, postgresql, sqlite, mssql
Ebean
Ebean ORM
Stars: ✭ 1,172 (+137.25%)
Mutual labels:  database, mysql, elasticsearch, sqlite, mariadb
Directus
Open-Source Data Platform 🐰 — Directus wraps any SQL database with a real-time GraphQL+REST API and an intuitive app for non-technical users.
Stars: ✭ 13,190 (+2570.04%)
Mutual labels:  database, mysql, postgresql, sqlite, mssql
Pgloader
Migrate to PostgreSQL in a single command!
Stars: ✭ 3,754 (+659.92%)
Mutual labels:  database, mysql, postgresql, sqlite, mssql
Dbeaver
Free universal database tool and SQL client
Stars: ✭ 23,752 (+4708.1%)
Mutual labels:  database, mysql, postgresql, sqlite
Endb
Key-value storage for multiple databases. Supports MongoDB, MySQL, Postgres, Redis, and SQLite.
Stars: ✭ 208 (-57.89%)
Mutual labels:  database, mysql, postgresql, sqlite
Medoo
The lightweight PHP database framework to accelerate the development.
Stars: ✭ 4,463 (+803.44%)
Mutual labels:  database, mysql, sqlite, mssql
Migrate
Database migrations. CLI and Golang library.
Stars: ✭ 2,315 (+368.62%)
Mutual labels:  database, mysql, sqlite, mariadb
Db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Stars: ✭ 2,832 (+473.28%)
Mutual labels:  database, mysql, postgresql, sqlite
Php Crud Api
Single file PHP script that adds a REST API to a SQL database
Stars: ✭ 2,904 (+487.85%)
Mutual labels:  database, mysql, postgresql, sqlite

phpMyFAQ 3.1

Packagist PHP Version Support GitHub GitHub commit activity

What is phpMyFAQ?

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 7.3+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and a media manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup and restore system, a dynamic sitemap, related FAQs, tagging, enhanced SEO features, built-in spam protection systems, OpenLDAP and Microsoft Active Directory support, and an easy-to-use installation and update script.

Requirements

phpMyFAQ is only supported on PHP 7.3 and up, you need a database as well. Supported databases are MySQL, MariaDB, Percona Server, PostgreSQL, Microsoft SQL Server and SQLite3. If you want to use Elasticsearch as main search engine, you need Elasticsearch 5.x or later. Check our detailed requirements on phpmyfaq.de for more information.

Installation

phpMyFAQ installation package for end-users

The best way to install phpMyFAQ is to download it on phpmyfaq.de, unzip the package and open http://www.example.org/phpmyfaq/setup/index.php in your preferred browser.

phpMyFAQ installation with Docker

Dockerfile

The Dockerfile provided in this repo only build an environment to run any release it's for development purpose. It does not contain any code as the phpmyfaq folder is meant to be mounted as the /var/www/html folder in the container.

To build a production release please use the docker-hub repository or use images provided on docker.io.

docker-compose.yml

For development purposes you can start a full stack to run your current PhpMyFAQ source code from your local repo.

$ docker-compose up

The command above starts 6 containers for multi database development as following.

Specific images started once to prepare the project:

  • composer: update composer dependencies
  • yarn: update yarn dependencies

Running using named volumes:

  • mariadb: image with MariaDB database with xtrabackup support
  • postgres: image with PostgreSQL database
  • elasticsearch: Open Source Software image (it means it does not have XPack installed)
  • phpmyadmin: a PHP tool to have a look on your database.

Running apache web server with PHP 8.0 support:

  • phpmyfaq: mounts the phpmyfaq folder in place of /var/www/html.

Then services will be available at following addresses:

Running tests

To run the test using Docker you have to install the Composer development dependencies

$ curl -s https://getcomposer.org/installer | php
$ php composer.phar install

Quote from ElasticSearch documentation

The vm.max_map_count kernel setting needs to be set to at least 262144 for production use. Depending on your platform:

Linux

The vm.max*map_count setting should be set permanently in */etc/sysctl.conf_:

$ grep vm.max_map_count /etc/sysctl.conf
vm.max_map_count=262144

To apply the setting on a live system type: sysctl -w vm.max_map_count=262144

macOS with Docker for Mac

The vm.max_map_count setting must be set within the xhyve virtual machine:

$ screen ~/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-linux/tty

Log in with root and no password. Then configure the sysctl setting as you would for Linux:

$ sysctl -w vm.max_map_count=262144
Windows and macOS with Docker Toolbox

The vm.max_map_count setting must be set via docker-machine:

$ docker-machine ssh
$ sudo sysctl -w vm.max_map_count=262144

phpMyFAQ local installation from Github

To run phpMyFAQ locally you need at least a running web server with PHP support and a database.

$ git clone git://github.com/thorsten/phpMyFAQ.git
$ cd phpMyFAQ
$ curl -s https://getcomposer.org/installer | php
$ php composer.phar install
$ curl -o- -L https://yarnpkg.com/install.sh | bash
$ yarn install
$ yarn build

Then just open http://www.example.org/phpmyfaq/setup/index.php in your browser.

Testing

To run our unit tests via PHPUnit v9.x, just execute this command on your CLI

$ curl -s https://getcomposer.org/installer | php
$ php composer.phar install
$ ./vendor/bin/phpunit

Please note that phpMyFAQ needs to be installed via Composer.

Versioning

For transparency and insight into our release cycle, and for striving to maintain backward compatibility, phpMyFAQ will be maintained under the Semantic Versioning guidelines as much as possible.

Releases will be numbered with the following format:

<major>.<minor>.<patch>

And constructed with the following guidelines:

  • Breaking backward compatibility bumps the major (and resets the minor and patch)
  • New additions without breaking backward compatibility bumps the minor (and resets the patch)
  • Bug fixes and misc changes bumps the patch

For more information on SemVer, please visit http://semver.org/.

Bug tracker

Found a bug, or do you have a feature request? Please open a new issue. Before opening any issue, please search for existing issues.

Contributing

Please check out our page about contributing on phpmyfaq.de.

Documentation

You can find the full documentation on phpmyfaq.de.

REST API v2

The REST API v2 documentation is located here in this repository and on phpmyfaq.de.

License

Mozilla Public License 2.0, see LICENSE for more information.

Copyright © 2001 - 2021 Thorsten Rinne and the phpMyFAQ Team

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].