Symfony2: get the id of the persisted object
Symfony2 with Doctrine as default ORM will automatically generate an ID after data stored in database. So you can call the ID by ->getId() $id = $person->getId();
database
escaping dash in username
Double quotes is what you should use – not single quotes. grant all on osm_polygon_view to “www-data”;
Django: Detect database backend
OK, so there’s two ways of doing it, as @Ricola3D said there’s the option of checking settings.DATABASES[‘default’][‘ENGINE’]: >>> from django.conf import settings >>> settings.DATABASES[‘default’][‘ENGINE’] ‘django.db.backends.sqlite3’ or ‘django.db.backends.postgresql_psycopg2′ But there’s also an (undocumented) vendor property on a connection: >>> from django.db import connection >>> connection.vendor ‘postgresql’ or ‘sqlite’ Either way works. I personally prefer connection.vendor as … Read more
Group by multiple columns in Laravel
Did you try: $routes = DB::table(‘route’) ->groupBy(‘rte_origin’, ‘rte_destination’) ->get(); Can’t test here right now, but the API says groupBy() accepts an array. For reference, please visit: Laravel 5.0: https://github.com/laravel/framework/blob/5.0/src/Illuminate/Database/Query/Builder.php#L1037 Laravel 4.2: https://github.com/laravel/framework/blob/4.2/src/Illuminate/Database/Query/Builder.php#L1017
Which is more expensive? For loop or database call?
In general, the fewer times you hit the database, the better. There are a number of reasons for this, including: The database will be able to optimize better if it can try to fetch everything all at once You remove all of the overhead of communicating with the database multiple times, which can be quite … Read more
Spring Security:password encoding in DB and in applicationContext
If you are choosing a hashing system yourself, rather than building an app using an existing database which already contains hashed passwords, then you should make sure your hashing algorithm also uses a salt. Don’t just use a plain digest. A good choice is bcrypt, which we now support directly in Spring Security 3.1 via … Read more
Are there any ORM tools for Haskell?
The library I have in mind is not an ORM, but it may still do what you want. If you want something that makes your database accesses safe while integrating things into your program nicely then try out HaskellDB. It basically looks at your schema, generates some data structures, and then gives you type safe … Read more
Should you make a self-referencing table column a foreign key?
Yes. Ensures that you don’t have an orphan (entry with no parent), and depending on usage, if you define a cascading delete, when a parent is deleted, all its children will also be deleted. Disadvantage would be a slight performance hit just like any other foreign key.
PostgreSQL unique indexes and string case
PostgreSQL is case sensitive. To do what you want create a function index. So say CREATE UNIQUE INDEX test_upper_idx ON mytable (UPPER(myfield)); That way when you use UPPER(myfield) in your query the index will be used. See this link