• Introducing the Flexible Data Type in SQLite Database

  • By: Djoni Darmawikarta
  • Narrated by: Virtual Voice
  • Length: 34 mins

Access a growing selection of included Audible Originals, audiobooks, and podcasts.
You will get an email reminder before your trial ends.
Audible Plus auto-renews for $7.95/mo after 30 days. Upgrade or cancel anytime.
Introducing the Flexible Data Type in SQLite Database  By  cover art

Introducing the Flexible Data Type in SQLite Database

By: Djoni Darmawikarta
Narrated by: Virtual Voice
Try for $0.00

$7.95 a month after 30 days. Cancel anytime.

Buy for $7.00

Buy for $7.00

Pay using card ending in
By confirming your purchase, you agree to Audible's Conditions of Use and Amazon's Privacy Notice. Taxes where applicable.
Background images

This title uses virtual voice narration

Virtual voice is computer-generated narration for audiobooks

Publisher's summary

When you, in SQLite database, create a table you have three choices in declaring the column datatype:

  1. with the datatype and STRICT option,

  2. without datatype, or

  3. with the datatype.

The first choice is just like what you can do in other relational databases. You must declare the datatype of every column, and the data you insert into the columns must be of the datatype declared. This is known as static data typing.

While other relational databases support only the first choice, SQLite offers the other two choices, the dynamic datatype's.

The second choice allows you to create a table without declaring the datatype of some columns or all columns. SQLite decides the datatype to store based on the value of the data. You can add any data value in the columns and even any different data value in different rows.

Even if you declare the datatype (the second choice), they are just your recommendation. SQLite treats them as preferred datatype; it still decides the datatype to store based on the value of the data.

As static or dynamic is specific to a table, in a database you can, to suit your database need, have a mix of static and dynamic tables.

If you want to learn about the SQLite data typing, both static and dynamic datatype, this is the book of choice.

It is a practical book, details of the data typing is clarified and demonstrated by SQL examples.

Love Books? You'll Love Audible.

Placeholder Image Alt Text

Transform your day

Replace endless scrolling with endless listening. Chores can be fun.

Placeholder Image Alt Text

Listen everywhere

Download titles to listen offline, wherever you are in the world.

Placeholder Image Alt Text

Carry your entire Library

Your stories go where you go. Audiobooks don’t weigh a thing.

Placeholder Image Alt Text

Listen and learn

Discover stories that can change your mind, your well-being, and your life.

Placeholder Image Alt Text

Reach your reading goals

You can’t turn pages while you drive—but you can press play.

Placeholder Image Alt Text

Find your niche

WIth thousands of titles to explore, there’s something for everyone.

Try for $0.00 $14.95 a month after 30 days. Cancel anytime.

What listeners say about Introducing the Flexible Data Type in SQLite Database

Average customer ratings

Reviews - Please select the tabs below to change the source of reviews.