# I missed the memo on SQLite...

**URL:** <https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324>\
**Category:** General\
**Created:** [August 15, 2013, 9:35pm UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324 "2013-08-15T21:35:12Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Koua\_Lo](https://forum.xojo.com/letter_avatar_proxy/v4/letter/k/a6a055/32.png) [@Koua\_Lo](https://forum.xojo.com/u/Koua_Lo)\
**Post date:** [August 15, 2013, 9:35pm UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/1 "2013-08-15T21:35:12Z")

</div>

I have to admit that I have been away from RS/Xojo for well over a year so I am sure there was a memo on this somewhere. Why and what is the reason for changing/moving from RealSQLDatabase to SQLiteDatabase? They are both wrappers for SQLite, aren’t they? Will my old apps break if I don’t update my codes?

Thanks.

---

<div class="post-metadata">

**Author:** ![Bob\_Keeney](https://forum.xojo.com/letter_avatar_proxy/v4/letter/b/54ee81/32.png) [@Bob\_Keeney](https://forum.xojo.com/u/Bob_Keeney)\
**Post date:** [August 15, 2013, 10:37pm UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/2 "2013-08-15T22:37:22Z")

</div>

The difference is that REALSQLDatabase did some sql injection that would cause some queries to not work. The new SQLiteDatabase does not. That’s the big difference at least. If you had a primary key in all of your tables and you did not rely upon the internal rowid then you should be fine.

---

<div class="post-metadata">

**Author:** ![Greg\_O\_Lone](https://forum.xojo.com/user_avatar/forum.xojo.com/greg_o_lone/32/49_2.png) [@Greg\_O\_Lone](https://forum.xojo.com/u/Greg_O_Lone)\
**Post date:** [August 16, 2013, 8:45am UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/3 "2013-08-16T08:45:54Z")

</div>

We also needed to remove REAL from the name with the Xojo release.

---

<div class="post-metadata">

**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\
**Post date:** [August 16, 2013, 8:54am UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/4 "2013-08-16T08:54:32Z")

</div>

It is based on a new SQLite version (3.7.14.1.).

Note that the latest SQLite version is 3.7.17 since 2013-05-20 !

---

<div class="post-metadata">

**Author:** ![Koua\_Lo](https://forum.xojo.com/letter_avatar_proxy/v4/letter/k/a6a055/32.png) [@Koua\_Lo](https://forum.xojo.com/u/Koua_Lo)\
**Post date:** [August 16, 2013, 1:41pm UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/5 "2013-08-16T13:41:52Z")

</div>

Thanks.

---

<div class="post-metadata">

**Author:** ![Greg\_O\_Lone](https://forum.xojo.com/user_avatar/forum.xojo.com/greg_o_lone/32/49_2.png) [@Greg\_O\_Lone](https://forum.xojo.com/u/Greg_O_Lone)\
**Post date:** [August 17, 2013, 10:18pm UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/6 "2013-08-17T22:18:37Z")

</div>

@Emile Schwarz  
We don’t update just because there’s a new version available. If there’s something in the latest version that you need, file a feature request.

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [October 29, 2020, 4:48pm UTC](https://forum.xojo.com/t/i-missed-the-memo-on-sqlite/10324/7 "2020-10-29T16:48:30Z")

</div>


