Linq – Left Join with VB.Net
Imagine you have to make a left join between the user table and the jobs table, where there may be no items related to the user table in the jobs table. Dim users = From…
PostgreSQL reset autoincrement field
ALTER SEQUENCE mytable_id_seq RESTART WITH 1 If at the same time resetting a autoincrement field in postgresql we also want to empty the table, you can run this command: TRUNCATE TABLE mytable RESTART IDENTITY;
Transact SQL – While fetch example
Often a good example is worth more than 1000 words. Here’s how to run, on Sql Server, one for each / while in Transact Sql. DECLARE @Id INT DECLARE @Name NVARCHAR(50) DECLARE @LastName NVARCHAR(50) DECLARE…
Minify HTML API with PHP
Minimize HTML from an url with the .Maui APIs in PHP is quick, easy and free. It is necessary to register at dotmaui.com to get the free api key. To run this example, the CURL…
Register at dotmaui.com without your email with Telegram
.Maui respects your privacy. To register to our services, we will give you the opportunity to do so via Telegram, without giving us your email. To do so, look in Telegram and search for @DotMauiBot,…
Compile and run a Python file
If you simply want to compile a file or group of python files from the terminal, the py_compile module can run as a script as follows: python -m py_compile file1.py file2.py file3.py Actually, to run…
Set and read cookies within JSP
How to read and create cookies in Java within JSP pages. This example will write the value sel cookie “username”. If the cookie does not exist it will be created and will be visible once…
Free Wildcard certificates starting from 2018
Let’s Encrypt will begin issuing wildcard certificates in January of 2018. A wildcard certificate can secure any number of subdomains of a base domain (e.g. *.example.com). Wildcard certificates will be offered free of charge via their upcoming…
Postgresql enable remote access
To enable remote access to a postgresql database from a computer or server, in Ubuntu server, first we need to know the ip of the computer in question, for example 92.58.201.162. Then, from the terminal,…
How to know your IP address
To know your ip address just use one of the many services available online. This service is also available on dotmaui.com, free and without annoying advertising, at the address: https://dotmaui.com/my-ip/ For those who want to…