Monday, 20 November 2017  
 
Dolvin Blog
Dolvin Blog » Our DB
What is Pegasystems?
by. Dolvin ≈ December 11, 2015
It's been so long I'm not write about programming thing
And suddenly, this week I had been asked to join this Pega Project
All of applications in my company want to change with this Pega framework (and that's mean I have to overtime this month.. oh noo..)

What is Pegasystems?

Pegasystems develops strategic applications for sales, marketing, service and operations. Pega’s applications streamline critical business operations, connect enterprises to their customers seamlessly in real-time across channels, and adapt to meet rapidly changing requirements. Pega’s Global 2000 customers include many of world’s most sophisticated and successful enterprises. Pega’s applications, available on-premises or in the cloud, are built on its unified Pega 7 platform, which uses visual tools to easily extend and change applications to meet clients’ strategic business needs.

Source: pega.com

and what is that mean from the paragraph above? dun ask me.. coz I'm just copy paste from its website hahaha... (ops)
Actually this framework is quite interesting and quite powerful
This framework is just click and drag.. hmm.. it's looks like VB ya..
and it seems more easy than others.. But I dun know what difficulty that I'll find when I already code it, coz I still learning by myself

But I hope I dun have to overtime too late
Coz my little kiddo will be waiting for me, and it's so pity for her

Hm.. This is what I do for this week


Category :  Programming    Comment : 0 Comment
Replace Into - MySql Query
by. Dolvin ≈ August 2, 2008
I like using this syntax in MySql coz it have a simple syntax and so efficient when I want to insert a record but if it already exist, it'll update the data... 
but it not too recommended, coz from the statement below.. REPLACE INTO will slower the performer...

Mechanism ::

   1. Try to insert the new row into the table
   2. While the insertion fails because a duplicate-key error occurs for a primary key or unique index:
         1. Delete from the table the conflicting row that has the duplicate key value
         2. Try again to insert the new row into the table

Syntac ::
REPLACE INTO F SELECT * FROM T;
REPLACE INTO F(a, b, c) SELECT a, b, c FROM T;
Summary:
REPLACE INTO becomes more efficient from DELETE FROM… INSERT INTO… but  much slower performer than an UPDATE statement. Better use “INSERT … ON DUPLICATE KEY UPDATE…” as an alternative if you’re looking at a single unique column table (Primary Key).

source : http://blog.sherlock-group.com
Category :  Programming    Comment : 0 Comment
Triggers in MySql
by. Dolvin ≈ July 16, 2007
Today I learned bout Triggers in MySql,
Triggers are programmable events that react to queries and reside directly on the database server. Triggers can be executed before or after INSERT, UPDATE or DELETE statements.

with triggers, we can know what data has been insert, update or delete.
actually it's easy to create, this is the example:

DELIMITER |

CREATE TRIGGER newsCounter AFTER INSERT ON News
  FOR EACH ROW BEGIN
      INSERT INTO NewsCount (newsItemCount) (SELECT count(*) FROM News);
  END;

|
DELIMITER ;


that example, is to get and insert the news count at NewsCount table when user insert at News table


and to get a triggers list at your database, you can run this:
SHOW TRIGGERS;


but u cannot create triggers from phpMyAdmin, it just can create from MySql Client like SQLyog (http://www.webyog.com/en/)

and sometimes you have to be a super user to create triggers at your database.

for more information bout triggers, u can visit this site:
http://dev.mysql.com/doc/mysql/en/triggers.html

it's quite fun, when u have to learn something new.. at your office
Category :  Programming    Comment : 2 Comment
Page : 1 
:: November '17 ::
 
 
S
M
T
W
T
F
S
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
   

:: My Blog List ::
 
   
   

:: Blog Category ::
 
 
» Books
» Christian Soul
» Fashion
» Film
» Foods & Drinks
» Games
» General Info
» Health
» Jokes
» Love
» Music
» My Life
» Programming
» Technology
 
   

:: Site Links ::
 
 
» Angel Sulistyo
» Anton Ongsono
» Darwin
» Fellys
» Inge
» Kado Imut
» Koleksi Unik
» Lie Fung
» Lintaka
» Lobak
» Rosrita
 
   
 
:: Dolvin Website | Dolvin Blog | Our DB ::
Copyright © Lavinia - 2006 - 2017