curdle

curdle - separate or cause to separate into curds or lumps

curdle is a simple database administration tool for simple CRUD operations using almost any relational database you prefer.

Demo

See a live demo here: http://curdle.sitilge.id.lv

Features

• Adapt an existing or new database with ease
• CRUD the tables, rows, and columns in an elegant interface
• Search & order the rows instantly
• Customize columns to fit your needs - simple value, dropdown, editor, image, and more
• Join tables to get the best of multiple sources
• Use the image gallery to manage your media files

Installation

Clone the project

git clone https://github.com/sitilge/curdle

Install composer on your system and run

composer install

Configuration

The respective .json files for the project are located under app/Misc/Admin. File names must match the table names.

{
  "key": "id",              //required, the table primary key
  "name": "Users",          //optional, the table display name, defaults to table name
  "create": true,           //optional, allow to create a new row, defaults to false
  "update": true,           //optional, allow to update the row, defaults to false
  "delete": true,           //optional, allow to delete the row, defaults to false
  "order": {                //optional, change the order of rows in table view, defaults to false
    "column": "sequence",   //required, the name of the column
    "direction": "ASC"      //optional, the direction of order, defaults to ASC
  },
  "columns": {              //required, the columns array
    "name": {               //required, the column name
      "name": "Name",       //optional, the column display name, defaults to column name
      "view": "row",        //optional, display the column in table or row view, defaults to false
      "attributes": {       //optional, the input/select field attributes, defaults to false
        "required": "true",
        "placeholder": "Enter your name..."
        ...
      },
      "plugin": "text",     //optional, set a plugin to slug, price, text, image, date, time, or datetime defaults to false
      "values": {           //optional, create a dropdown for the values, defaults to false
        "0": "No",
        "1": "Yes"
        ...
      },
      "join": {             //optional, join with a table
        "icons": {          //required, the join table name
          "key": "id",      //required, the join table primary key
          "columns": {      //required, the join columns array
            "id": {},       //required, the join column name
            "name": {}
            ...
          }
        }
      }
    }
  }
}

Contributing

It is more than welcome to contribute to the project - feel free to send pull requests. Also, I try to keep the issue section updated but don't feel limited only by that. I would happily accept all critics/opinions/praises to sitilge@gmail.com.