database Archives - Page 3 of 10 - Simon Technology Blog

MySQL backup file. XB database backup restore

Today an old friend told me that his mysql backup file suffix .xb could not be restored, or it was restored with only tables without data, so I decided to try I did a backup and restore, and I sear

October 4, 2021By Simo Mysql Backup, database, file, mysql, Restore, XBLeave a Comment

What general guidelines and best practices are needed when designing a database for an application?

My question is about database modeling. I tried to look for this question in other database design questions on SO, but haven’t found it yet, so I’m asking here:

What are the general guidelin

October 3, 2021By Simo Software Design application, best, database, General, guidelines, practice, program design, remember, time, want, whichLeave a Comment

GRAILS – How to retrieve the latest created database entry?

I have the following classes and need to manually add the nextId field.

class SomeIdClass {
Family family
Integer nextId = 0
long timeCreated = new Date().time } So far, I have been trying t

October 2, 2021By Simo Search Engines create, database, entry, Grails, how to retrieve, latestLeave a Comment

Performance – Database Speed Optimization: There are very few tables, or a lot of tables with a few rows?

I have a big question.

Let’s take a company’s order database as an example.

Suppose this The company produces about 2000 orders per month, so, about 24K orders per year, they don’t want

October 2, 2021By Simo Performance a lot, database, few tables, line, Optimization, or number of lines, performance, speed, table, very smallLeave a Comment

Automation – How to automatically export the mysql database using phpMyAdmin

Can I use phpMyAdmin to automatically export a single database?

When I try to create a .sql file from an external script (such as php), the resulting .sql file looks clean, but it causes prob

September 30, 2021By Simo Auto-Test Auto, automation, database, export, how to use, mysql, PHPMYADMINLeave a Comment

Database – data aggregation in microseconds in KDB units

How to use the xbar function to aggregate the rows in a table in a 10-microsecond column. The table consists of the columns timestamp and val. For aggregation in milliseconds, I already know that I

September 30, 2021By Simo Design Pattern aggregation, data, database, KDB, microseconds, strips, UnitLeave a Comment

ASP.NET – Store dates hours in the database?

I’m writing a blog and want to display my posts in Eastern Time Zone. I think storing all UTC is the right way. This will bring some challenges:

>I have to convert all time from UTC to Easter

September 29, 2021By Simo Asp ASP, ASP.NET, database, Date, Medium, storage, timeLeave a Comment

Tag: database