database

💾 A database layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle.

OTHER License

Downloads
4.7M
Stars
482
Committers
76

Bot releases are visible (Hide)

database - Released version 2.3.3

Published by dg about 9 years ago

  • Selection: Related prototype depends on specific cache key

For the details you can have a look at the diff.

database - Released version 2.3.2

Published by dg about 9 years ago

  • ResultSet: parameters are passed to statement via bindValue with correct type #63
  • Selection::fetchAssoc fix
  • Table: fixed infinite recursion when using StaticConventions and trying to access undefined column

For the details you can have a look at the diff.

database - Released version 2.3.1

Published by dg about 9 years ago

  • ActiveRow: added support to update primary columns via update() #57 #58
  • added support for objects DateInterval via ISupplementalDriver::formatDateInterval() #56
  • Revert "SqlPreprocessor: fixed IN (?) with empty array"
  • Table: fixed Selection::getReferencedTable() always refetching when primary is NULL

For the details you can have a look at the diff.

database - Released version 2.2.5

Published by dg about 9 years ago

  • Helpers::loadFromFile() uses native exec() without logging and creating result set
  • Selection: Related prototype depends on specific cache key
  • Table: fixed Selection::getReferencedTable() always refetching when primary is NULL
  • travis: migrating to container-based infrastructure
  • improved coding style

For the details you can have a look at the diff.

database - Released version 2.2.4

Published by dg about 9 years ago

  • SqlBuilder: uses delimited table name #49
  • ConnectionPanel: generates unique ID across requests
  • ConnectionPanel refactoring, used templates
  • Connection: undeprecated some methods, partially reverts commit 88184104
  • PgSqlDriver: fixed formatLike() #46
  • SqlBuilder: table and column names in joins can begin with number or underscore
  • ConnectionPanel: fixed quirky htmlspecialchars in PHP 5.6

For the details you can have a look at the diff.

database - Released version 2.3.0

Published by dg over 9 years ago

  • throws own exceptions:
    • DriverException, ConnectionException
    • ConstraintViolationException, ForeignKeyConstraintViolationException, NotNullConstraintViolationException and UniqueConstraintViolationException
  • added support for += and -= in UPDATE statement
  • added support for operators in WHERE & AND
  • implemented ?and ?or ?set ?values ?order ?name
  • added support for '.' in column names
  • forbidden syntax 'sql', 'sql', ..., i.e. after every SQL string must be at least one parameter
  • SqlLiteral is parsed using SqlPreprocessor
  • table and column names in joins can begin with number or underscore
  • classes *Reflection split into with *Conventions & Structure
  • added IRowContainer::fetchAssoc(), ISupplementalDriver::convertException() (BC break)
  • PgSqlDriver: fixed formatLike() #46
  • MySqlDriver by default uses utf8mb4 encoding for MySQL >= 5.5.3 instead of utf8 (possible problem)
  • Connection: undeprecated some methods
  • DatabaseExtension: added alias 'database.x.connection' for 'database.x'
  • to ensure that new SQL translator do the same job as older one, you can install special tool named CompatibilityChecker22
database - Released version 2.2.3

Published by dg over 9 years ago

  • Helpers::dumpSql() quotes strings using connection
  • SqlPreprocessor: fixed non-associative array detection

For the details you can have a look at the diff.

database - Released version 2.2.2

Published by dg about 10 years ago

  • DI: fixed autowiring for multiple connections
  • fixed & enhanced support for multiple scheme reflection
  • NDBT: added support for NULL with operator NOT

For the details you can have a look at the diff.

database - Released version 2.2.1

Published by dg over 10 years ago

  • ResultSet: fix, empty keys are not converted to properties

For the details about the changes you can have a look at the Github diff.

database - Released version 2.2.0

Published by dg over 10 years ago

The first standalone release. For more information see readme.md.

Package Rankings
Top 0.54% on Packagist.org
Badges
Extracted from project README
Nette Database Downloads this Month Tests Latest Stable Version License Buy me a coffee