## database design – Is there a logical size limit to enum tables

I’m setting up a database to handle a FAQ page for different musical venues. The basic structure is:

``````id | venue_id | category | question | answer

``````

`category` links to an enum table so our app can allow users to filter questions. I am trying to decide if it makes sense to use an enum table for questions since all venues will be able to answer the same (optional) questions.

Our current design shows there could be around 200 total questions. Obviously this isn’t enough to cause any type of functional issue, but I am wondering if it is logical to have an enum table this large. What are the things that I should consider when making this decision?

Additionally, if questions are tied to a category would it make sense to eliminate the category all together in lieu of the question enum or is better not to bog a enum table down with more columns than neccessary?

## homological algebra – Limit in \$mathbb{Z} / P^{2} to mathbb{Z} / P \$

Consider the commutative diagram in Ab, where the morphisms are the canonical ones. Let us denote the top horizontal sequence by A and the bottom one by B. Then the vertical maps induce a morphism of abelian groups $$alpha : Lim A to Lim B$$. I am going to state which of the following statement are correct:

1. $$alpha$$ is bijective
2. $$alpha$$ is injective but not surjective
3. $$alpha$$ is surjective but not injective
4. $$alpha$$ is neither injective nor surjective.

However, I am having some trouble seeing what the limits are of both sequences as I am new to homological algebra. I believe the limit of A is $$mathbb{Z}$$ but I am not sure. Is this correct? I am also having some trouble seeing what the limit of B is, but I believe it could simply be 0. Is this correct?

Posted on Categories Articles

## web application – Is using proxies to circumvent rate limit to scrape data legal?

Im under the Indian jurisprudence and this is what the Indian Information Act of 2000/66F says on the matter,

Indian Information Act 2000/66F

Punishment for cyber terrorism.– Whoever,– with intent to threaten the unity, integrity, security or sovereignty of India or to strike terror in the people or any section of the people by–

(i) denying or cause the denial of access to any person authorised to access computer resource; or

(ii) attempting to penetrate or access a computer resource without authorisation or exceeding authorised access; or

(iii) introducing or causing to introduce any computer contaminant,

Since the administrator of the API has authorised only a certain number of API calls for a network, can it be construed as a violation of 66F clause 2 if we try to circumvent the rate limit even though the information is on public domain?

Posted on Categories Articles

## mysql – join two tables and limit results by an ordered list

problem:

given is a table with language support (translations)

a user can configure a list of languages (order is priority)

now i have to get all rows which are part of `app` and the `locale` is in the list of preconfigured languages for a user;

only ONE result per `property` shall be returned

so for example the user configured `de-AT, de-DE, de, en` as preferred user settings
NOTE: not all values need to be defined!

the user requests all data for `app='test'`
the expected result is

`````` property, value
('father', 'Oida'),
('lastName', 'Nachname'),
``````

Table for Multilanguage Data

``````CREATE TABLE IF NOT EXISTS `i18n` (
`id` INT NOT NULL AUTO_INCREMENT,
`app` VARCHAR(20) NULL,
`locale` VARCHAR(10) NULL,
`property` VARCHAR(20) NULL,
`value` VARCHAR(1000) NULL,
PRIMARY KEY (`id`)
);
``````

example values in `i18n` table

``````INSERT INTO `i18n` (app, locale, property, value)
VALUES
('test', 'de-AT', 'father', 'Oida'),
('test', 'de-DE', 'father', 'Papa'),
('test', 'de', 'father', 'Vater'),
('test', 'en', 'father', 'father'),
('test', 'fr', 'father', 'père'),
('test', 'en','lastName', 'last name'),
('test', 'de','lastName', 'Nachname'),
('test', 'fr','lastName', 'nom de famille'),
``````

my idea was to put user config into its own table (if its possible without this it would be even better)

Table for User Config

``````CREATE TABLE IF NOT EXISTS `i18n_cfg` (
`id` INT NOT NULL AUTO_INCREMENT,
`user` VARCHAR(20) NULL,
`locale` VARCHAR(10) NULL,
`priority` INT NULL,
PRIMARY KEY (`id`)
);
``````

