For instance, if you want to retailer textual content in a SQLite database, you’ll use the TEXT information type. If you’re working with PostgreSQL, you have many more options. This is a good example of PostgreSQL being barely more sturdy than SQLite, however the core concepts remaining the identical. We need to stress that the essential syntax you will be taught can be used in both methods.