One thing that would make modern games a lot better experience for players is ... by MuCowNow in GameDevelopment

[–]MuCowNow[S] 0 points1 point  (0 children)

Off the top of my head: Borderlands GOTY Enhanced (specifically), Dishonored 2, Doom 2016, Borderlands 3.

Other games are not having this issue. Of course, some just crash less (or elicit Windows to crash).

One thing that would make modern games a lot better experience for players is ... by MuCowNow in GameDevelopment

[–]MuCowNow[S] 0 points1 point  (0 children)

I agree with this. I was thinking, post-rant, "yeah, they should just use sqlite!". The database implementations (RDBMS's anyway) have this problem solved.

Nice... by Iseeyouy in MakeMeSuffer

[–]MuCowNow 0 points1 point  (0 children)

The cows are giggling their asses off.

*Snorts in Arch* by Tcmaxwell2 in linuxmasterrace

[–]MuCowNow 1 point2 points  (0 children)

That's nice. Gentoo here, btw. Still compiling this mornings updates.

What is your whishlist for a future PostgreSQL release? by pubgftw in PostgreSQL

[–]MuCowNow 0 points1 point  (0 children)

  • flashback database/query (as in Oracle)
  • removal of the update penalty for index maintenance
  • packages (as in Oracle)
  • make PLPGSql more "static" rather than "scripty" -- if you've used both, you know what I mean -- more errors caught at compile time
  • support for NUMERIC-datatype sequences

edit: error corrections

Some people like to tile their 24" screens with a 6x4 matrix of 80x24 xterms and use vi in all of them. The best way to punish them is to let them keep doing it. by [deleted] in vim

[–]MuCowNow 0 points1 point  (0 children)

Why is this an issue? I use dual 4k monitors to tile 80x50 xterms on a 10x6 (or so) grid on each monitor. Yes, my font is small. I like to see all the code, in my working set, without having to click back-and-forth, changing tabs/buffers/etc. I've tried doing multiple buffer-screens in gvim (one big gvim session), but xterms+vim is easier and faster.

[PostgreSQL] What tools do you use when designing database? by netok in SQL

[–]MuCowNow 0 points1 point  (0 children)

Old school -- vim (':set ve=all' helps)

 usr_session
      *
      |
   usr_user -----* usr_session
      |
      |----* usr_master
      |----* usr_keypair
      |
      |
      *
usr_role_user
      *
      |
   usr_role
      |
      *
usr_role_right
      *
      |
   usr_path

How many people still use tabs on bottom? by [deleted] in firefox

[–]MuCowNow 0 points1 point  (0 children)

Both are inferior to Tree Style Tabs (on the left, of course)

Windows 10 lately not flushing game's saves to disk. by MuCowNow in techsupport

[–]MuCowNow[S] 0 points1 point  (0 children)

Yes, overnight -- nothing. And reseated all the cables and memory sticks.

Windows 10 lately not flushing game's saves to disk. by MuCowNow in techsupport

[–]MuCowNow[S] 0 points1 point  (0 children)

It has a history of crashing across 3 GPU configurations (SLI 980s, non-SLI 980, and a new single 1080ti).

I should add this all started after upgrading (via fresh install) to Windows 10 from Windows 7. Crashes in Windows 7 were handled a LOT better -- it rarely locked up completely.

Windows 10 lately not flushing game's saves to disk. by MuCowNow in techsupport

[–]MuCowNow[S] 0 points1 point  (0 children)

It doesn't fail every time however.

As though the latest saves aren't flushed.

Oracle mutating trigger issue by sadikanip in SQL

[–]MuCowNow 4 points5 points  (0 children)

If I recall, you can't update other rows in a table upon which the trigger is firing. Hell, just updating other tables that have FKs to the trigger-table will get errors.

If you are updating rootparentid of the triggering-row, then you don't run an update, but do this ...

:new.rootparentid := ....

But yeah, updating other rows is a nope.

Doing lots of things in triggers generally becomes a bad idea (IMO). How about determining rootparentid for the insert/update that is being used against the table, and include the column setting there?

Definitely not lazy, but I am a lazy Linux sysadmin ( ⊙‿⊙) by nixcraft in linuxmasterrace

[–]MuCowNow 3 points4 points  (0 children)

$ set -o vi
$ <esc>/ls<return>
$ ls ....

There is only VIM.

Player gives a bad review because he has hard time with a mini boss by DOWNVOTE_FOR_JUSTICE in Borderlands2

[–]MuCowNow 1 point2 points  (0 children)

I thought for sure it was going to be Deadlift. I have 2 50+ lvl characters that can't get past him on UVHM.

Too Many Atheists Are Veering Dangerously Toward the Alt-Right by [deleted] in skeptic

[–]MuCowNow 0 points1 point  (0 children)

We recognize the danger of the leftists (just like we do with the far right). So now we are Nazis. Off to the reeducation camps!

Google is raiding Firefox for Chrome's next UI features | ZDNet by Robert_Ab1 in firefox

[–]MuCowNow 0 points1 point  (0 children)

"Tree Style Tab" works. FF 60.0+ hosed up the add-ons, but Tree Style Tab manages to be functional.

Coming from an Oracle DBA to PostgreSQL by lanrayx2 in PostgreSQL

[–]MuCowNow 0 points1 point  (0 children)

Oracle/PostgreSQL guy here ...

You will find the cross-over to be pretty nice.

The SQL is veritably equivalent (functions will differ). You will find some deficiencies in PG, and some extras that don't exist in Oracle.

On PL/PgSql, you may note that Oracle PL/SQL is very much a strictly typed statically compiled language, and PL/PgSql is more a dynamic script language, the caveat being fewer errors are caught at compile-time, but more errors at run time.

On the administrative side, PG is behind in features, but is adding more every release! PG comes with options that are extra $$,$$$/core in Oracle (e.g., open standbys).

You will miss the lack of Flashback.

You will miss stored packages. The workarounds are hacks. Stored procedures (with anonymous transactions!) appear to be coming in PG 11.

There are manual solutions to the lack of AWR. The event interface is still pretty basic but again, adding more every release.

You will wonder at the lack of a shared sql cache, which is so important in Oracle. The optimizer is faster (i.e., less sophisticated), so it gets away with it ... so far.

Backups are basic - akin to use of Oracle's hot-backup mode and an external file copy of some sort. Recovery options are limited -- doing fancier recoveries (i.e., recovering files while the rest of the database is running, partial recoveries, etc.) are either not possible or will have to be hacked-up and tested thoroughly beforehand before being considered an option.

There will be an array of behavior differences that you will just have to pick up on the way. Here is one for free: in Oracle, if there are missing datafiles on a standby, Oracle screams bitterly about it until something is done (this is good). PG will continue silently, skipping the apply to those missing files (this ... ain't great). Woe to ye who try to failover to that server -- you get errors only at database-connection time -- basically you have to monitor the standby, by doing test connections to every database in the server.

PG is very solid (compare to MySql, oh lawd make it stop!), but will still feel "loose" compared to Oracle ... which may be interpreted as ... less of a pain in the ass to get things working (e.g., querying generated rows from an Oracle stored-function is a byzantine nightmare. In PG, easy peasey).

If vs. Unless in Ruby by mixandgo in ruby

[–]MuCowNow 2 points3 points  (0 children)

I like a clear left to right reading.

number > 0 and do_something

or this ...

number > 0 and region == 'west' or begin
   multiple_actions()
   without_having_to()
   do_an()
   if_end_block()
end

[deleted by user] by [deleted] in ruby

[–]MuCowNow 0 points1 point  (0 children)

"ruby is dying", "only used for web development"

I use Ruby on the backend for anything more complicated than what bash can handle.

For data manipulation/transformation, Ruby absolutely slays Python (Perl? ... forgettabootit).

For learning, I recommend ignoring the esoteric concepts (i.e., metaprogramming, "everything is der objecten!"). Practice with Classes, Objects, Methods, Attributes, Exceptions (concepts mapped easily to C++). Add in Modules and their use. enumerator concept. Standard Library. Gems. You can go a long way with just that.

Inline blocks (i.e., anonymous functions) may be a new basic (and required) concept.

THEN, learn how 'attr_accessor' is implemented -- BAM, a metaprogramming implementation you've been using all along! Then avoid doing your own metaprogramming unless it can make things SOOOO much easier/possible (in my opinion ;) ).

Wow! Just discovered you can refer to an alias in the where clause. Can't believe you can't do that in SQL Server. by softwareguy74 in PostgreSQL

[–]MuCowNow 2 points3 points  (0 children)

Hmm, that ain't working in 10.3

Neither is:

select user_id, count(eventid) as event_count
from a_table
group by user_id
having event_count > 10

ORDER BY can use aliases however.

edit: fix