Digby, Nova Scotia Web Design & Development Articles
Latest articles from around the web
In this show, Stephen and Chris get to talk about an internal technical detail we were improving in our database, which led to a public-facing feature for y’all. The idea is that all (most, anyway) database tables should have a deleted_at column. When you query against them, under regular circumstances, any rows that have a […] The post 383: Soft Delete All appeared first on CodePen Blog.
Latest PECL Releases:sqlsrv 5.10.0 [Added] Support for PHP 8.1 Support for macOS Monterey, Debian 11, Ubuntu 21.04 and 21.10, Alpine 3.13, 3.14 and 3.15 Support for Apple M1 ARM64 hardware -- requires MS ODBC Driver 17.8+ Adjusted connection keyword and value validation for more flexibility Feature Request #795 - adding support for Table-valued parameters [Removed] Support for PHP 7.3 Support for Ubuntu 16.04, Alpine 3.11 and Alpine 3.12 [Fixed] Pull request #1260 - cleaned up redundant code Issue #1261 - simplified get_field_as_string and made it more robust - pull request #1265 Pull request #1262 - simplified parse_param_array in sqlsrv Pull request #1267 - replaced the obsolete MACRO ZVAL_NEW_ARR with array_init Pull request #1275 - fixed warning compiling core_stmt.cpp by mlocati Pull request #1290 - updated list of supported processor architecture Issue #1307 - added TVP support to non-procedure statements Issue #1310 - adjusted sql_data_type and column size for NULL parameters - pull request #1311 by gjcarrette Pull request #1326 - php drivers simply pass Azure AD Authentication to ODBC driver, which will verify the settings Issue #1329 - reset sql type and column size for input params [Limitations] No support for inout / output params when using sql_variant type No support for inout / output params when formatting decimal values In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work Always Encrypted requires MS ODBC Driver 17+ Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not yet supported Issue #716 - With Always Encrypted enabled, named parameters in subqueries are not supported Issue #1050 - With Always Encrypted enabled, insertion requires the column list for any tables with identity columns Always Encrypted limitations [Known Issues] This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute may be suppressed when using an older ODBC driver. Connection pooling on Linux or macOS is not recommended with unixODBC < 2.3.7 When pooling is enabled in Linux or macOS unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic information, such as error messages, warnings and informative messages due to this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples here pdo_sqlsrv 5.10.0 [Added] - Support for PHP 8.1 - Support for macOS Monterey, Debian 11, Ubuntu 21.04 and 21.10, Alpine 3.13, 3.14 and 3.15 - Support for Apple M1 ARM64 hardware -- requires [MS ODBC Driver 17.8+](https://docs.microsoft.com/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15) - Adjusted connection keyword and value validation for more flexibility - Feature Request [#795](https://github.com/microsoft/msphpsql/issues/795) - adding support for [Table-valued parameters](https://github.com/Microsoft/msphpsql/wiki/Features#tvp) - Feature Request [#1320](https://github.com/microsoft/msphpsql/issues/1320) - allow PDO::ATTR_EMULATE_PREPARES to be set at the connection level [Removed] - Support for PHP 7.3 - Support for Ubuntu 16.04, Alpine 3.11 and Alpine 3.12 [Fixed] - Issue [#1244](https://github.com/microsoft/msphpsql/issues/1244) - use lower case for object names for PDO::lastInsertId() - pull request [#1245](https://github.com/microsoft/msphpsql/pull/1245) by morozov - Pull request [#1251](https://github.com/microsoft/msphpsql/pull/1251) - simplified implementations of last insert id and quote - Issue [#1258](https://github.com/microsoft/msphpsql/issues/1258) - updated pdo_sqlsrv_get_driver_methods as per documentation - pull request [#1259](https://github.com/microsoft/msphpsql/pull/1259) - Pull request [#1260](https://github.com/microsoft/msphpsql/pull/1260) - cleaned up redundant code - Issue [#1261](https://github.com/microsoft/msphpsql/issues/1261) - simplified get_field_as_string and made it more robust - pull request [#1265](https://github.com/microsoft/msphpsql/pull/1265) - Pull request [#1267](https://github.com/microsoft/msphpsql/pull/1267) - replaced the obsolete MACRO ZVAL_NEW_ARR with array_init - Pull request [#1275](https://github.com/microsoft/msphpsql/pull/1275) - fixed warning compiling core_stmt.cpp by mlocati - Pull request [#1288](https://github.com/microsoft/msphpsql/pull/1288) - applied mask to pdo quote for binary inputs - Pull request [#1290](https://github.com/microsoft/msphpsql/pull/1290) - updated list of supported processor architecture - Issue [#1307](https://github.com/microsoft/msphpsql/issues/1307) - added TVP support to non-procedure statements - Issue [#1310](https://github.com/microsoft/msphpsql/issues/1310) - adjusted sql_data_type and column size for NULL parameters - pull request [#1311](https://github.com/microsoft/msphpsql/pull/1311) by gjcarrette - Pull request [#1326](https://github.com/microsoft/msphpsql/pull/1326) - php drivers simply pass Azure AD Authentication to ODBC driver, which will verify the settings - Issue [#1329](https://github.com/microsoft/msphpsql/issues/1329) - reset sql type and column size for input params - Issue [#1331](https://github.com/microsoft/msphpsql/issues/1331) - restore PDO::ATTR_ERRMODE if calling PDO::lastInsertId() call fails - pull request [#1330](https://github.com/microsoft/msphpsql/pull/1330) by mpyw and pull request [#1332](https://github.com/microsoft/msphpsql/pull/1332) [Limitations] - No support for inout / output params when using sql_variant type - No support for inout / output params when formatting decimal values - In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work - Always Encrypted requires [MS ODBC Driver 17+](https://docs.microsoft.com/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server) - Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not yet supported - Issue [#716](https://github.com/Microsoft/msphpsql/issues/716) - With Always Encrypted enabled, named parameters in subqueries are not supported - Issue [#1050](https://github.com/microsoft/msphpsql/issues/1050) - With Always Encrypted enabled, insertion requires the column list for any tables with identity columns - [Always Encrypted limitations](https://docs.microsoft.com/sql/connect/php/using-always-encrypted-php-drivers#limitations-of-the-php-drivers-when-using-always-encrypted) [Known Issues] - This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute may be suppressed when using an older ODBC driver. - Connection pooling on Linux or macOS is not recommended with [unixODBC](http://www.unixodbc.org/) < 2.3.7 - When pooling is enabled in Linux or macOS - unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic information, such as error messages, warnings and informative messages - due to this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples [here](https://github.com/Microsoft/msphpsql/wiki/Features#pooling) gRPC 1.44.0RC2 - gRPC Core 1.44.0 update teds 0.9.2 * Make SortedStrictSet/SortedStrictMap use a red-black tree that is rebalanced on insertions and removals, guaranteeing worst-case logarithmic time for insertions/removals/lookups. teds 0.9.1 * Make SortedStrictSet/SortedStrictMap use a binary search tree (not yet a balanced tree). * Associate iterators on SortedStrictSet/SortedStrictMap with nodes of the tree. Invalidate iterators pointing to a node when that node of the set/map is removed. * Fix sorting order when instantiating StableSortedListSet/SortedStrictSet/SortedStrictMap from unsorted arrays. protobuf 3.19.4 * Fixed a data loss bug that could occur when the number of optional fields in a message is an exact multiple of 32. (#9440). teds 0.9.0 * Migrate `TedsStrictSet`, `TedsStrictMap`, and `Tedsunique_values` implementation to use an actual hash table instead of a list of unique values. dio 0.2.1 - fix windows build
If you think that a camera and a subject is all that is needed for capturing amazing pictures, then you are wrong. Apart from your motive, ambiance and subject, you would require a number of different instruments and editing softwares to give your pictures the professional touch. Capturing an image is just the tip of...
Christmas is a busy time for most retailers. However, some fare better than others in the run-up to the festive season. Digital marketing provides access to a wider audience of potential customers who may be interested in what you have to offer. The lead to conversion rate at Christmas soars, but finding the leads in...
JetBrains Academy launched its new Kotlin Basics program as a free introduction for people getting into software development to get started on the most popular language for building Android apps. In this track, students will get familiarized with the language syntax, concepts, and libraries, as well as with the basics of object-oriented programming. Students will … continue reading The post JetBrains Academy launches Kotlin Basics appeared first on SD Times.
If you're looking for a way to future-proof your designs, there's no better way to start than finding a modern, futuristic font for your projects. And this collection of the best modern and futuristic fonts is a great place to start! We’ve picked out some of the best futuristic fonts you can use with your […]
Latest PECL Releases:swoole 4.2.6+ Built-in hiredis dependency, no longer needed to compile it separately, refactor CoRedis, more stable Improve the compilation test of the Alpine system Refactor Co::exec and functions about file to fix its execution and output issues in some scenarios Fixed errors about coroutine switching in multi-level nesting and multiple suspend scenarios Fixed connection leaks that may occur when both sides are closed at the same time Fixed channel bug in blocking scenarios Fixed mysql->prepare return true (#2080) Fixed the reference count problem when use swoole_table as an array (#2079) Fixed ssl_host_name cannot open SNI (#2085) Fixed kqueue nanosecond conversion problem under MacOS (#2087) Fixed all swoole_object dangling pointer Add a series of scripting tools for the underlying development
Every business’s primary goal is to sell, and with such fierce competition, it’s critical to use effective marketing methods in order to stand out. Explainer... The post How Explainer Video Can Boost Your Marketing? appeared first on Web Development & Technology Resources.
About The Coding Studio Inc.
Developing professional web applications
for Digby, Nova Scotia, for 20 years!
With years of experience and many satisfied customers, we provide the direction and assistance you require.
Custom Web Development
We specialize in complex custom web projects, from small business websites to corporate applications.
We create an experience which converts more leads and retains more customers, which increases profits.
We help to simplify and automate employee tasks, which reduces payroll and other expenses.