Workflow Website - Back-end Design Advice

Background: I'm beginning to architect/design a new website that will track the workflow of a large amount of projects. Each project will have phases assigned to them (planning, implementation, post-implementation, closing, etc...). Each of the phas...
more »

2017-01-16 16:01 (1) Answers

PHP SQL - left join + where + or

I'm improving my search bars in a project's back-office. I want to make a research in the protfolio table, joining the categorytable to include the category's names in the available keywords. Seems simple, but the only message I'll get is : Warni...
more »

2017-01-16 15:01 (1) Answers

How to sort by month, year in MySQL?

I have column of month and year that data type is varbinary. I tried: SELECT * FROM traffic WHERE '2015'<= year AND year <='2015' AND NOT ( ( 2015= year AND month <05) OR ( 2015= year AND month >11) ) ORDER BY Yea...
more »

2017-01-16 10:01 (4) Answers

Artificial key meaning in databases

What is the meaning of "artificial key" of an entity set in database design?Is it an attribute that is not natural to the entity set?Is it something assigned by a "global organization"?For example: Social Insurance number. Can you provide some brief ...
more »

2017-01-16 04:01 (1) Answers

Can I use Scrapy for scraping and parsing only?

I'm new to Scrapy and I've searched around, but can't seem to find any answers specifically for what I want to do. I'd like to scrape content from a pre-defined list of webpages (my growing list of bookmarks) and submit relevant content to a MySQL da...
more »

2017-01-15 23:01 (0) Answers

Mysql select UNIQUE row on column

I have a table as following:(Ex) id | vid | time ------------------------ 1 | 4 | 1333635317 2 | 4 | 1333635323 3 | 2 | 1333635336 4 | 4 | 1333635343 5 | 5 | 1333635349 I want to be just a row (the last row [ID: 4]) of t...
more »

2017-01-15 21:01 (1) Answers

Foriegn Keys Yah or Nah

Non F-K SCHEMA human human_id | name alien alien_id | name | planet comment comment_id | text 1 hello vote to_id | to_type | who | who_type 1 human 1 alien 1 comment 1 human FK- SCHEM...
more »

2017-01-15 14:01 (1) Answers

TSQL - Partition BY if in order

I am trying to partition by [Status] after it's sorted by [Status_DateTime] DESC. So only [Status] that are in a row will be partitioned in order to get the earliest Date for it. /****** Object: Table [dbo].[Order_Status] Script Date: 1/13/2017 ...
more »

2017-01-13 20:01 (2) Answers

Using partitioned indexes with partitioned tables

I'm trying to understand the optimal way to construct composite local partitioned indexes for use with partitioned tables. Here is my example table: ADDRESS id street city state tenant The Address table is list partitioned upon the tenant column....
more »

2017-01-13 18:01 (2) Answers

New field on Database user registration

Hi Guys i'm a student and have a problem! Hope someone can help! RingCaptha number get saved in the s_phone_land i try to add a field in the Database for this. I find all this files with s_phone_land File: ring_captcha/index.php I change this f...
more »

2017-01-13 09:01 (0) Answers

Cassandra Delete setting non-key fields to null

We are running batched delete statements on 5 tables using datastax java driver. We noticed that on some occasions, the record doesn't get deleted from one of the tables, instead the non-key fields are being set to null. We have been using the key c...
more »

2017-01-12 22:01 (0) Answers

Query with multiple joins and optional parameters

I have something of a Search App. There are 7 fields (first name, last name, phone, street, city, shop number, credit card number) where user can write parameters and it's gonna find him clients in the database. Everything is working with AND conditi...
more »

2017-01-12 21:01 (2) Answers

MySQL query to get Average data consumption

We need help in finding data like.. - In how many days "size" value of "type" abc will touch the "total" figure (50 in this example). Size of Type "abc" is increasing daily. There could be multiple entries in single date There could be m...
more »

2017-01-12 12:01 (1) Answers

Laravel 5 Updating record returns false

When I try to update record in db it doesn't update and it returns false. I can't understand what to pass as image position in $product->images()->update(); I can't use ids as search criteria, I must update by image index. <?php if (i...
more »

2017-01-12 04:01 (1) Answers

Yii2 + Redis as Database

I want to use Yii2 and redis as Database. so far, I got Redis ActiveRecord Class for Yii2 from Here. link1 link2 but, I got a problem. WHY THIS CLASS ADDS ANYTHING AS HASH IN REDIS???? Above that I cant Find in which pattern it Insert data. I add ...
more »

2017-01-11 14:01 (1) Answers

Many-to-many table with ID and Relation

I'm trying to build a database where an admin Can create lists that have can have tasks, now the tricky part is, all users can set tasks as completed, but only for himself. Here's my current scheme Is this a correct way of handling this? ...
more »

2017-01-11 13:01 (1) Answers

Writing in combobox

I have 3 comboboxes. At first I imported the number of stations. Example 11650, 13450 and more. When the user selects the number from the first combobox After automatically according to the station number in the second combobox After giving the date....
more »

2017-01-10 12:01 (2) Answers