Bug 214806 - New port: databases/phpliteadmin , web-based SQLite database admin tool written in PHP
Summary: New port: databases/phpliteadmin , web-based SQLite database admin tool writt...
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Nikolai Lifanov
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-11-24 12:52 UTC by Oleg Ginzburg
Modified: 2017-03-12 16:48 UTC (History)
1 user (show)

See Also:


Attachments
New port: databases/phpliteadmin , web-based SQLite database admin tool written in PHP (2.84 KB, text/plain)
2016-11-24 12:52 UTC, Oleg Ginzburg
no flags Details
candidate shar (2.35 KB, text/plain)
2017-03-03 15:35 UTC, Nikolai Lifanov
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Oleg Ginzburg 2016-11-24 12:52:55 UTC
Created attachment 177352 [details]
New port: databases/phpliteadmin , web-based SQLite database admin tool written in PHP

Features

    Lightweight - consists of a single 200KB source file for portability
    Supports SQLite3 and SQLite2 databases
    Translated and available in over 10 languages - and counting
    Specify and manage an unlimited number of databases
    Specify a directory and optionally its subdirectories to scan for databases
    Create and delete databases
    Add, delete, rename, empty, and drop tables
    Browse, add, edit, and delete records
    Add, delete, and edit table columns
    Manage table indexes
    Manage table triggers
    Import and export tables, structure, indexes, and data (SQL, CSV)
    View data as bar, pie, and line charts
    Graphical search tool to find records based on specified field values
    Create and run your own custom SQL queries in the free-form query editor/builder
    Easily apply core SQLite functions to column values using the GUI
    Write your own PHP functions to be available to apply to column values
    Design your own theme using CSS or install a pre-made theme from the community
    All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases
    Allows multiple installations on the same server, each with a different password
    Secure password-protected interface with login screen and cookies
Comment 1 Nikolai Lifanov freebsd_committer freebsd_triage 2017-03-03 15:32:57 UTC
I made a few small changes.

o update to 1.9.7.1
o add "Created by" line
o un-hardcode DISTNAME
o remove plus from SUB_FILES+=

Let me know if that's OK.
Comment 2 Nikolai Lifanov freebsd_committer freebsd_triage 2017-03-03 15:35:58 UTC
Created attachment 180467 [details]
candidate shar
Comment 3 commit-hook freebsd_committer freebsd_triage 2017-03-12 16:45:39 UTC
A commit references this bug:

Author: lifanov
Date: Sun Mar 12 16:44:33 UTC 2017
New revision: 435995
URL: https://svnweb.freebsd.org/changeset/ports/435995

Log:
  New port: databases/phpliteadmin , web-based SQLite database admin tool written in PHP

  Features

      Lightweight - consists of a single 200KB source file for portability
      Supports SQLite3 and SQLite2 databases
      Translated and available in over 10 languages - and counting
      Specify and manage an unlimited number of databases
      Specify a directory and optionally its subdirectories to scan for databases
      Create and delete databases
      Add, delete, rename, empty, and drop tables
      Browse, add, edit, and delete records
      Add, delete, and edit table columns
      Manage table indexes
      Manage table triggers
      Import and export tables, structure, indexes, and data (SQL, CSV)
      View data as bar, pie, and line charts
      Graphical search tool to find records based on specified field values
      Create and run your own custom SQL queries in the free-form query editor/builder
      Easily apply core SQLite functions to column values using the GUI
      Write your own PHP functions to be available to apply to column values
      Design your own theme using CSS or install a pre-made theme from the community
      All presented in an intuitive, easy-to-use GUI that allows non-technical, SQL-illiterate users to fully manage databases
      Allows multiple installations on the same server, each with a different password
      Secure password-protected interface with login screen and cookies

  PR:		214806
  Submitted by:	olevole@olevole.ru

Changes:
  head/databases/Makefile
  head/databases/phpliteadmin/
  head/databases/phpliteadmin/Makefile
  head/databases/phpliteadmin/distinfo
  head/databases/phpliteadmin/files/
  head/databases/phpliteadmin/files/pkg-message.in
  head/databases/phpliteadmin/pkg-descr
Comment 4 Nikolai Lifanov freebsd_committer freebsd_triage 2017-03-12 16:48:38 UTC
Committed with changes, thanks!