What effects does using a binary collation have?

While answering this question, I became uncertain about something that I didn’t manage to find a sufficient answer to. What are the practical differences between using the binary utf8_bin and the case insensitive utf8_general_ci collations? I can see three: Both have a different sorting order; _bin‘s sorting order is likely to put any umlauts to … Read more

Share SQLite database between 2 android apps?

I need to share a single database between 2 apps. I know that the database will be created on /data/data/MY_PACKAGE/databases/ . Since the packages names are different is it possible to define the path to one package name when I create the database on either app? Thanks. Answer UPDATE: The method described below relies on … Read more

Where to find practical well-designed database schema examples to learn from? [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 8 years ago. Improve this question I am new to database schema design and I want to learn more about how a well-designed database scheme … Read more

PreparedStatements and performance

So I keep hearing that PreparedStatements are good for performance. We have a Java application in which we use the regular ‘Statement’ more than we use the ‘PreparedStatement’. While trying to move towards using more PreparedStatements, I am trying to get a more thorough understanding of how PreparedStatements work – on the client side and … Read more

Job for mysqld.service failed See “systemctl status mysqld.service”

Console says [root@ip-172-31-18-2 mysql]# service mysqld start Starting mysqld (via systemctl): Job for mysqld.service failed because the control process exited with an error code. See “systemctl status mysqld.service” and “journalctl -xe” for details. mysqld.service [root@ip-172-31-18-2 mysql]# systemctl status mysqld.service ● mysqld.service – SYSV: MySQL database server. Loaded: loaded (/etc/rc.d/init.d/mysqld) Active: failed (Result: exit-code) since Sat … Read more

How do I create a HashCode in .net (c#) for a string that is safe to store in a database?

To quote from Guidelines and rules for GetHashCode by Eric Lippert: Rule: Consumers of GetHashCode cannot rely upon it being stable over time or across appdomains Suppose you have a Customer object that has a bunch of fields like Name, Address, and so on. If you make two such objects with exactly the same data … Read more

Microservices with shared database? using multiple ORM’s? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed 1 year ago. Improve this question I’m learning about microservices and I’m gonna build a project with a microservices architecture. The thing … Read more