Changes from 2.8 to 2.9

• ✨ New functionality!

  • New select functions like CONCAT, ROUND and much more!

    • QueryBuilder->select()

  • New CONTAINS and NOT CONTAINS conditions available!

    • $criteria

  • New Store->updateOrInsert() and Store->updateOrInsertMany() methods!

    • Documentation of updateOrInsert() method
    • Documentation of updateOrInsertMany() method

• 📝 New documentation page!

  • Order of execution description and diagram to better understand the internals!

    • "Order of Execution"

• 🌈 Improved functionality!

  • findAll() now accept orderBy, limit and offset as optional parameters!

    • Documentation of findAll() method

  • limit() and skip() now accept strings!

    • Documentation of limit() method
    • Documentation of skip() method

  • Having can now be used without Group-By!

    • QueryBuilder->having()

• Fixed: Caching layer did not check read permissions before using glob function.

• Fixed: Read permission was not checked before counting files in folder.

Fixed that new count method did not use caching layer.

Changes from 2.7 to 2.8

• ✨ New functionality!

  • Retrieve the amount of documents stored in a fast way.

    • Store->count()

Fixed error when using SleekDB without composer.

#153

Fix of wrong array key on join #151

Changes from 2.6 to 2.7

• 🚨 New requirement!

  • In order to implement the new search functionality we had to add a new PHP module requirement to SleekDB.

    • ext-mbstring

• 🚨 Deprecated method!

  • The getDataDirectory() method of the Store class is now deprecated. Use getDatabasePath() instead!

• 📝 New documentation page!

  • This new documentation page contains some complete code examples!

    • "Some complete code examples"

• ✨ New functionality!

  • SleekDB now has multiple enhanced searching algorithms with scored results!

    • New "Searching" documentation

  • New store wide search configurations!

    • Configure the search behavion when creating a Store object.

  • New shorthand search() method for Store class!

    • Documentation of new shorthand search() method!

  • New comparisons!

    • Type safe

      • ===
      • !==

    • Type unsafe

      • ==
      • <>

  • Now you can easily remove fields from a document!

    • removeFieldsById()
    • removeFields()

• 🌈 Improved functionality!

  • Configuration on a query by query base with the search() method of the QueryBuilder class

    • Documentation of search() method

  • All *byId methods now also accept strings as id!

    For more details please visit the corresponding documentation pages:

    • findById()
    • updateById()
    • deleteById()
    • removeFieldsById()

Changes from 2.5 to 2.6

• ✨ New functionality

  • SleekDB now can group results and filter grouped results!

    • groupBy()
    • having()

  • Easily update parts of a document with its id!

    • updateById()

  • Use one Store object to manage multiple stores!

    • changeStore()

• 🌈 Improved functionality

  • select()

    For more details please visit the documentation of select.
    • The select method now accepts aliase!
    • When using select in conjunction with groupBy you can use functions!
    • You can now select nested fields!

  • except()

    For more details please visit the documentation of except.
    • You can now exclude nested fields!

  • update() of Query class

    For more details please visit the documentation of update.
    • You can now update nested fields!
    • Can now return the updated results!

Changes from 2.4 to 2.5

✨ New conditions:

The following conditions can now be used with the findBy(), findOneBy(), deleteBy(), where() and orWhere() methods!

• BETWEEN
• NOT BETWEEN

🌈 SleekDB now accepts DateTime objects to filter data!

Visit our new "Working with Dates" documentation page to learn more about date handling.

The methods that accept DateTime objects as a value to check against are:

• findBy
• findOneBy
• deleteBy
• where
• orWhere

The conditions you can use DateTime objects with are:

• =
• !=
• >
• >=
• <=
• IN
• NOT IN
• BETWEEN
• NOT BETWEEN

Changes from 2.3 to 2.4

🚨 Deprecated in() & notIn() methods

They will be removed with the next major update. Please use the new conditions "in" and "not in" instead. Available with the findBy(), findOneBy, deleteBy(), where() and orWhere() methods since version 2.3. See #118 for more details.