How To Get The Current Epoch Time (Unix Timestamp)

  Perl time PHP time() Ruby Time.now (or Time.new). To display the epoch: Time.now.to_i Python import time first, then int(time.time()) Java long epoch = System.currentTimeMillis()/1000; Microsoft .NET C# epoch = (DateTime.Now.ToUniversalTime().Ticks – 621355968000000000) / 10000000; VBScript/ASP DateDiff(“s”, “01/01/1970 00:00:00”, Now()) Erlang calendar:datetime_to_gregorian_seconds(calendar:now_to_universal_time( now()))-719528*24*3600. OR element(1, now()) * 10000 + element(2, now()). MySQL SELECT unix_timestamp(now()) PostgreSQL SELECT extract(epoch […]

Database Integration – some points to keep in mind

Always Have a Single, Authoritative Source For Your Schema Everyone should know where the official schema resides, and have a frictionless experience in getting a fresh database setup. One should be able to walk up to a computer, get the latest from source control, build, and run a simple tool to setup the database (in […]

Never use a shared database server for development work.

Like many conveniences in software development, a shared database is a tar pit waiting to fossilize a project. Developers overwrite each other’s changes. The changes I make on the server break the code on your development machine. Remote development is slow and difficult. Avoid using a shared database at all costs, as they ultimately waste […]