Community driven content discussing all aspects of software development from DevOps to design patterns. SQLite is an incredibly lightweight and remarkably popular SQL-compliant database. In fact, it’s ...

Now that you've gotten a brief introduction to SQL, its time to get some hands-on practice connecting to a database and executing some queries. SQLite databases are stored as files on disk. The one we ...

We have seen how to read data from a file, either in unstructured text or CSV format, and how to write data in these formats. We’ve also seen how to read and write JSON. In this chapter we’ll see how ...

SQLite has an incredibly small footprint. The database itself, its DLLs and the complimentary diff and analyzer tools are less than 15 MB in size. It's perfect for small mobile devices, advanced ...

Southeast Asia consists of eleven countries that reach from eastern India to China, and is generally divided into “mainland” and “island” zones. The mainland (Myanmar, Thailand, Laos, Cambodia, and ...

When developing database-driven .NET and .NET Core, regardless of the database we intend to deploy in the end, we will often want to work with a database engine that is lightweight and fast, in order ...

You know how you join into the Zoom call with six other people in it, and everyone goes around introducing themselves? Most introductions are absolutely horrible. Although I’m a notoriously hands-off ...

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more. JDBC (Java ...