I always recommend to use PayPal Payments pro for Digital Goods.
Payments pro is a real time payment gateway, so the order details will only be stored in the database if the Order is successful.
With Payments standard, you would need to use IOPN to update the order status when paypal processes the transaction with the bank, which is not done in real time.