Phil Hajjar

This is the second part in a tutorial series showcasing how to program database-driven applications using Python and MariaDB. In the first part of this series, we learned how to setup and configure a MariaDB database and installed a demo database table. you can read that database programming tutorial by visiting: Python Database Programming with […]

For decades, MySQL, and its later fork MariaDB, have been a go-to solution for developers looking for an easy-to-use zero-cost relational database solution for their applications. Many pre-built database-driven applications come with built-in support for MySQL. It is only natural that Python can almost seamlessly work with this database server and this article will demonstrate […]

Welcome back to the second part in our series on how to write SQL Server Data using the command line. In our first part of this database tutorial programming guide, we learned how to find SQLCMD.EXE, convert data to a CSV file format, and create a read-only user for MSSQL Server. In this part, we […]

If you have ever used Microsoft SQL Server (or MSSQL) and had the need to programmatically write data from a SELECT statement out to a file, you may have found that your options to do so are cumbersome and involve leaping through significant security-imposed hurdles that can make a developer nervous, as the last thing […]

There are many situations in which a budding developer will read all about how great and awesome a new technology is, and be excited to jump right into it. However, a common question crops up that has the potential to derail this embrace, and that question is: How do I get started? And with that, […]

For those familiar with a language like PHP or C++, it might be easy to conclude that C# provides “way too many” mechanisms for working with files. Between StreamWriters, TextWriters, and FileStreams, one might not know where to start, or which of these is “the best” mechanism for processing files in C#. The real difference […]