Özgür Özkök
Backend development involves creating and managing the server-side logic, databases, and APIs that power the functionality and performance of web applications.
Yazılım geliştirme süreçlerinde sıkça karşılaşılan, ancak çoğu zaman göz ardı edilen bir kavram olan teknik borç (technical debt), kısa vadeli çözümlerle hedeflere hızlıca ulaşma çabasının uzun vadede getirdiği maliyetleri ifade eder. Bu terim, yazılım geliştiricisi Ward Cunningham tarafından ortaya atılmıştır. Cunningham, teknik borcu, hızlı çözümlerle elde edilen avantajların, ileride daha […]
Oracle has taken a significant leap in database management by introducing JavaScript support for stored routines in MySQL. This groundbreaking feature is currently in preview and available in the MySQL Enterprise Edition and MySQL Heatwave. Integrating JavaScript into MySQL heralds a new era of efficiency and flexibility in database operations. […]
(I raised this because of query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (MySQLdb._exceptions.IntegrityError) The message you’ve encountered, “(raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (MySQLdb._exceptions.IntegrityError),” appears to be an error related to a […]
In the realm of database management, MySQL stands out for its robust features, one of which includes support for geospatial data. This is particularly useful for applications that need to store and query location data, such as mapping and location-based services. Two significant functions in this context are ST_SRID and […]
The MySQLdb._exceptions.IntegrityError using SQLAlchemy with a MySQL database indicates that an operation has violated some of the database’s integrity constraints. Here’s how you can approach resolving this issue: Remember to disable this in a production environment, as it can log sensitive information. By following these steps, you should be able […]
Amazon Web Services (AWS) Lambda is a serverless computing service that lets you run code without provisioning or managing servers. AWS Lambda automatically scales your application by running code responding to triggers such as changes to data in Amazon S3 buckets or updates in a DynamoDB table. It automatically manages […]
These are the seven habits of a highly effective software developer: Map out a timetable Creating a schedule helps you prioritize your tasks and allocate time efficiently. Setting aside time for learning new programming languages or technologies and working on projects is essential. A timetable will help you stay focused […]
Here’s a list of some of MySQL’s time functions with SQL samples: NOW() – returns the current date and time in the format ‘YYYY-MM-DD HH:MM:SS’ Example: SELECT NOW(); CURDATE() – returns the current date in the format ‘YYYY-MM-DD’ Example: SELECT CURDATE(); CURTIME() – returns the current time in the format […]
The MySQL IFNULL() function is handy for handling NULL values in your queries. It allows you to specify a default value to be returned if a NULL value is encountered. This can be helpful for a variety of tasks, such as: Body: Syntax of the IFNULL() Function The syntax of […]
What is a digital signature? This walkthrough demonstrates how to create a private key, public key, digitally sign a document, and verify. A digital signature and signing are critical concepts in cryptography and information security. Digital Signature: Signing (in Cryptography): Advantages of Digital Signatures: In the digital world, digital signatures […]