example values in `i18n_cfg` table

``````INSERT INTO `i18n_cfg` (user, locale, priority)
VALUES
('de-AT', 'lm', 1),
('de-DE', 'lm', 2),
('de', 'lm', 3),
('en', 'lm', 4),
('de', 'hr', 1),
('en','hr', 2),
``````

i’m not really getting to a point
wheter i get only one result or way too much

## Set the limit of sent / received packets

My vps server provider limits me to 50,000 packets per second. After exceeding the number of packets, the link speed slows down to 1Mbit / s. Is it possible to set the ubuntu system not to exceed 50,000 packets per second?

## How can I find \$a^2+b^3-3\$ in this limit problem? Here $$a$$ and $$b$$ are constants.

How can I find the values of $$a$$ and $$b$$ because if we got the values of $$a$$ and $$b$$, we can easily calculate $$a^2 +b^3-3$$

## Animate and Command undead and the limit on commands

What is the limit to commands that can be given by each of these spells? (Animate undead, and control undead)

Can you tell the undead to listen to someone else?

How complex can their orders be? Command + Conditional?

Posted on Categories Articles

## 7 – reference field option limit “changing the explanation”

Hello I am using the reference field option limit module in D7 and I want to change the explanation text that says : No options are available for the current form values ..and I want to put instead: please select a value below. I tried hook form alter but the new phrase is appearing even when there is an option selected in the matching field, which is not what I want. So any idea which hook function should I use?
Ps: I don’t want to change that from the module core.

Posted on Categories Articles

## 8 – How to limit the results of a page viewed to content created since the flag date?

I created a custom module to display a news feed. When a content is created, the module will create a “Message”. The user “Flag” the parent “Group” and receives the messages.

My problem :

When a user flags a “Group”, he receives all the “Message”, even the “Message” before the Flag.

I want the user to only receive “Message” from the date of the Flag.

You must therefore filter the view like this:
The “Message” created after the Flag date are displayed.

How can I do this? I looked in the filter criteria and in the context filters, but it is not possible.

In a view, you can’t use a token in the filter criteria, so I’m completely stuck.  ## real analysis – Using Definition prove that following limit exists

Suppose that $$x_n$$ is a sequence of real numbers that converges to $$1$$ as $$n → ∞$$ Using Definition prove that following limit exists.
Here is my attempt but not sure , If it is wrong give me hint to prove its enough

(a) $$frac{x^2_n − e}{√n}→ 1 − e$$ as $$n → ∞$$

attempt

By hypothesis, given $$epsilon>0$$ there is an $$Ninmathbb{N}$$ such that $$ngeq N$$ implies $$|x_n-1|.

next apply $$epsilon=1$$ to choose $$ngeq N_2$$ implies $$|x_n-1|<1$$(i.e $$x_n<2$$)

$$|frac{x^2_n − e}{√n}- (1 − e)| =|frac{(x_n −1)(x_n +1)}{√n}+frac{1-e}{√n}-1 +e|$$

$$|frac{x^2_n − e}{√n}- (1 − e)|=|frac{(x_n −1)(x_n +1)}{√n}+frac{(1-e)(1-√n)}{√n})| leq |frac{(x_n −1)(x_n +1)}{√n}|+|frac{(1-e)(1-√n)}{√n}|$$

since $$|1-e|<2$$ and given $$ϵ>0$$ there is an $$Ninmathbb{N}$$ such that $$n≥N$$ implies $$|frac{1}{√n}|lt epsilon$$ so choose $$n≥N_1$$ implies $$frac{1}{√n}lt 1$$ so
$$|frac{x^2_n − e}{√n}- (1 − e)|<|frac{(x_n −1)(x_n +1)}{√n}|+2$$ since $$x_n+1<3$$ set $$N=max(N_1,N_2)$$

$$|frac{x^2_n − e}{√n}- (1 − e)|<3|x_n-1|+2<3epsilon+2$$

Thank you!!!

Posted on Categories Articles