A database is any organized collection of data organized to provide efficient retrieval.
1
vote
1answer
61 views
Two implementations of website internationalization
I have attempted to create an internationalization system for my PHP framework that I'm working on.
For the purpose I decided I will be using MySQL to store languages and translations. Respectively I ...
1
vote
1answer
40 views
Basic CRUD DAO using JDBC to access my database
I have a basic CRUD DAO using JDBC to access my database. I using a connection pool to get a connection in each method and then execute my commands. In some scenarios for update ...
4
votes
1answer
45 views
A simple database
After failing miserably to get SQL to work with Haskell, I decided to try making my own system. It's fairly simple, but works well for simple jobs (I made it to handle highscores for a number guessing ...
6
votes
5answers
332 views
Transaction handling for multiple SQL statements
In this code I update two tables called Payment and SalaryTrans. First I insert records (Salary payments) to ...
4
votes
2answers
102 views
My first model test in PHPUnit
I've just created a test to create my table gateway class. I've written about 8 tests and all are passing. I'm hoping anyone can offer any advice on what to do next to make these better. This is quite ...
-2
votes
1answer
23 views
In T-SQL when creating a table with an identity column what data type should be used? [closed]
In T-SQL, when creating a table with an identity column, what data type should be used?
Should the data type be numeric, bigint or a different type altogether?
For example:
...
5
votes
3answers
74 views
Relational schema and query for multiplayer tabletop game
As an exercise, I was asked to design a database schema (for MS SQL Server) for a tabletop game. The requirements were simple: players compete in matches and there are specific match types (e.g. 1v1 ...
5
votes
1answer
70 views
Selecting template from database using organization ids
This is my first SQL post over here, and in fact, I have more or less the experience of a regular SQL programmer, except that the task at hand this time was way harder than normal.
I am expecting, ...
7
votes
2answers
41 views
Revision 2 - Step 1: PsychoProductions management tool project
I have been told by DBA.SE people that this was off-topic for DBA.SE and should be on CR.SE instead. So... here I submit this database schema design for my trusted fellow CRitters to review!
This is ...
1
vote
1answer
140 views
Base generic DAO to work with different POJO classes
Right now, I have base abstract GenericDAO class to execute CRUD operations with different kind of objects. I have Customer and Employee POJO classes which are used ...
1
vote
0answers
38 views
Wrapper for database queries [closed]
I had a written code in Python, which works with a database and selects information. Every function in my class creates a session and executes some queries (their quantity varies). Also, each such ...
11
votes
2answers
78 views
Revision 1 - Step 1: PsychoProductions management tool project
I started a project to build my own invoicing and management system to take the place of prohibitively expensive QuickBooks software. This will be broken down in 5 steps, with the current step in bold ...
4
votes
1answer
133 views
How do I add JDBC and Queue functionality to a simple server?
I would like to add some capabilities to the server. Firstly, it should accept and handle connections with multiple clients, so that there are no mixups between clients. Secondly, there should be ...
4
votes
3answers
147 views
Did you like my product?
I have the following MySQL query which selects product details and whether the viewing user likes them. I feel like it could be more efficient and that there is a more practical approach than using a ...
0
votes
0answers
7 views
Implementing locks to make Google Search API ACID (Transactional)
x-post from StackOverflow, but I realized this question might be a better fit for this community.
I'm working on an AppEngine project that requires flexible searches over a dynamic dataset, and ...
4
votes
1answer
69 views
Persistent key value store for Python using SQLite3
This is a module to implement a key value store in Python using SQLite3. Originally written to allow sharing of configuration among multiple threads that are already sharing a SQLite3 database, I have ...
2
votes
1answer
48 views
DB security and efficiency in WordPress plugins
I recently wrote my first WordPress plugin, which was also my first PHP project. After I was done, I didn't care for the code at all, so I have spent the past couple of days refactoring it. I'm trying ...
4
votes
1answer
115 views
My simple PDO wrapper class
I made a simple database class and I wanted to know if there are any improvements I could work on as far as readability, efficiency, methods and making it modular goes.
Any other suggestions are also ...
1
vote
2answers
62 views
Where to protect DB data against XSS injections?
To protect my web site against XSS injection, I am using OWASP Encoding Project.
Is it a good idea to protect all data retrieved in my DB to avoid XSS by going throuh all the data just returned by ...
2
votes
2answers
58 views
Managing and searching objects using tags
I wonder
Is it appropriate to hide imported classes (collections and UserDict in this case) from Python IDE (e.g. IPython)?
Is there a more efficient algorithm/implementation?
Please feel free to ...
2
votes
1answer
79 views
Security of authentication check for a blog
I am currently making a very big blogging system for my Website where I want really neat code! So, I was wondering: is this method safe/does it have any problems with security? Yes, I'll be encrypting ...
7
votes
3answers
476 views
Are these Java MySQL connection classes and methods implementation the optimal?
I got three classes for MySQL Database access/manipulation,
First : Conector. It has got methods for connecting, disconnecting, querying and updating db.
Second : ...
2
votes
1answer
55 views
Delivery geolocations query
I have the below MySQL query that does exactly what I need. But I am sure there are better queries that do the same thing.
If you see something very ugly or bad and have any suggestions, I will be ...
2
votes
1answer
85 views
Cleaning up nested promises in Cloud function
I am writing the Cloud function for Parse whose purpose is to update my database with a provided array of data objects. The main problem are the nested promises, which doesn't look right. Any help ...
6
votes
2answers
94 views
6
votes
2answers
148 views
My database class extends MySQLi
The following is a small class I extended MySQLi with. I'm going to use this in my upcoming projects, but my main reason to do this class is learning, so I would like to submit this for your review, ...
5
votes
1answer
38 views
Separating Duplicates from Uniques
I have a MySQL table with a very large data. What I need is to find and separate duplicates from the unique rows
Let's say this is my table:
...
3
votes
1answer
180 views
Flat-file DB with CRUD
I just finished writing a flat-file DB class for PHP which supports selecting, updating, inserting and deleting.
I was wondering if there are any ways to make it faster or if I'm doing anything the ...
3
votes
1answer
70 views
Appropriate way to create object for storing data in a ListView & Profiling
I'm creating a location based reminder application in Android using proximity alerts, geocoder, Google Maps API and their Places API.
Currently there is a default ...
2
votes
2answers
101 views
3
votes
1answer
278 views
7
votes
2answers
345 views
Using keywords async/await in database queries (Windows Phone 8)
I have a local database in Windows Phone 8 app. The app includes a lot of queries to the database and I don't want bad effect on the responsiveness of UI.
For ...
7
votes
3answers
438 views
Repository pattern review, question about when dispose the Context
I have a question about the Repository pattern. This is my repository:
...
4
votes
4answers
94 views
Music list program
I need a little help with improving my first Java program. I have programmed for about a month, so my code is quite messy. The program is a "Musiclist" program, with which you can add songs, edit ...
4
votes
1answer
205 views
In-memory data cache architecture for data transfer
I am writing a cron job to manipulate and transfer remote data.
I need to cache data from a table, process it, merge with previous table, iterate the process, and eventually send the result data to ...
1
vote
1answer
96 views
Updating visiting dates of each visitor
I am still a PHP beginner. Please review/improve my PHP code and reveal errors, typos and warnings.
...
1
vote
1answer
69 views
Data table class
so this is my code and I just want to improve it, I'm a beginner so I think there are some better and short ways to do what I did here. Any Ideas?
The code:
...
1
vote
1answer
76 views
Login and User Information Requests
I am trying to improvise a piece of code. The best is to get reviews from experts, so here I am.
Can you have a look? What do you think of it? Any suggestions? This code basically connects to a ...
5
votes
1answer
618 views
A Simple Cache class
“There are only two hard things in Computer Science: cache
invalidation and naming things.” -- Phil Karlton
That being said, I created this SimpleCache class which I intend to use to cache ...
1
vote
0answers
108 views
In-memory data cache architecture
I am designing a basic in-memory cache storage with a thin CRUD (actually CRD) interface. The design is inspired by backend solutions such as Parse and StackMob.
Main characteristics:
Cache ...
1
vote
2answers
875 views
SQL database design e-commerce
I am new to database design but am fairly familiar with SQL and its syntax. I want to create a database for an E-commerce website that will sell a single product type such as a shirt. They could be ...
4
votes
2answers
384 views
Implementation of OOP for retrieving list of objects from database
If I have a Person class that outlines the properties of a person and one of People that just contains a ...
1
vote
1answer
123 views
Database schema suggestions for a Minecraft logging plugin
This is my attempt at creating a database schema for a Minecraft logging plugin. I'm by no means a SQL expert, so suggestions would be greatly appreciated.
...
0
votes
1answer
75 views
API request and database insert
This is a pretty big undertaking for me with my basic skills, and I was kind of flying blind. It's basic in its intent: get a bunch of case info from a helpdesk app and put it into a database. There ...
2
votes
1answer
132 views
Insert or update a user in database
The code uses SQLAlchemy Core. However, what I want to know is if writing code in this pattern is recommendable.
...
7
votes
1answer
3k views
How to use ByteBuffer properly?
I am trying to use ByteBuffer properly with BigEndian byte order format.
I have couple of fields which I am trying to put together into a single ByteBuffer before storing it in Cassandra database.
...
2
votes
1answer
682 views
Builder pattern for Codeigniter ActiveRecord queries
I am using Codeigniter and it's ActiveRecord.
I had this idea for a base class that provided a generic getter/setter for doing simple queries on a database. I have a lot of database objects that ...
4
votes
2answers
126 views
2
votes
1answer
191 views
Building a simple database in Python
I choose to use a dictionary to store the variables for fast GET and SET commands. In my code, I have saved all of the open ...
1
vote
1answer
980 views
