database-agnostic
Is NOW() a stable function?
If I 开发者_运维知识库do INSERT INTO table1 (datetime1, datetime2) VALUES (NOW(),NOW()) Will the two fields always be identical in both columns?[详细]
2023-04-02 06:38 分类:问答Is converting database string enums to integers worth it?
There are two ways to store enum types in database: as a string or as an integer. Saving the enumeration ( sex = {male,female}, account_type = {regular,pro,admin}, etc. ) as strings makes things more[详细]
2023-03-20 20:32 分类:问答Implementing a Flexible Relationship in a RDBMS -- What really are the tradeoffs?
I have a bunch of products with a bunch of different possible attributes for each product. E.g. Product A has a name, size, color, shape. Product B has a name, calories, sugar, etc. One way to solve t[详细]
2023-03-15 01:49 分类:问答Difference between Restrictions.like and .ilike in Hibernate Criteria API
Hibernate\'s Criteria API has Restrictions.ilike function which has the following contract: A case-insensitive \"like\", similar to Postgres ilike operator[详细]
2023-02-14 17:42 分类:问答Index on a table you must fully scan anyway? (MySQL)
I\'m pretty stumped here. I have 2 tables and I\'m left joining the first (around 500k records) with the second (around 2.2 million records) in order to find out which records are in the first and no[详细]
2023-02-03 07:35 分类:问答how to allow your code to store undetermined number of columns?
I think my question might be unclear , but 开发者_如何学运维i would try to explain it by example .[详细]
2023-01-23 01:47 分类:问答Is it crazy to bypass database case sensitivity issues by storing original string case AND lower case?
I\'m implementing a database where several tables have string data as candidate keys (eg: username) and will be correspondingly indexed.For these fields I want:[详细]
2023-01-21 03:06 分类:问答The entity framework and database agnostic programming, possibilities?
We want to use the Entity Framework (.NET 4.0) to开发者_Go百科 build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too.[详细]
2022-12-28 07:14 分类:问答How can this SQL query code be broken/exploited by user input? [duplicate]
This question already has answers here: Closed 12 years ago. 开发者_运维问答 Possible Duplicate: Can I protect against SQL Injection by escaping single-quote and surrounding user input with s[详细]
2022-12-21 19:04 分类:问答What orm.xml features should be avoided to stay database agnostic?
I\'m embarking on an adventure in JPA and want to, inasmuch as possible, stay database agnostic.What orm.xml features should I avoid to stay database agnostic?[详细]
2022-12-21 08:47 分类:问答