I recently had someone ask me how to reorder the columns in a SQLite table. As you may be aware, the SQLite ALTER table does not have a lot of functionality compared to other databases and it certainly doesn’t have a way to do this.
Comments closedCategory: Database
All posts related to using databases.
Maybe you’ve heard the term SQL injection and how it can allow unintended database access. Here’s how a SQL Injection works and what you can do to avoid it.
1 CommentAre you a consultant that uses FileMaker to create solutions for your clients? Do you work in an office and use FileMaker to run your company’s business?
Comments closedEveryone loves SQLite. It is everywhere, it is fast and it is easy to use. Want to know how to make it even faster?
Comments closedXojo Cloud has always taken the headaches out of setting up, securing, maintaining and deploying servers for web apps. Now Xojo Cloud servers are better, stronger and faster- all for the same great price!
Comments closedFormatting SQL for display can sometimes be a pain, particularly for the many different flavors of SQL. One easy way to do the formatting is to use a web service.
Comments closedSerious about cross-platform development? Consider going Pro with Xojo. Whether you are new to Xojo or looking to upgrade your existing licenses, Xojo Pro is the best way to take advantage of everything Xojo has to offer.
Comments closedI was up hours later than I should have been last night reading The Martian when, after discussing in detail how to hack some really old software in some really old equipment located about 54.6 million kilometers away, I read this line: “âJesus, what a complicated process,â Venkat said. âTry updating a Linux server sometime,â Jack said.”
And my first thought was, “Oh!, that’s why we offer Xojo Cloud!”
Comments closedPasswords are a problem, as we frequently see in the news when databases containing password and login information are hacked and exposed.
Though too much security is never enough, as developers, there are things we can do to keep our users’ passwords secure.
Comments closedThese days, businesses need to adapt to changes quickly and they need their software to do the same. They need it developed and updated in less and less time. This speed and adaptability is key to what Rapid Application Development tools offer developers.
Comments closed