Here at Xojo, we ❤️ SQLite so much – It’s truly a great database to use for all kinds of apps.
Here are 8 reasons why you should be using SQLite with your apps:
Comments closedCategory: Database
All posts related to using databases.
Whether you are new to building database applications or you need to expand your toolbox, Xojo is a smart choice. With Xojo you can build real, native apps. And Xojo’s powerful language allows for rapid app development while supporting a wide variety of databases and ODBC, plus it offers flexible form design, database binding, reporting and more.
Comments closed
PostgreSQL is an open source object-relational database system that’s had more than 15 years of active development. Here are 7 reasons you should be using PostgreSQL.
Comments closedSoundex is a phonetic algorithm for indexing names by sound, as pronounced in English. It is commonly used with databases to help with searching and is built-in to many database engines such as PostgreSQL and MySQL. SoundEx is not included with SQLite by default and there may be situations when you want to use it when searching.
Comments closedNoted recently at the SQLizer blog, the SQL language was first created 43 years ago. And what is remarkable about that is that SQL is still used today. According to the Stack Overflow 2017 developer survey it is the #2 programming language. Not many languages remain in use for such a long period of time. Although we’re happy to also note that Xojo celebrated our 20th anniversary in 2016!
Comments closedWorld Password Day brings attention to some simple steps everyone can take to secure their digital life: 1. Create Strong Passwords, 2. Use a different password for each account, and 3. Get a password manager, no, not a post-it note in your desk drawer!
The best password is one that is diffcult to guess. But difficult to guess takes on a new meaning when hackers use computers to do the guessing. Hence, the best password becomes one that would take a computer so long to guess that it’s not practical to do so. That means a long series of random characters and the longer and more random, the better, and a different password for every site you use.
Comments closedHere are the questions people asked during our February “What is Xojo” webinar. Did you miss the webinar? It’s less than 30 minutes and you can watch it right here:
Comments closed2017’s first “What is Xojo?” webinar was well received and there were lots of questions. Rather than include the questions in the video, I’ve included a…
Comments closed
I’ve ran into PostgreSQL case sensitivity myself before and I’ve seen it come up on the forums, so I thought it might be a good thing to bring up here.
Sometimes you hear that PostgreSQL is case-insensitive, but it isn’t really. What it actually does is convert your SQL to lowercase by default. So take a look at this SQL:
SELECT FullName FROM Person
This gets converted to:
SELECT fullname FROM person
That is nice if you happen to like to write your queries with mixed casing.
Comments closedXojo 2016 Release 3 adds support for SQLite’s latest full text search engine: FTS5. FTS5 has several improvements over SQLite’s previous FTS3 and FTS4 engines (that are still…
Comments closed