Visual Studio 2010 SQL Server 2008 Database Project - Custom Updates

In Visual Studio, say you've got a SQL 2008 Database Project and you add a non-nullable column to a table. When you go to deploy the database now, if that table has data in it it should fail....

How can I insert values to msi table

I'm using Wix for intalling application & service, and I want to change the values in the msi table(session.database). I tried to do it with a custom action, I can select values from the table...

SQLAlchemy support of Postgres Schemas

We host a multitenant app with SQLAlchemy and postgres. I am looking at moving from having separate databases for each tenant to a single database with multiple schemas. Does SQLAlchemy support...

How to display an inputText when specific selectOneMenu option is selected?

I want to create settings panel for application. The application will store the settings values into database table. The settings panel will be used to display the settings and change the values....

PDOException: SQLSTATE[IMSSP]: error occurred translating string to UCS-2, using drupal 7 at azure and sql azure backend

I recently started setting up a drupal 7 website on Azure cloud using a web role and SQL azure backend. I was very much pleased until I hit a character set brickwall. I have a virtual machine with...

Large server-side data: JSON vs XML vs JSTL EL

I'm working with a web where many queries have to be performed to a MYSQL database. I use Java+Tomcat as development environment. I have tried different ways to solve this: At the beginning I...

Can you replicate a specific database or table using Amazon's RDS

We are using Amazon RDS and we have a MASTER replicating to a SLAVE. We want to create a new slave that will only replicate specific databases or tables from the master. By default RDS simply just...

Get country location by IP (IPv4,IPv6)

I've been testing some code that will allow me to block ads and videos to users from specific countries. This is nothing new and certainly should not be hard to do, however I can't sort it out to...

Get product weight from Wordpress

The code below is used to get data on a products of the category "books" in my Wordpress website using Woocommerce. <?php $args = array( 'post_type' => 'product', 'posts_per_page' => 200,...

How to extend available properties of User.Identity

I'm using MVC5 Identity 2.0 for users to log into my website, where the authentication details are stored in an SQL database. Asp.net Identity has been implemented in a standard way as can be...

Getting a SQL error when running "python manage.py migrate" using a MySQL database

I've been through the introductory tutorial for Django successfully using SQLite as per the instructions. However, for my real project I want to use MySQL, so I deleted the tutorial project files...

Value of custom field in sale.config.settings is not displayed in sales settings view

I try to add a new configuration field for sales configuration settings by inheriting the standard sales settings view/model using a custom module. Creating the field in the model works fine and a...

Laravel format DateTime from database result

My database stores two dates in the mysql DateTime format YYYY-MM-DD HH:MM:SS. When I get this data (with other strings etc), I want to convert it to another format, maybe DD.MM.YYYY HH:MM:SS and...

Authorisation in microservices - how to approach domain object or entity level access control using ACL?

I am currently building microservices based system on java Spring Cloud. Some microservices use PostgreSQL and some of them MongoDB. REST and JMS is used for communication. The plan is to use SSO...

woocommerce_checkout_update_order_meta action is not working

Hi today i was working with woo-commerce and i have successfully created some custom checkout fields as per user requirements but i am unable to save them in database. Here how i created custom...

Magento 2 custom product attribute won't save

I am writing a magento 2 module - am trying to get it to add a custom attribute to every product. My "Setup>InstallData.php" file is successfully adding the attribute to the "eav_attribute" table...

MySQL - Error 1118 Row size too large (> 8126) - No access to sql-config

I know this question is asked a lot and I also found a lot advice, but none that is practicable for me. My website is hostet on siteground.com. Everything works fine so far and suddenly I...

Altering unique fields of inherited Django model

In Django, I'm trying to create a base model that can be used to track the different version of some other model's data in a transparent way. Something like: class Warehouse(models.Model): ...

Is ASP.NET Core Identity needed for Intranet app using Windows Authentication

Using Windows Authentication in an Intranet web application I want to achieve the following: Gather additional attributes from AD (name, employee number) Gather additional attributes from a...

Add autoincrement column that is not primary key Alembic

I want to add a column that is autoincrement that is not primary key to an existing MySQL database. The command issued on the server required for this operation is the following: ALTER TABLE...

WorkManager custom constraint

Is it possible to set some custom constraints (conditions) on workers? In my case, I want the worker to be only executed when there are some data available in a table in Room database. I could...

Add or update data to existing database with entity framework

I am trying to create a custom migration step to clean up some default values in our database. Basically we have some data that is either invalid and needs to be updated and in other cases it...

Query Returns only 1 Row of Data in my PHP table

I have a query built, that when run in the MySQL app, shows all the expected results. However, when I go to loop through it in my PHP code, it only shows one row as result. No matter how I play...

.NET Core Custom User Properties with EF and Code First

I have created a test project where I am playing around with .NET Core 2.2 and Identity Framework 2.0. I have successfully created a project and adjusted some fields so that I understand how the...

Azure Event Grid Custom Topic Triggering on Insert to Azure SQL table

I am trying to use Event Grid to kick off an Azure Data Factory pipeline when a new record is inserted into an Azure SQL database table. But, I'm lost at the start of things. When creating the new...

Laradock mysqldump not found when executing artisan backup:run (Spatie Laravel Backup)

I have deployed a Laravel application with Laradock. I want to point out that the database connection works fine (users can register, login, ... etc.). In order to back up the application, I have...

Custom UI in react jsonschema form for ArrayFieldTemplate

I am using react jsonschema form in my application and handling an array in the response / request. What i have done is to use my custom UI instead of using {element.children} which through some...

How to properly delete a custom doctype in Frappe/ERP Next

What is the correct approach to delete custom doctype in Frappe? How to migrate the same in other servers and also what about database tables? Do we need to manually drop them? Currently for me...

PowerBi create an Editable Table

I would like to create visual within PowerBi which is an editable table (cf. something similiar to what Acterys offers). So after editing the new rows should be written back to the database. The...

Custom data type not getting assigned values for record creation

I wrote a custom data type by extending Abstract, like in the example listed for the following link: https://sequelize.org/v5/manual/data-types.html. Everything appears to work until I try to...