How to implement really small and fast ORM with PHP (Part 4: specification error handling) pre { background-color:#444; white-space:pre-wrap; font-size:90%; padding:0px 6px; } Queries are gaining more and more complexity, data is getting bigger and bigger. Most optimizations in database technology are done in the database server. This is an …
ircmaxell: Framework Fixation – An Anti Pattern ircmaxell: Framework Fixation – An Anti Pattern, short summary: delegation of architecture decisions to frameworks may not be optimal or even wrong only use frameworks when doing prototypes or projects you don’t need to maintain frameworks don’t save time/money in the long term …
Using V8 Javascript engine as a PHP extension (update: write PHP session) pre { background-color:#444; white-space:pre-wrap; font-size:85%; padding:0px 6px; } “We Are Borg PHP. We Will Assimilate You. Resistance Is Futile!” Just got to something described as: This extension embeds the V8 Javascript Engine into PHP. It is called v8js …
To handle a lot of traffic, we need a fast controller with very little memory overhead. First, we implement a dynamic controller. The design is based on the micro frameworks Slim and Silex. The first example maps the URL “http://server/index.php/blog/2012/03/02” to a function with the parameters $year, $month and $day: …
Disadvantages of ORM ORM has attracted a lot of attention in the last years. So let’s get a bit deeper into it.The biggest advantage of ORM is also the biggest disadvantage: queries are generated automatically queries can’t be optimized queries select more data than needed, things get slower, more latency(some …
SSIS package In my previous article I am trying to explain related to What is data warehousing. If you don’t read it please follow this link before going to this… http://sqlknowledgebank.blogspot.in/2012/05/data-warehousing.html In this article I am trying to explain related to SSIS package. A Package is the core object within …
Finding OBJECTS in DB Sometime we have confusion that the object presents in the database or not. To find the objects present we have to query the sys.sysobjects. I am trying to make it easy by a stored procedure. The limitation of the stored procedure is it helps to find …
Partition Table The Table partitioning can make very large tables and index easier to manage and improve the performance of the query. This article is related to table partitioning concept and how you crate the partition table. Hope all of my readers will like it. History Table partitioning was introduced …
GETDATE() Vs SYSDATETIME() To get the current system date and time we can use GETDATE() or SYSDATETIME() function in SQL server. The question is what the difference between them is. To get the answer let execute the SQL statements mentioned bellow. SELECT GETDATE() ‘GETDATE’, SYSDATETIME() ‘SYSDATETIME’ The output is mentioned …
TIME data type SQL Server 2008 introduced a new data type called TIME, which allow the TIME without DATE. Before SQL Server 2008 it is not possible. In this article I am going to explain the TIME data type by creating scenario to understand it better way. Scenario-1 [ The …
SQL 2008 FILESTREAM storage SQL Server never is good to storing unstructured data like video, graphics file, MS-Office file etc. Before SQL server 2008, we have two choices to manage such kind of data mentioned bellow. 1. By using VARBINARY(MAX) columns inside the database. 2. Store the data outside …
Database SCHEMA From SQL Server 2005 the DATABASE SCHEMA is introduced by Microsoft. Before understanding the database schema we must review the SQL Server 2000 to understand it properly. Problem with earlier version of SQL Server (Before SQL Server 2005) In SQL Server 2000 the schema is owned by, and …
CROSS APPLY on SQL 2005 A new feature of Microsoft SQL Server 2005 is “CROSS APPLY”. It restricted “INNER JOIN” between a table (outer query) and a table-valued function (common usage), or derived table from correlated subquery. The table-valued function is evaluated only for the parameter values supplied by the …
IDENTITY Columns Violation We all know about the identity columns of SQL Server and how important it is. This article is related to it but I am representing this article to solving a common proble. First take a quick look about the identity columns and how it works. Then we …
