Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
iracic
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
5 ms
·
1.
▲
by
iracic
3y ago
UN alarm about human rights violations https://www.ohchr.org/en/press-releases/2024/02/israelopt-un...
2.
▲
by
iracic
4y ago
You can't check complex cases with that.
3.
▲
by
iracic
4y ago
Yes, some are able to verify that execution plan already exists (saved in gather run or by explicit command) before replaning. Also you can group them with one label and activate only when needed. I guess that there must be a good number o
4.
▲
by
iracic
5y ago
Hi, yes, I assumed it would be the case. And it is not always easy to explain word terminations/cases. Especialy if you do not use it regularly or is limited to family interactions. I would guess your pronouncian might come from either
5.
▲
by
iracic
5y ago
It would be rather jedanaest, dvanaest, trinaest (at least in Croatian) - your version sounds how it is shortened in pronounciation in some regions. Also šezdeset with "z".
6.
▲
by
iracic
6y ago
There are lot more here. Idea is to put chances on your side in some possibly long and time constrained migration. How do you handle run that stops in the middle? How to avoid rerun of long running process that finished correctly but exite
7.
▲
by
iracic
6y ago
Access method is just part of the story. Same index may be accessed in different ways, you might also want to combine them. Sometimes you may change table join order to see how it estimates (or executes). Usually there are two parts 1) cost
8.
▲
by
iracic
6y ago
Some good points in article. There are some things that may need more attention. 1) Update from another table is not safe as it should be (in case of multiple values, final value will be sort of random) 2) Schemas as namespace separators
9.
▲
by
iracic
7y ago
It is possible to put database in state that is "ready" for snapshot, pushing changes to disk and sort of freezing I/O during snapshot.
10.
▲
by
iracic
7y ago
Hi, Can you share more details about #1 market position ?
11.
▲
by
iracic
7y ago
PostgreSQL, Golang, VueJS, old fashioned VMs
12.
▲
by
iracic
7y ago
>> The downside is that commits and rollbacks are slower Commit is not slower. Some part of the work is delayed, ex first SELECT after change may be involved to check & update row status in data block by peeking transaction state
13.
▲
by
iracic
7y ago
Seems promising. Thank you for info.
14.
▲
by
iracic
7y ago
Thank you for reply. Did you test some other sites before going to Google Translate?
15.
▲
Ask HN: Translation Service to Recommend?
7 points
by
iracic
7y ago
|
5 comments
16.
▲
by
iracic
8y ago
You can also record and save plan you are happy with. So, no need to fix hints in code. It is more flexible and may be practical when you upgrade version or environment changes.
17.
▲
by
iracic
8y ago
There is. When you need to treat your data without network delays. When performance is essential. When you can't express it efficiently with non-procedural SQL or need to have access with several technologies (can think of it as servic
18.
▲
by
iracic
9y ago
As someone who like down-to-earth first approach, I find it strange that reading about doing old-school way sounds, actually, refreshing. It would be interesting for anybody who builds starting from small blocks, do you have some blog about
19.
▲
by
iracic
9y ago
I use it for some time. No need to challenge your eyes with long lines or json values anymore. This kind of result presentation should be in each command line client. Very very useful.
20.
▲
by
iracic
9y ago
Dynamicaly adding filters or parts of the query, be able to have different parties to construct query, do transformations, replacing objects,... that would be great. And having it in well known, standard format and supported in languages, a
21.
▲
by
iracic
10y ago
Happy user of ux32vd here for 3-4 years. i7, upgraded ram to 10Gb. Disk is slower than it could be, short batery life ~3h. All in all I would buy it again.
22.
▲
by
iracic
11y ago
Handling requests can be tricky. Support site is very useful (althrough not a best example of user interface). Usually, you do not want to put your important stuff on first version of some release. Also new features, as somewhere said, are
23.
▲
by
iracic
13y ago
openshift
24.
▲
by
iracic
14y ago
I thought ratio based tuning is old-fashioned.
25.
▲
by
iracic
14y ago
You should write tests first.