Menu
I was trying to set SQLITE_MAX_COMPOUND_SELECT to something higher than 500 (the current limit) I saw this - http://www.sqlite.org/c3ref/limit.html to set runtime limits and later realised that it mentions "SQLITE C interface" in the heading.
Is there any PHP equivalent?
643
SQLite PHP. PHP provides two SQLite extensions by default since version 5.0. The latest SQLite extension is known as sqlite3 extension that is included in PHP 5.3+. The sqlite3 extension provides an interface for accessing SQLite 3. The sqlite3 includes class interfaces to the SQL commands.
Introduction to SQLite LIMIT clause The LIMIT clause is an optional part of the SELECT statement. You use the LIMIT clause to constrain the number of rows returned by the query. For example, a SELECT statement may return one million rows.
On the other hand, many experienced database designers will argue that a well-normalized database will never need more than 100 columns in a table. SQLite does not support joins containing more than 64 tables. The theoretical maximum number of rows in a table is 2^64 (18446744073709551616 or about 1.8e+19).
The sqlite3 includes class interfaces to the SQL commands. In addition, it allows you to create SQL functions and aggregate using PHP. PHP introduced the PDO interfaces since version 5.1. The PDO is the latest PHP solution that provides a unified database access interface.
Neither the SQLite 3 extension nor PDO seem to expose that function.
It's possible that PHP is using the system's sqlite3 libraries. In that case, if you control the server, you may be able to "simply" recompile the library with a higher default value.
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
