Skip to main content

SQL Types

SQL Types

The SQL Types mobile app for Android is now available. It is a quick reference for SQL Professionals and Database Developers. 

SQL Types provides easy access to various database vendor supported data type documentation.

Check it out on the Google Play store.


Current supported database vendors:
  • PostgreSQL
  • Oracle
  • SQL Server
  • MySQL
  • SQLite


Comments

Popular posts from this blog

Artificial behavior, or intelligence?

Artificial behavior is an area of research that seems to have been missed, or skipped over, on the path that companies like Google are taking to develop artificial intelligence. They have also jumped straight to working on human intelligence. Why not start smaller first? What about a cat or dog, or an insect? An insect may not seem very intelligent, and companies are probably not interested because they can't make much use of an artificial insect intelligence, but simple insects are quite complex. It is also quite probable that they have a consciousness, the thing that makes them "alive". Though we don't know what consciousness is, it is thought to arise naturally as a result of the complexity of the brain. The interesting thing is that, if this is so (and it likely is), then there is no difference between a "live" human and an artificial human, a computer program that mimics the human brain. They are the same thing. We can say the same, then, of someth...

Collisions with line intersections

Collisions can be determined by testing for line intersections. Imagine a line representing the ground and an object above, falling down. At time t1 , take the center point  p1  of the object. At time t2 , move the object down and take the center point p2 of the object. If the line formed by endpoints (p1, p2) intersect the ground line, a collision has occurred. On a collision, reset the object to its original position before the movement. When a collision occurs, be sure to reset the object by the same point used to determine the line intersection. In this example, I use the center point, so the object should be reset by the center point, not its actual x, y (usually top left) coordinate. It is not always the case that resetting by the x, y coordinate is sufficient. This can be seen in the following picture. It can be seen that even if the object isn't moving, but its size changes, a line intersection can occur, and resetting the object to its x, y position will...