The SSE is a very useful method to push data from server to client. This article explains the requirement and implementation of SSE with Session so that each of the connected clients get customized response.
When you have date and time separate in two fields, it becomes difficult to have date operation like add in them. To have a correct solution, we need to join these two fields and create a new DateTime value on which we can operate on. Use the following code in...Read more
Overtime, the Oracle DB will become sluggish with the insert/update/deletes. So we need to optimize the DB so that the queries are faster. To optimize a single table, use the following command: exec DBMS_STATS.GATHER_TABLE_STATS (ownname => ‘&schema’ , tabname => ‘&tabname’, cascade => true); To optimize a single schema and...Read more
If we need to store all the URL variables to the DB, say, for tracking the user, it is easy. We can use a varchar field to store this information and retrieve later. But when it comes to FORM variables or Objects, the RDBMS does not support storing them. The...Read more
The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue, Sum(cost) cost FROM revenue GROUP BY revenue.title_id) r LEFT JOIN (SELECT title_id, Sum(interest) interest FROM fund GROUP BY title_id) f...Read more
With PHP and MySQL, if the MySQL is upgraded you may end up with this error on every request to the database from PHP. This error means the MySQL library in PHP is not compatible with the version of MySQL it is connecting to. So, the solution is that you...Read more