LTA's Official MRT Map Dec 2024

Singapore’s Land Transport Authority has just released an updated official MRT map including one additional station on the North East Line (NEL): Punggol Coast Line. Punggol Coast station will now be the terminating station replacing Punggol station.

Updated: Singapore Bus Arrival Timing

Get accurate and real-time bus arrival information for public bus operators in Singapore, including SBS Transit, SMRT Buses, Go-Ahead Singapore, and Tower Transit. Our app provides you with up-to-date details on when the next bus will arrive at your stop, helping you plan your journey efficiently.

Key Features:

⭐ Star Your Favourite Bus Stops: Save your favourite bus stops for quick access, and easily rearrange them by dragging starred items up or down.

⛯ Find Nearest Bus Stops: Discover bus stops within walking distance, making your commute even more convenient.

🔍 Search Functionality: Quickly locate bus stops by bus stop number, bus service number, or road name.

📍 Bus stops plotted on map: Tap on a bus service number and voilà, its route and stops appear like magic on the map.

🚇 View the full MRT/LRT Network Map right in the app.

🔔 Train Service Alerts: Receive important train service advisories and alerts through push notifications, so you're always in the know before you travel.

📷 Traffic Cameras for Expressways & Checkpoints: Now you can view real-time traffic conditions before you head out. Check the cameras to plan a smoother, stress-free journey.

⟳ Automatic Updates: Stay informed with regular automatic updates for bus services and routes. Customize the update interval on our Settings page to suit your needs.

Please note that we are an independent app and are not affiliated with the Singapore government, Land Transport Authority (LTA), SBS Transit, SMRT Buses, Go-Ahead Singapore, or Tower Transit in any form.

Download [ Singapore Bus Arrival Timing ] now!

Singapore Bus Arrival Timing - Privacy Policy

Terms Of Use

By downloading or using the app, these terms will automatically apply to you - please read them carefully before proceeding.

We are providing this app for your personal use at no cost. However, the app itself, along with all trade marks, copyright, database rights, and other intellectual property rights associated with it, remains the property of hongjun.sg. Specifically, all content within the app, including images and videos, is owned by hongjun.sg and must not be reproduced in any form.

You should be aware that you may not distribute the app to others, nor are you permitted to copy, translate, or modify the app, any part thereof, or our trade marks in any manner. You are also prohibited from attempting to extract the app's source code.

We do not accept any liability for injuries, damage, or losses that may arise from your use of the app.

Privacy Policy

What information does the Application obtain and how is it used?

User Provided Information

Nil

Automatically Collected Information

Nil

Does the Application collect precise real time location information of the device?

Nil

Do third parties see and/or have access to information obtained by the Application?

Nil

Singapore Bus Arrival Timing [ Android App ]

LTA's Official MRT Map 2024 (Thomson-East Coast Line)

Singapore’s Land Transport Authority has just released an updated official MRT map including seven new stations on the Thomson-East Coast Line (TEL): Tanjong Rhu, Katong Park, Tanjong Katong, Marine Parade, Marine Terrace, Siglap, and Bayshore. It shows where the stations are and how they will connect to other MRT lines.

Useful openssl commands to generate certificates and keys

I hope the following will come handy when it comes to generating key pairs and certificates.

# Generate a Private Key
openssl genrsa -out privatekey.pem 2048

# Generate a self-signed certificate
openssl req -new -x509 -key privatekey.pem -out self_signed_certificate.pem -days 365

# Convert PEM certificate to CER format
openssl x509 -inform PEM -in self_signed_certificate.pem -outform DER -out self_signed_certificate.cer

# Convert a PEM certificate to a PFX (PKCS#12) file
openssl pkcs12 -export -out certificate.pfx -inkey privatekey.pem -in self_signed_certificate.pem

# Extract a private key from a PFX file (contain bag attributes)
# openssl pkcs12 -in certificate.pfx -nocerts -nodes -out privatekey_frompfx.pem
openssl pkcs12 -in certificate.pfx -nocerts -nodes -out privatekey_frompfx.key

# Extract a private key (no bag attributes) - identical to privatekey.pem
openssl rsa -in privatekey_frompfx.key -out privatekey_frompfx.key

# Extract public key from key pair
openssl rsa -in privatekey_frompfx.key -pubout -out publickey.key
#openssl rsa -in privatekey.pem -pubout -out publickey2.key

# Convert CER to CRT
openssl x509 -inform DER -in self_signed_certificate.cer -out self_signed_certificate.crt
#openssl x509 -inform PEM -in self_signed_certificate.cer -out self_signed_certificate.crt

# Convert CRT to CER
openssl x509 -in self_signed_certificate.crt -outform DER -out self_signed_certificate2.cer

#####
# Generate a Certificate Signing Request (CSR) - optional if going to generate a self-signed
#openssl req -new -key privatekey.pem -out certificate_request.csr
#openssl x509 -req -in certificate_request.csr -signkey privatekey.pem -out self_signed_certificate3.crt

Oracle: Find out total number of records of all tables

An efficient method to find out the total record counts of all tables in an Oracle database.

select table_name,
  to_number(extractvalue(xmltype(dbms_xmlgen.getxml('select count(*) c from '||owner||'.'||table_name)),'/ROWSET/ROW/C')) as count
from all_tables
where owner = 'SchemaName';

Hope it helps.

MSSQL: Find out total number of records of all tables

An efficient method to find out the total record counts of all tables in a MSSQL database.

SELECT tbl.name, CAST(p.rows AS int) 'count', tbl.schema_id, SCHEMA_NAME(tbl.schema_id) schema_name
FROM
  sys.tables AS tbl
  INNER JOIN sys.indexes AS idx ON idx.object_id = tbl.object_id AND idx.index_id < 2
  INNER JOIN sys.partitions AS p ON p.object_id = CAST(tbl.object_id AS int) AND p.index_id = idx.index_id
--WHERE ((SCHEMA_NAME(tbl.schema_id) = 'dbo'))
ORDER BY 2 DESC

Hope it helps.