Friday, October 5, 2007

Singer MySQL

$ mysql -u root -p

Enter password: 84.......

Using tutorial at:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

For facebook example 4 app (display counter):
mysql> create database menagerie; /* this was name of database in above tutorial */
Query OK, 1 row affected (0.00 sec)
mysql> use menagerie;
Database changed

mysql> show tables;
Empty set (0.00 sec)

mysql> create table counter (count INT);
Query OK, 0 rows affected (0.06 sec)

mysql> quit

Bye


Then, in dbappinclude.php:

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'menagerie'; /* the name of the database created in the above tutorial */

Ran into trouble though because the php_mysql package is not installed on singer. Asked SNR to install it or tell me how.

mysql> create database footprints;
mysql> use footprints;
mysql> create table 'footprints' (
--> 'from' int(11) NOT NULL default '0',
--> 'to' int(11) NOT NULL default '0',
--> 'time' int(11) NOT NULL default '0',
--> KEY 'from' ('from'),
--> KEY 'to' ('to')
--> );





Tuesday, October 2, 2007

HSA vs. FSA accounts - Reimbursable Expenses

From 2008 Medical Benefits Overview:

If you have both an HSA and an FSA — and you want
to make tax-advantaged contributions to your HSA —
your FSA must be converted to a “limited” health care
FSA, one that reimburses only eligible dental, vision and
preventive care expenses not covered by the medical
plan. (In other words, a “limited” health care FSA
cannot be used to pay for nonpreventive medical
care and services.)

KHP - So any medical preventive care. Not so clear about dental and vision although preventive dental and vision care are good bets for being covered by the limited FSA.

Reading a bit from IRS Publication 969, one can only contribute up to the annual health plan deductible but not more than $5450 (Benefits Update says $5650). My deductible seems to be $2200. So, I can only increase potentially from $1650 to $2200.

More from 969:
Other Health Coverage
You can also have coverage (whether provided through
insurance or otherwise) for the following items.
  • Accidents
  • Disability
  • Dental Care
  • Vision Care
  • Long Term Care
Limited-purpose health FSA or HRA. These arrangements can pay or reimburse the items listed earlier under Other health coverage, except long-term care. Also, these arrangements can pay or reimburse preventive care expenses because they can be paid without having to satisfy the deductible.