All posts of Blog category.
Boa noite pessoal,
Se você também está se batendo pra descobrir porque o seu Far Cry 3 está fechando do nada no Windows 8/8.1 e 10, saiba que basta desativar o serviço TabletInputService (Touch Keyboard and Handwriting Panel Service) lá no services.msc e jogar normalmente.
Caso não tenha encontrado o mesmo, é esse na imagem abaixo:
E aí pessoal,
Essa semana me deparei com um problema que rolou durante uma virada de migração de dados de um cliente novo aqui na empresa. O que aconteceu e que realmente eu acho um pé no saco é o fato do MySQL não exportar alguns caras que eu julgo bem importante, no caso as triggers, functions e procedures por padrão no momento do dump (mysqldump).
O nosso migrador por ventura esqueceu do parâmetro –routines depois de mergir as bases de dados, então quando o pessoal foi usar a aplicação logo pipocou uma exception dando falta de uma função para formatar telefones lá num relatório.
Para resolver esse caso para o cliente seguir com a sua vida, eu acabei fazendo um dump do nosso snapshot de referência:
|
1 |
mysqldump -u[user] -p[pass] --routines --no-create-info --no-data --no-create-db --skip-opt [database] > out.sql |
O arquivo out.sql contém apenas o create de todas as triggers, functions e procedures que há na base de dados informada, porém fico atento a um detalhe, ele não adiciona nenhum comando de DROP, então vale a pena prestar atenção na execução do script para ver se tudo ficou correto.
Abraços.
Hi there,
With you’re getting problems trying to open a SFTP connection over a non standard SSH port, such as 220, you can use -o args to pass port number, like this:
|
1 |
sftp -oPort=220 user.name@yourserver.com |
In -o argument, you can group all extra parameters for connection. If you want, you can see docs at:
http://linux.die.net/man/1/sftp
Atendendo aos pedidos dos folóverers do sitio do Twitter aqui vai a 18ª edição do Dicas de Nomes™. Peguem o caderninho e vamos lá:
Esta com certeza é a missão mais divertida do Far Cry 3, e o seu objetivo se resume em simplesmente queimar toda a maconha dos piratas da ilha. Uma pena que não apareceu no vídeo o personagem ficando embaralhada ao passar pela fumaça queimando.
If you are getting a black screen when you go to “Map” tab, you’ll need remove two files from your game folder. First go to the game folder then go to “data_win32”.
At this folder you’ll see two files named “patch.dat” and “patch.fat”. Now you just need remove or move those files. I prefer add “_backup” suffix to them. Finally you’ll have this:
Enjoy the game :)
To know about used space of each partition, we usually use df command. See example below:
|
1 |
df -h |
And we get a result like this:
|
1 2 3 4 5 6 7 8 9 10 |
Filesystem Size Used Avail Use% Mounted on /dev/sda8 68G 45G 20G 70% / none 4.0K 0 4.0K 0% /sys/fs/cgroup udev 7.8G 4.0K 7.8G 1% /dev tmpfs 1.6G 1.3M 1.6G 1% /run none 5.0M 0 5.0M 0% /run/lock none 7.8G 32M 7.8G 1% /run/shm none 100M 24K 100M 1% /run/user /dev/sda9 60G 15G 43G 25% /home /dev/sda1 496M 51M 446M 11% /boot/efi |
In some cases, we’ll add sudo before command to list partitions mounted by others users.
When we need to know about the size of each folder, linux provide us other special program called du.
|
1 |
du /home/user/some-dir/ |
Such as other programs, du has a lot of arguments and its can combined with other programs like sort.
|
1 |
du -h |
Now, to get some folders sorted by size, we can send ‘du -h’ output to sort program:
|
1 |
du -h | sort -h |
All folders and sub folders will be printed sorted by their sizes. If you limit by only first depth, you can use –max-depth arg.
|
1 |
du -h --max-depth=1 | sort -h |
You’ll get a output like:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
carlos@archpanzer:~$ du -h --max-depth=1 . | sort -h 4.0K ./Desktop 4.0K ./.freerdp 4.0K ./.gnome2 4.0K ./Music 4.0K ./Templates 4.0K ./.themes 4.0K ./Videos 8.0K ./.netbeans 8.0K ./.putty 8.0K ./.vim 12K ./.dbus 16K ./.adobe |
:)
Newest frameworks does all hard work for us, I known a lot of programmers, most commonly Java developers, that don’t know anything about SQL, they only know about what can do with their preferred persistence framework. EclipseLink, Hibernate and others, have a solid implementations to the most known databases. These implementations always use columns and tables aliases due framework mapping.
When we are working with reports using SQL, and not Java objects, is our responsibility to know about SQL ANSI and database specifics, like PostgreSQL schemas, PSQL on Oracle, etc. It’s in this time that many developers fall down. Generally they only know to write something like that:
|
1 |
SELECT * FROM bar ORDER BY createdAt |
Don’t be like those guys!
The query below doesn’t have problems, except if ‘bar’ is a giant table with a lot of row (millions or billions). But, the problem is when we need to join many tables, ambiguous columns are the first problem, followed by wrong columns on our select.
|
1 |
select id, name from product, category where category_id = id order by description |
In the query above, is so easy to identify possible errors:
When you name you tables, you don’t have these headaches.
|
1 |
select c.id, c.name, p.price from product p, category c where p.category_id = c.id order by p.description |
Another important point is about database scope, like on many programming languages, scopes delimit variables’ visibility. Sometimes, when you have sub queries, you’ll pay attention to it.
|
1 |
select * from product where id not in (select id from defective_product); |
Sometimes MySQL can run correctly, another one, it cannot, its just lose internally and doesn’t match the correct ‘id’ fields. One more time, aliases can save them:
|
1 |
select p.* from product p where p.id not in (select fp.id from defective_product fp); |
Follow these principles even when you have more than one nested sub query.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
select p.* from product p where p.id not in ( select fp.id from defective_product fp where fp.category_id in ( select cc.id from closed_category cc ) ) ; |
Believe, aliases can save you from a tons of problems.
If you’re installing an Ubuntu server, and you need set to it a static IP address and some nameservers, you can use the power of bash for it :). To set a static address for an interface, eth0 for instance, you can do this:
|
1 |
sudo vim /etc/network/interfaces |
And put in this file the lines as below:
|
1 2 3 4 5 6 7 8 9 10 |
auto lo iface lo inet loopback auto eth0 iface eth0 inet static address 192.168.0.10 netmask 255.255.255.0 gateway 192.168.0.255 dns-search someuri.com dns-nameservers 8.8.8.8 8.8.4.4 |
Pay attention for two last lines, those lines will be up your interface using those DNS nameservers. With it you don’t need to set a nameservers on /etc/resolv.conf, once on Ubuntu’s boot you erase all your modifications on it.
Comparing to CentOS, the boot process doesn’t replace dns-nameservers of /etc/resolv.conf, particularly I like it, I don’t see no reasons to Ubuntu clean this file.
